CHECKDB

Description

Perform an integrity check on the given database.

Command

Usage: checkdb [options] [action] [<DBPATH>]
       checkdb -h
<DBPATH> path to the db (default: /var/db/reports/reports.db)
Actions:
  -c [ --check_and_log ]                Check the database integrity and update its backup if not corrupted.
  -C [ --check_repair_backup_and_log ]  Check the database integrity, attempt to repair it if corrupted and update its
                                        backup if not corrupted (default).
  -r [ --repair_and_log ]               Restore the database from its backup. DBPATH must not exist.
Options:
  -B                    Don't create a backup of the database even if it pass the integrity check.
  -R                    Don't restart daemons once done.
  -v [ --verbose ]      Be verbose
Exit Status:
  0  (OK)          Success.
  64 (USAGE)       Bad usage.
  65 (DATAERR)     The database is corrupted and/or cannot be repaired.
  69 (UNAVAILABLE) Unable to restart some daemon.
  70 (SOFTWARE)    An internal error occured.
  75 (TEMPFAIL)    Lock prevent operating on the live database.
  78 (CONFIG)      Missing live database or lock file or unable to create backup directory.

Results

Example

foo> checkdb -v -C /var/db/reports/reports.db
[2022-09-07 11:20:57] [INFO ] [nbase_verbose   ] pid=99212 version=4.7.0 verbose is now ready
[2022-09-07 11:20:57] [INFO ] [CHECKDB         ] /var/db/reports/reports.db: Checking integrity of the live database...
[2022-09-07 11:20:57] [NOTIC] [CHECKDB         ] /var/db/reports/reports.db: Integrity check passed
[2022-09-07 11:20:57] [INFO ] [CHECKDB         ] /var/db/reports/reports.db: Updating backup database...
[2022-09-07 11:20:59] [NOTIC] [CHECKDB         ] /var/db/reports/reports.db: Backup database written to /data/Main/Reports/var/db/reports/reports.db.
[2022-09-07 11:20:59] [INFO ] [nbase_verbose   ] pid=99212 version= 4.7.0 verbose shutdown