Fix - layanan tailwatchd sedang down di WHM

Salah satu pelanggan kami menerima email dari WHM bahwa layanan tailwatchd  sedang turun. Kami telah mengambil langkah-langkah berikut untuk memperbaikinya.

Pesan Kesalahan

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

Solusi

Langkah:1 Setelah memeriksa status layanan dengan mengeluarkan perintah berikut, kami melihat bahwa layanan tailwatchd sudah berjalan tetapi dengan pesan peringatan seperti di atas.

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

Langkah:2 Kami hanya mengambil langkah-langkah yang disarankan oleh WHM itu sendiri. (ditampilkan dalam format tebal di Pesan Kesalahan di atas). Kami mengeluarkan 3 perintah berikut.

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.

Langkah:3 Setelah menjalankan perintah di atas, kami memeriksa tailwatchd status layanan lagi dengan mengeluarkan perintah berikut. Itu berjalan dengan sempurna.

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