Symptoms
When the cphulk database has crashed or has a table marked as crashed, tThe MySQL error log, as well as Cphulkd logs, continue to increase in disk usage as well as receiving notification for cPanel regarding checkmysql. You'll notice errors that indicate the table or database has crashed in the following log files.
/usr/local/cpanel/logs/cphulkd_errors.log
/var/lib/mysql/$hostname.err
cPanel notifications are stored in
/var/cpanel/user_notifications/root/history/
warn [cphulkd] 13650 DBD::mysql::db do failed: Table './cphulkd/login_track'
is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/Hulkd.pm line 435, <$client_socket> line 3.
Cpanel::Hulkd::_write_log(Cpanel::Hulkd=HASH(0x86d85b8), "errlog", "warn", "DBD::mysql::db do failed: Table
'./cphulkd/login_track' is ma"..., Cpanel::DBI::Mysql::db=HASH(0x8dd8000), undef) called at
/usr/local/cpanel/Cpanel/Hulkd.pm line 465 Cpanel::Hulkd::warn(Cpanel::Hulkd=HASH(0x86d85b8),
"DBD::mysql::db do failed: Table './cphulkd/login_track' is ma"..., Cpanel::DBI::Mysql::db=HASH(0x8dd8000),
undef) called at /usr/local/cpanel/Cpanel/Hulkd.pm line 406
Description
If your installation is still utilizing MySQL for Cphulk, it is recommended to convert to Sqlite to help prevent these database crashes. This automatically done when upgraded to cPanel version 66 or higher.
Workaround
If upgrading is not an option at this time, you can rebuild the cPhulkd database with:
/usr/local/cpanel/bin/hulkdsetup --force
--force: Update the schema, even if that would involve dropping tables.
/usr/local/cpanel/bin/cphulk_pam_ctl --enable
Comments
0 comments
Article is closed for comments.