OnLineBackup: SSdbsave failed during an On-line Backup in CA Spectrum
Article ID: 118550
Updated On:
Products
Issue/Introduction
The OnLineBackup is failing, the following message is displayed:
"PROBLEM ENCOUNTERED WHILE RUNNING SSDBSAVE"The following error is found in the VNM.OUT after enabling the OnLineBackup in debug mode:
out 25 12:03:42 OLB TRACE at CsIHOB.cc(3955): Online Backup Debugging Enabled
out 25 12:04:12 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:12 OLB TRACE at CsIHOB.cc(908): DB Backup operation triggered on Primary SpectroServer.
out 25 12:04:12 OLB TRACE at CsIHOB.cc(946): Creating thread for Backup
out 25 12:04:12 OLB TRACE at CsIHOB.cc(963): Sending a message
out 25 12:04:12 OLB TRACE at CsIHOB.cc(3873): Performing Backup
out 25 12:04:12 OLB TRACE at CsIHOB.cc(3878): Model Handle - 0x100008
out 25 12:04:12 OLB TRACE at CsIHOB.cc(1574): Initializing temporary database directory
out 25 12:04:12 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:14 OLB TRACE at CsIHOB.cc(1688): Directory name - D:/CA/Spectrum/SS-DB-Backup/db_MLS_20181025_1204.SSdb.tmpdir
out 25 12:04:14 OLB TRACE at CsIHOB.cc(1689): File name name - D:/CA/Spectrum/SS-DB-Backup/db_MLS_20181025_1204.SSdb
out 25 12:04:14 OLB TRACE at CsIHOB.cc(1703): Done initializing temporary database directory - 0
out 25 12:04:14 OLB TRACE at CsIHOB.cc(1742): Copying the database
out 25 12:04:14 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:17 OLB TRACE at CsIHOB.cc(1768): Pausing VNM operations
out 25 12:04:17 OLB TRACE at CsIHOB.cc(1788): Copying database files
out 25 12:04:17 OLB TRACE at CsIHOB.cc(1821): Continuing VNM operations
out 25 12:04:17 OLB TRACE at CsIHOB.cc(1847): VNM was paused for 0 minutes,3 seconds
out 25 12:04:17 OLB TRACE at CsIHOB.cc(1869): Compress value set for backup DBs : 1
out 25 12:04:17 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:19 OLB TRACE at CsIHOB.cc(2077): Creating SSdb file
out 25 12:04:19 OLB TRACE at CsIHOB.cc(2091): Command to be executed : 000000007A61F168
out 25 12:04:37 OLB TRACE at CsIHOB.cc(2099): start_process_return_ticket return value : 0000000034B85388
out 25 12:04:37 OLB TRACE at CsIHOB.cc(2118): SSdbsave return bad exit code - -1073741819
out 25 12:04:37 OLB TRACE at CsIHOB.cc(2139): Done reading SSdb file - 6
out 25 12:04:37 OLB TRACE at CsIHOB.cc(1898): Done copying the database - 6
out 25 12:04:37 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:37 OLB TRACE at CsIHOB.cc(883): One of the OLB attributes(BackupNow, NextBackupDateTime, AutomaticBackups) change has triggered OLB.
out 25 12:04:39 OLB TRACE at CsIHOB.cc(3900): Done performing backup
out 25 12:08:04 OLB TRACE at CsIHOB.cc(3950): Online Backup Debugging Disabled
Environment
CA Spectrum 10.2.x
Cause
When trying to stop the SpectroSERVER, it got Terminated improperly resulting SSdb corruption.
Resolution
Restore a previous healthy SSdb backup. You can do this from either the Spectrum Control Panel (SCP) or via the command line as per:
- Go CLI (bash –login) as Spectrum install user and
cd $SPECROOT/SS
(you must be in the SS directory for this to work as running from other directories will result in an error) - Copy the saved backup of the SSDb (usually <db_name_datestamp.SSdb.gz>) to the $SPECROOT/SS directory and then uncompress it.
- Run the following command from the SS directory:
../SS-Tools/SSdbload.exe –il <db_name_datestamp.SSdb>
- Restart the SpectroSERVER.
Additional Information
To turn on OLB debug, see the following KB article:
Feedback
