How to check data-integrity

Docs
1

This guide shows you how to inspect the data integrity of a possibly-running dqlite instance and locate faults.

Steps

  1. Type and run dqlite-utils --dir /path/to/dqlite/dir. You will see the dqlite-utils repl start.
  2. Type and run the .open command. You will see the open shell at the ‘latest’ data version.
  3. Type and run the following command
    PRAGMA quick_check;
    If no issues are detected, you will see ok. If you believe issues exist, move onto the next command.
  4. Type and run the following command
    PRAGMA integrity_check;
    If no issues are detected, you will see ok.