Replacing a Corrupted SQLite Database

If an unrecoverable database error occurs running a SQLite database you can replace the corrupted database with a new default one. This is only applicable if you are still using the embedded SQLite database and haven't moved to a more robust RDBMS for the Senzing repository. 

This can happen - for example - due to an improper hardware shutdown or software problem such as the the Linux kernel killing a Senzing process in an Out Of Memory situation.

A template version of the default Senzing SQLite database is available in <project_path>/resources/templates/G2C.db.template. Copy this template version to your projects SQLite directory.

• cp <project_path>/resources/templates/G2C.db.template <project_path>/var/sqlite/G2C.db

Warn

This should only be actioned if you are sure the embedded SQLite database is corrupt and you cannot connect to or use it.