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

Here you can find tutorials and notes for server-side maintenance/configuration

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

Postby lik » Mon Jul 27, 2009 10:21 pm

Code: Select all
ATTENTION ATTENTION ATTENTION ATTENTION

Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.
When mysql is unable to execute a query they are logged for processing later.
Eventually these SQL files may be handled automatically and this message will not appear.
In the meantime you can execute the queries as root with something like this:

  mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
  /usr/local/cpanel/bin/tailwatchd --restart
  mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy

Once you are sure all is well you can remove /var/cpanel/sql/eximstats.sql.tmp_working_copy

ATTENTION ATTENTION ATTENTION ATTENTION

Having done this, some errors may occur:
Code: Select all
# mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy
ERROR 1062 (23000) at line 831: Duplicate entry '2001-01-01 01:01:01-1MUuu4-00082J-0P-root@server.example.com' for key 1

You can use --force flag (Continue even if an SQL error occurs) to overcome duplicate entry error.

Alternative solutions:
Truncate records
Code: Select all
mysql -e "use eximstats;truncate smtp;truncate sends;"

Re-create 'eximstats' database and import default schema
Code: Select all
mysqladmin drop eximstats
mysqladmin create eximstats
mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql
lik
Founder
Founder
 
Posts: 497
Joined: Wed Dec 15, 2010 3:21 am

Return to Server Side Actions

 


  • Related topics
    Replies
    Views
    Last post