Fix - tailwatchd service is down in WHM

One of our customers received an email from WHM that service tailwatchd is down. We have taken following steps to fix it.


Error Message

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
/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
ATTENTION ATTENTION ATTENTION ATTENTION !!!
tailwatchd is enabled
Running, PID 32162
Driver (Active: 1) Cpanel::TailWatch::Eximstats
Driver (Active: 1) Cpanel::TailWatch::ChkServd
Driver (Active: 1) Cpanel::TailWatch::cPBandwd
Driver (Active: 1) Cpanel::TailWatch::Antirelayd


Solution


Step:1 Upon checking service status by issuing the following command, we noticed that tailwatchd service was already running but with a warning message as above.

/usr/local/cpanel/libexec/tailwatchd --status
 
Step:2 We just took the steps suggested by the WHM itself. (shown in bold format in Error Message above). We issued following 3 commands.

mv /var/cpanel/sql/eximstats.sql /var/cpanel/sql/eximstats.sql.tmp_working_copy // Rename eximstats.sql with eximstats.sql.tmp_working_copy
/scripts/restartsrv_tailwatchd // Restart the tailwatchd service and new blank eximstats.sql will be created


mysql eximstats < /var/cpanel/sql/eximstats.sql.tmp_working_copy // Restore eximstats.sql with the previously renamed file.

Step:3 After firing above commands, we checked the tailwatchd service status again by issuing the following command. It was running perfectly.

/usr/local/cpanel/libexec/tailwatchd --status

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to Install ClamAV plugin from WHM?

ClamAV is a one of the most popular open source antivirus plugin available for cPanel servers....

How to activate and Manage Auto-SSL Certificate in WHM/cPanel?

cPanel provides free SSL Certificate to the WHM/cPanel users. Since it is an automated process by...

SMTP error while using PHPMailer with GMail Authentication

Problem Statement One of our Linux VPS customer was unable to send emails through PHPMailer...

How to install ConfigServer Explorer to cPanel/WHM?

Undoubtedly, WHM has been the most comprehensive control panel of all time for Linux based...

Fatal error: Call to undefined function mysqli_connect() in /home/user/public_html/includes/connection.php

Error Message Fatal error: Call to undefined function mysqli_connect() in...