- 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:[email protected]' 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
