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...