It seems that NAME is defined as 40 char but you are inserting a string with 47 chars.
In fact your string is 45 chars that is out of space defined for the column.
In order to check the escaping logic you should try with a shorter strings.
Congrats
Hi Kurro,
this could work but the cost in terms of hw resources is high compared to $RANDOM.
Hi Enrico, the problem is that $r(4) returns number between 0 and 3.
If you add 1 you will have numbers 1 2 3 4 but not 5.
You can correct your code with $r(5)+1
You can use also a Storage Based replication method.
If your environment support it, you can:
If replica time is short enough this could be a very usefull method.
If you have enough free space and you use Linux LVM, you can also use the LVM Snapshot.
I agree with your comment, even if I didn't mentioned it.
Maybe he is using a VM so CommVault can be configured to take a snap on VMFS and copy it.
The bad is the logic in scripts, cause Commvault will not be notified of freeze is ok and to start the backup.
Yes, but only if it really fails.
Commvault should know of the backup cause it's do a backup.
The pre-script is used to configure the DB in freeze mode, so you can take a snapshot or a backup.
If the pre-script is ok it should return 0 so commvault can start the backup process.
After the backup completes commvault will launch the post-script, so the DB can return in normal way (thaw).
If the post-script is ok it must return 0 so commvault can understand that the process is completed.
I think you should reengineer your entire backup process with those steps in mind.
Your scripts are a bit complex but the backup pre-post command should return 0 if completed correctly.
So backup software can understand if the pre-command (preparation for backup) is completed ok.
If return code is 0 the backup can start saving data.
When backup completes commvault will start the post command.
Also the post command should return 0 if completed correctly.
In your script maybe it's better you should specify exit 0 when needed.
Hi Eyal,
I can't figuring how the system can now that a backup is started without the pre-post script on commvault.
Can you provide the pre-post script to understand what you would like to do?
Hello, have you configured some pre and post backup script?
As mentioned by @Brett Saviano the XFS is recommended on Ubuntu, but ext3 and ext4 are supported.
Read notes to choose the better.
LVM is also solid and in large environment, even if it introduce a little overread, it can be usefull in changing disks layout.
You can add space or move data without service disruption.
With FS on whole disks you must copy data files and this must be done with services down.
Thankyou, this is a good starting point for this task.
Hello, to better understand what is appening you can start with debbugging the ssh communication.
You can point to this doc to see if it helps: https://community.intersystems.com/post/using-and-debugging-netsshsession-ssh-connections
Very interesting starting point to understand how to collect performance informations.
Congrats also to participants
Hello, it's not so clear, but if you try to convert date to HL7 you can use this:
d.toISOString().replace(/[-:]/g, '').split('.')[0]This should generate a string with d in HL7 format.
Very interesting article on using this framework.
Good,
so the folder test under tmp is not writable by all. If your script runs under different user and goup (not r00028881) the file could be read and seen but not removed.
You can try to chmod 777 /tmp/test in order to understand if this is the problem.
If you can remove the file after the chmod you must understand who is creating the test folder under /tmp or who is running the script that is unable to remove the file.
Regards
Ambrogio
Hello Token,
this cannot be the output for your environment.
You are asking (with ls /tmp/test.txt -lh) to show the file or directory named test.txt in the /tmp folder.
As the result is-rwxrwxrwx 1 r00028881 r00028881 8 Jan 11 09:56 /tmp/test/test1.txt
it cannot be the answer for the previous command.
So, you should execute those commands:
ls -lad /tmp/test/test1.txt
ls -lad /tmp/test
ls -lad /tmp
Copy and paste the output so we can understand better the folders content.
Regards
Ambrogio
Hello Token,
are you sure file exists and you have right permission to remove the file?
Tipically err 13 on Unix is related to bad permissions
Hello Anastasia,
the first link is wrong.
It's https://youtu,be/w9HcEQ6GFvE but there is comma instead of dot.
Regards
Ambrogio
Oh, I see.
Unfortunally there is not Italian language available.
Great stuff!
it would be interesting to compare the results with Java script with 20.000 and 50.000 patients, in order to understand if IRIS is definitely better than others with more data.
Also the select should executed with more data, to understand if it's just a coincidence that PostgreSQL responce is better with more data.
Hello,
please, can you explain how to translate an article/question?
Regards
Very interesting - thank you.