cpanel services failing

[Arun]

When I try to restart cPanel services, I notice the following error message:

root@server [~]# service cpanel restart
Stopping tailwatchd:
!!
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/libexec/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
!!

2009-05-09 14:04:52 UTC [main] Current process '24050' stopped
[ OK ]
Stopping cPanel services: Waiting for cpsrvd to shutdown ... ...Done
Waiting for cpsrvd-ssl to shutdown ... ...Done
[ OK ]
Stopping cPanel dav services: [Sat May 9 09:04:53 2009] Current process '23832' stopped
Waiting for cpdavd to shutdown ... ...Done
Waiting for cpdavd-ssl to shutdown ... ...Done
[ OK ]
Stopping cPanel brute force detector services: Waiting for cphulkd.pl to shutdown ... ...Done
Waiting for cPhulkd to shutdown ... ...Done
Waiting for cphulkd to shutdown ... ...Done
[ OK ]
Stopping pop3 services: Waiting for cppop to shutdown ... ...Done
Waiting for cppop-ssl to shutdown ... ...Done
[ OK ]
Stopping cPanel log services: [ OK ]
Stopping cPanel Chat services: [FAILED]
Stopping Melange Chat services: [FAILED]
Stopping InterChange services: [FAILED]
Stopping cPanel ssl services: [ OK ]
Stopping mailman services: Shutting down Mailman's master qrunner
PID unreadable in: /usr/local/cpanel/3rdparty/mailman/data/master-qrunner.pid
[Errno 2] No such file or directory: '/usr/local/cpanel/3rdparty/mailman/data/master-qrunner.pid'
Is qrunner even running?
mailmanctl: no process killed
[FAILED]
Starting cPanel services: [ OK ]
Starting cPanel brute force detector services: [ OK ]
Starting cPanel dav services: [ OK ]
Starting cPanel Log services: ==> cPanel Log Daemon version 24.0
[ OK ]
Starting pop3 services: Waiting for cppop to shutdown ... ...Done
Waiting for cppop-ssl to shutdown ... ...Done
[ OK ]
Starting cPanel Chat services:
Starting Melange Chat services:
Starting cPanel ssl services: Using Native SSL support (stunnel not needed)
[ OK ]
Starting mailman services: [ OK ]
Starting tailwatchd:
!!
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/libexec/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
!!

[Sat May 9 09:04:58 2009] Starting /usr/local/cpanel/libexec/tailwatchd daemon
Log is at /usr/local/cpanel/logs/tailwatchd_log
[ OK ]

I tried the steps mentioned in the error message and then the error message disappears:

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

However it is recurring the next day. I had forced updated cPanel and reinstalled Perl as well the previous day. Does anyone know what can be done to prevent it from recurring?

[PlatinumServerM]

The suggested fix should work fine. If it is happening again the next day then something else must be wrong. Try updating cpanel and see if that helps. If not, your provider or cpanel will have to check into this.

[uggsxmas]

ATTENTION ATTENTION ATTENTION ATTENTION

Cpanel::TailWatch::Eximstats appears to have unprocessed SQL in  ar/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  ar/cpanel/sql/eximstats.sql  ar/cpanel/sql/eximstats.sql.tmp_working_copy
  /usr/local/cpanel bexec/tailwatchd --restart
  mysql eximstats <  ar/cpanel/sql/eximstats.sql.tmp_working_copy

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

omg, how to fix them?