How to rebuild exim stats database

Symptoms

If you are experiencing corruption in the sqlite database such as:

[2716099] [2020-08-19 04:00:23 -0300] [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error ((XID fjsv3e) The system received an error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”: SQLITE_CONSTRAINT (UNIQUE constraint failed: failures.sendunixtime, failures.msgid, failures.email, failures.deliveredto)):

You will need to rebuild the exim database.

Procedure

Stop tailwatchd

/scripts/restartsrv_tailwatchd --stop

Stop eximstats

/scripts/restartsrv_eximstats --stop

Move the eximstats database

mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite3.original

Recreate the database

/usr/local/cpanel/bin/updateeximstats

Import exim data

/scripts/import_exim_data /var/log/exim_mainlog

Regenerate the database

/scripts/slurp_exim_mainlog --force 

Restart eximstats

/scripts/restartsrv_eximstats

Restart tailwatchd

/scripts/restartsrv_tailwatchd --start