How to check data-integrity
This guide shows you how to inspect the data integrity of a possibly-running dqlite instance and locate faults.
Steps
- Type and run
dqlite-utils --dir /path/to/dqlite/dir. You will see thedqlite-utilsrepl start. - Type and run the
.opencommand. You will see the open shell at the ‘latest’ data version. - Type and run the following command
If no issues are detected, you will seePRAGMA quick_check;ok. If you believe issues exist, move onto the next command. - Type and run the following command
If no issues are detected, you will seePRAGMA integrity_check;ok.