Tailwatchd failed error on cPanel


Sometimes you get following email regarding Tailwatch service failed from cPanel. 

tailwatchd failed @ Wed Apr 10 16:35:03 2013. A restart was attempted automatically. 

Service Check Method: [check command] tailwatchd is not running

If you check Tailwatch logs, you will see the following logs:

Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in /var/cpanel/sql/eximstats.sql.

Fix: 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 order to fix the issue in the meantime, you can execute the following queries as root with something like this:

# mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy
# /scripts/restartsrv_tailwatchd
# 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.

Thank you.

Comments

Popular posts from this blog

SVN: File remains in conflict

HowTo: Enable extended logging for exim

12 tweakings for WHM/cPanel to speed up WordPress