How to rebuild exim stats database

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.

Stop tailwatchd:

/scripts/restartsrv_tailwatchd --stop

Renamed 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

Restart tailwatchd

/scripts/restartsrv_tailwatchd --start