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