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
Comments
0 comments
Article is closed for comments.