Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    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','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,569
    Likes Received:
    45
    Trophy Points:
    308
    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).
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. pcsousa

    pcsousa Well-Known Member

    Joined:
    May 28, 2004
    Messages:
    63
    Likes Received:
    0
    Trophy Points:
    156
    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:
    151
    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:
    51
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice