We are currently experiencing a higher than usual ticket volume, and as a result there may be delays before we can reply to your ticket.
Please feel free to reference the information available in our Forums, Documentation, and Knowledge Base in the meantime.

Skip to main content

How to rebuild exim stats database

Cody Selzer
  • Updated

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

 

Regenerate the database:

 

/scripts/slurp_exim_mainlog --force

 

Restart tailwatchd

 

/scripts/restartsrv_tailwatchd --start

 

Related articles

Comments

0 comments

Article is closed for comments.