[Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql

The following error was generating to client related to eximstats sqlite database

[Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error ((XID f82uy4) The system received an error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”: SQLITE_CONSTRAINT (UNIQUE constraint failed: smtp.sendunixtime, smtp.msgid, smtp.email, smtp.deliveredto, smtp.router)): INSERT INTO smtp (sendunixtime,msgid,email,processed,transport_method,transport_is_remote,host,ip,deliveredto,router,deliveryuser,deliverydomain,counteddomain,countedtime,countedhour) VALUES(‘1575787697′,’1idqMb-00hujj-Ah’,’root@server.bunny.tech’,’2′,’dovecot_virtual_delivery’,’0′,’localhost’,’127.0.0.1′,’queue@bunny.tech’,’virtual_user’,’bunny’,’bunny.tech’,”,’0′,’0′)
[9035] [2019-12-17 17:47:50] [Cpanel::TailWatch::Eximstats] [SQLERR] Could not execute query, logging SQL to /var/cpanel/sql

Fixed by running following

mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite3.old
/scripts/restartsrv_tailwatchd
/scripts/slurp_exim_mainlog –force

Leave a comment