tailwatchd UNIQUE constraint failed due to Exim too much retry

[manoaratefy]

Good morning,

I have issue with tailwatchd:

[4076048] [2020-11-06 06:48:30 +0100] [Cpanel::TailWatch::Eximstats] [ERR] SQL Failed with error ((XID gfmedq) The system received an error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”: SQLITE_CONSTRAINT (UNIQUE constraint failed: defers.sendunixtime, defers.msgid, defers.email)): INSERT INTO defers (sendunixtime,msgid,email,transport_method,message,host,ip,router,deliveryuser,deliverydomain) VALUES('1604600240','xxxxxxxxxxxxxxx','[email protected]','dovecot_virtual_delivery','Retry time not yet reached','','','virtual_user','xxxxxxxxxxxxx','xxxxxx.com')

After checking Exim log, I see that the issue is due to a lot of "Retry time not yet reached" of the same email in the log in the same time:

2020-11-06 08:15:45 xxxxxxxxxxxxx == [email protected] R=virtual_user T=dovecot_virtual_delivery defer (-52): Retry time not yet reached
2020-11-06 08:15:45 xxxxxxxxxxxxx == [email protected] R=virtual_user T=dovecot_virtual_delivery defer (-52): Retry time not yet reached

Is there a way to solve this issue? At this time, I'm just removing these lines from the log to make things working, but I have to do it frequently.

 

[cPRex]

For this issue it would likely be best to attempt a rebuild of the eximstats database. We have details on performing that work in our article here:

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 receiv...

support.cpanel.net

Can you try that and let me know how that goes?

 

[manoaratefy]

Good morning,

I already tried that but the exim stats database would only accept rebuild once time there is no duplicate lines on the Exim log (as the SQLite constraint doesn't allow a such thing). But the problem is that there are duplicates lines on the Exim log.

 

[cPRex]

Can you provide me with an example of the specific error you get when you try to perform the rebuild? Could you also send me an example of the duplicate lines in the log, with any sensitive data removed?