MySQL Server Repair
Budget: $30 – $250 USD
Server is Linux/Apache and CentOS v7.9.2009
SQL Server is corrupt and crashing continually.
The suspected origin of the issue is 11/24/21 and 11/25/21, when the server was being attacked.
The SQL server is never up more than a few hours or a day at most. When it crashes, this is the error:
(XID 9hbw4p) The “mysql” service is down.
The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 2 when it ended.
Every few hours, we also receive messages with errors like this:
Cron <root@host2> /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache
Cpanel::Exception::Database::Error/(XID d8jgqy) The system received an error from the “MySQL” database “mysql”: CR_SERVER_LOST (Lost connection to MySQL server during query)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.
Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::st=HASH(0x2952350), "DBD::mysql::st execute failed: Lost connection to MySQL serve"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
Cpanel::DBI::_error_handler("DBD::mysql::st execute failed: Lost connection to MySQL serve"..., Cpanel::DBI::Mysql::st=HASH(0x2952350), undef) called at bin/update_db_cache.pl line 340
bin::update_db_cache::can_get_mysql_usage(HASH(0x28f5bf0), HASH(0xc26090), Cpanel::DB::Map::Collection::Index=HASH(0x290aa38)) called at bin/update_db_cache.pl line 70
Additional Documents with Error Messages:
SQL Server is corrupt and crashing continually.
The suspected origin of the issue is 11/24/21 and 11/25/21, when the server was being attacked.
The SQL server is never up more than a few hours or a day at most. When it crashes, this is the error:
(XID 9hbw4p) The “mysql” service is down.
The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 2 when it ended.
Every few hours, we also receive messages with errors like this:
Cron <root@host2> /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache
Cpanel::Exception::Database::Error/(XID d8jgqy) The system received an error from the “MySQL” database “mysql”: CR_SERVER_LOST (Lost connection to MySQL server during query)
at /usr/local/cpanel/Cpanel/DBI.pm line 200.
Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::st=HASH(0x2952350), "DBD::mysql::st execute failed: Lost connection to MySQL serve"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
Cpanel::DBI::_error_handler("DBD::mysql::st execute failed: Lost connection to MySQL serve"..., Cpanel::DBI::Mysql::st=HASH(0x2952350), undef) called at bin/update_db_cache.pl line 340
bin::update_db_cache::can_get_mysql_usage(HASH(0x28f5bf0), HASH(0xc26090), Cpanel::DB::Map::Collection::Index=HASH(0x290aa38)) called at bin/update_db_cache.pl line 70
Additional Documents with Error Messages: