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

pcsousa

Well-Known Member
May 28, 2004
63
0
156
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

cPanel Development
Staff member
Apr 7, 2006
4,607
79
458
cPanel Access Level
Root Administrator
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).
 

nakuls77

Member
Jul 22, 2008
9
0
51
India
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.