The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'General Discussion' started by pcsousa, Dec 16, 2008.

  1. pcsousa

    pcsousa Well-Known Member

    Joined:
    May 28, 2004
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    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','xx_hide_xx@hotmail.com',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 ]
     
  2. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    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).
     
  3. pcsousa

    pcsousa Well-Known Member

    Joined:
    May 28, 2004
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    6
    Thank you.

    Done:

    root@s [~]# mysql -u root -p -D eximstats < /var/cpanel/sql/eximstats.sql
    Enter password:
    root@s [~]# rm /var/cpanel/sql/eximstats.sql
    root@s [~]#
     
  4. Hoss

    Hoss Active Member

    Joined:
    Oct 15, 2002
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    When I treid to sort this error today using the above meathod. I recieved this error...

     
  5. nakuls77

    nakuls77 Member

    Joined:
    Jul 22, 2008
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    Seems like the entry for the following already exist in your database as it clearly shows that error.

    2008-12-17 02:10:45-1LCqYP-0007m1-8E-nobody@ben.bst-secure.com

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

Share This Page