Sysload Management Server: Database corruption
Article ID: 87176
Updated On:
Products
CA Automic Sysload
Issue/Introduction
Affects Release version(s): 5
Error Message :
Wed Aug 03 13:50:16 2016: LPtrVerif - OBaseOfObjects.c[1407] - Invalid Pointer Error
Patch level detected:Sysload Management Server 5.50
Product Version: Sysload 5.5.0
Description :Database's corruption sometimes occurs during Management Server upgrade (5.50 to 6.10).
Management Server could not start. The following message appears in the logs: database disk image is malformed
Error Message :
Wed Aug 03 13:50:16 2016: LPtrVerif - OBaseOfObjects.c[1407] - Invalid Pointer Error
Patch level detected:Sysload Management Server 5.50
Product Version: Sysload 5.5.0
Description :Database's corruption sometimes occurs during Management Server upgrade (5.50 to 6.10).
Management Server could not start. The following message appears in the logs: database disk image is malformed
Cause
Unknown cause
Environment
OS: Windows
Related configuration item(s): sld_objects_repository database
Related configuration item(s): sld_objects_repository database
Resolution
Database must be rebuilt to fix the corruption.
You need to download SQLite for Windows (https://www.sqlite.org/download.html) or transfer the database file to a Linux server.
1 - Check Database Integrity with Pragma command :
$ sqlite3 sld_objects_repository
sqlite> pragma integrity_check;
…
sqlite> .quit
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
rowid 1330553 missing from index sld_property_FKIndex1
rowid 1339729 missing from index sld_property_FKIndex1
rowid 1391484 missing from index sld_property_FKIndex1
rowid 2111800 missing from index sld_property_FKIndex1
rowid 2111810 missing from index sld_property_FKIndex1
rowid 2111810 missing from index sld_property_Index_PropName
wrong # of entries in index sld_property_FKIndex1
wrong # of entries in index sld_property_Index_PropName
wrong # of entries in index sld_object_FKIndex1
wrong # of entries in index sld_object_Index_key
sqlite>
2 - Rebuild database
$ echo .dump | sqlite3 sld_objects_repository > sld_objects_repository_repaired.sql
$ sqlite3 -init sld_objects_repository_repaired.sql sld_objects_repository_repaired
3 - Rename "sld_objects_repository_repaired" to "sld_objects_repository"
4 - Replace the corrupted database by the new "sld_objects_repository"
You need to download SQLite for Windows (https://www.sqlite.org/download.html) or transfer the database file to a Linux server.
1 - Check Database Integrity with Pragma command :
$ sqlite3 sld_objects_repository
sqlite> pragma integrity_check;
…
sqlite> .quit
SQLite version 3.7.17 2013-05-20 00:56:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma integrity_check;
rowid 1330553 missing from index sld_property_FKIndex1
rowid 1339729 missing from index sld_property_FKIndex1
rowid 1391484 missing from index sld_property_FKIndex1
rowid 2111800 missing from index sld_property_FKIndex1
rowid 2111810 missing from index sld_property_FKIndex1
rowid 2111810 missing from index sld_property_Index_PropName
wrong # of entries in index sld_property_FKIndex1
wrong # of entries in index sld_property_Index_PropName
wrong # of entries in index sld_object_FKIndex1
wrong # of entries in index sld_object_Index_key
sqlite>
2 - Rebuild database
$ echo .dump | sqlite3 sld_objects_repository > sld_objects_repository_repaired.sql
$ sqlite3 -init sld_objects_repository_repaired.sql sld_objects_repository_repaired
3 - Rename "sld_objects_repository_repaired" to "sld_objects_repository"
4 - Replace the corrupted database by the new "sld_objects_repository"
Feedback
Powered by
