Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in ...

[pcsousa]

Do you know how to solve this issue, occurring when restarting cpanel with "service cpanel restart"? The file /var/cpanel/sql/eximstats.sql contains many SQL queries related with email send stats like "INSERT INTO smtp (mailtime,msgid,email,processed) VALUES(FROM_UNIXTIME('1226785852'),'1L1T2Z-0002E0-6V','[email protected]',0);":

Starting cPanel Chat services:
Starting Melange Chat services:
Starting cPanel ssl services: Using Native SSL support (stunnel not needed)
[ OK ]
Starting mailman services: Starting Mailman's master qrunner.
[ OK ]
Starting tailwatchd: Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql at /usr/local/cpanel/Cpanel/TailWatch.pm line 67.
[Tue Dec 16 09:52:05 2008] Starting /usr/local/cpanel/libexec/tailwatchd daemon
Log is at /usr/local/cpanel/logs/tailwatchd_log
[ OK ]

 

[cPanelKenneth]

At some point the MySQL service was unavailable. The EximStats data the would normally be published to the MySQL database was save to /var/cpanel/sql

You need to import that data into the MySQL EximStats database then remove the data file. After that Tailwatch will no longer report that message ( until MYSQL is unavailable again which starts the process anew).

 

[pcsousa]

Thank you.

Done:

[email protected] [~]# mysql -u root -p -D eximstats < /var/cpanel/sql/eximstats.sql
Enter password:
[email protected] [~]# rm /var/cpanel/sql/eximstats.sql
[email protected] [~]#

 

[Hoss]

When I treid to sort this error today using the above meathod. I recieved this error...

ERROR 1062 (23000) at line 1: Duplicate entry '2008-12-17 02:10:[email protected]' for key 1

 

[nakuls77]

Seems like the entry for the following already exist in your database as it clearly shows that error.

2008-12-17 02:10:[email protected]

Do not worry your data has been imported, you just need to restart mysql & exim and all would be fine again.