Article ID
Product Version
Operating System
Symptom
When performing a backup job of any type on the AhsayOBM / AhsayACB client application, the following error message is received in the backup report:
No. | Type | Timestamp | Log |
---|---|---|---|
info | |||
* | info | YYYY/MM/DD hh:mm:ss | ... |
erro | |||
* | erro | YYYY/MM/DD hh:mm:ss | [SQLITE_CORRUPT] The database disk image is malformed (database disk image is malformed) |
Cause
This issue can occur if there is a corrupted index file on the backup set.
There are many factors that could trigger a backup set index corruption:
-
The machine where the backup job is running was previously shutdown / rebooted when a backup job was still running.
-
Disk issue on the computer where the backup is performed.
-
Unstable network connection between the backup computer and network temp folder.
-
Backup client application crashed during a previous backup.
-
Backup client application encountered an out of memory of "Java Heap Size" error during a previous backup.
Resolution
To workaround this issue, it is recommended to:
First, try deleting the current index files from the temporary folder on the backup machine.
-
Make sure there is no backup / restore job running.
-
Browse to the folder:
%temp_folder_path%\%backupSetID%\%destination_name%@%destinationID%\index\
-
Delete the current index file.
-
Perform a Data Integrity Check with rebuild index enabled.
-
Perform a manual backup again.
If the SQLITE_CORRUPT error persists, then it is recommended to use the following workaround:
Revert the set of index files on the affected backup set to a previous healthy version (e.g. ) check on the backup report to locate the last successful backup). The version should be no more than two days from the last occurrence of the SQLITE_CORRUPT error.
For example:
If the destination is on an AhsayCBS backup server, and you would like to revert to a previous good snapshot on "2020-10-19-15-00-28" for backup set with ID "1595563417075".
Copy the index files from:
${User_Home}\username\1595563417075\blocks\2020-10-19-15-00-28\index.db.8d000.1754aa9d758.cgz
${User_Home}\username\1595563417075\blocks\2020-10-19-15-00-28\index.db.id229637a.115b0i.8d000.1754aa9d758.cgz
to
${User_Home}\username\1595563417075\blocks\