Problem mysql restart via WHM

jaheem

Member
May 31, 2017
5
0
1
Morocco
cPanel Access Level
Root Administrator
my server mysql crached when i try to restart giv me

Restarting MySQL Server

Cpanel::Exception::Timeout/(XID znx69e) The system failed to lock the file “/var/run/restartsrv_mysql” after 60 seconds. at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 330. Cpanel::Exception::create("Timeout", "The system failed to lock the file \x{e2}\x{80}\x{9c}[_1]\x{e2}\x{80}\x{9d} after [quant,_2"..., ARRAY(0x2f25be8)) called at /usr/local/cpanel/Cpanel/Exception.pm line 46 Cpanel::Exception::__ANON__(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__..., ARRAY(0x2f25be8)) called at /usr/local/cpanel/Cpanel/SafeFile.pm line 425 Cpanel::SafeFile::_do_flock_or_return_exception(GLOB(0x322beb0), "/var/run/restartsrv_mysql") called at /usr/local/cpanel/Cpanel/SafeFile.pm line 370 Cpanel::SafeFile::_safe_open(GLOB(0x322beb0), ">>", "/var/run/restartsrv_mysql", CODE(0xb8fc10), "safeopen") called at /usr/local/cpanel/Cpanel/SafeFile.pm line 78 Cpanel::SafeFile::safeopen(GLOB(0x322beb0), ">>", "/var/run/restartsrv_mysql") called at /usr/local/cpanel/Cpanel/RestartSrv/Lock.pm line 25 Cpanel::RestartSrv::Lock::new("Cpanel::RestartSrv::Lock", "mysql") called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 183 Cpanel::ServiceManager::Base::lock(Cpanel::ServiceManager::Services::Mysql=HASH(0x2d3bc50)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 459 Cpanel::ServiceManager::Base::BUILD(Cpanel::ServiceManager::Services::Mysql=HASH(0x2d3bc50), HASH(0xc060e0)) called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/x86_64-linux-64int/Cpanel/Class/Object.pm line 49 Cpanel::Class::Object::BUILDALL(Cpanel::ServiceManager::Services::Mysql=HASH(0x2d3bc50), HASH(0xc060e0)) called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/x86_64-linux-64int/Cpanel/Class/Object.pm line 41 Cpanel::Class::Object::new("Cpanel::ServiceManager::Services::Mysql", "service", "mysql") called at /usr/local/cpanel/Cpanel/ServiceManager.pm line 91 Cpanel::ServiceManager::new("Cpanel::ServiceManager", "service", "mysql") called at bin/restartsrv_base.pl line 60 main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 98 eval {...} called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 89 Try::Tiny::try(CODE(0x2cef9e0), Try::Tiny::Catch=REF(0xb99fc0)) called at bin/restartsrv_base.pl line 107



Any help

Thank you
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
Hello,

Could you try restarting MySQL via the command line and verify if you see the same result? EX:

Code:
/scripts/restartsrv_mysql
If so, do you notice any output to /var/lib/mysql/$hostname.err during the failed restart attempt? Note that these types of issues are typically better addressed by opening a support ticket via the link in my signature so we can get a better idea of what's happening.

Thank you.
 

karentan

Registered
Sep 25, 2018
1
0
1
Davao City
cPanel Access Level
Website Owner
Hi,

I'm having the same problem when restarting in WHM this is what is shows:

Cpanel::Exception::Timeout/(XID k4qvm8) The system failed to lock the file “/var/run/restartsrv_mysqld” after 197 seconds. at /usr/local/cpanel/Cpanel/SafeFile.pm line 735. Cpanel::SafeFile::_timeout_exception("/var/run/restartsrv_mysqld", 197) called at /usr/local/cpanel/Cpanel/SafeFile.pm line 766 Cpanel::SafeFile::_die_if_file_is_flocked_cuz_already_waited_a_while("/var/run/restartsrv_mysqld", 197) called at /usr/local/cpanel/Cpanel/SafeFile.pm line 834 Cpanel::SafeFile::_lock_wait("/var/run/restartsrv_mysqld") called at /usr/local/cpanel/Cpanel/SafeFile.pm line 355 Cpanel::SafeFile::_safelock("/var/run/restartsrv_mysqld") called at /usr/local/cpanel/Cpanel/SafeFile.pm line 558 Cpanel::SafeFile::_safe_open(undef, ">>", "/var/run/restartsrv_mysqld", CODE(0xb7e268), "safeopen") called at /usr/local/cpanel/Cpanel/SafeFile.pm line 115 Cpanel::SafeFile::safeopen(undef, ">>", "/var/run/restartsrv_mysqld") called at /usr/local/cpanel/Cpanel/RestartSrv/Lock.pm line 25 Cpanel::RestartSrv::Lock::new("Cpanel::RestartSrv::Lock", "mysqld") called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 184 Cpanel::ServiceManager::Base::lock(Cpanel::ServiceManager::Services::Mysql=HASH(0x275cef8)) called at /usr/local/cpanel/Cpanel/ServiceManager/Base.pm line 460 Cpanel::ServiceManager::Base::BUILD(Cpanel::ServiceManager::Services::Mysql=HASH(0x275cef8), HASH(0xb50fe0)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Cpanel/Class/Object.pm line 49 Cpanel::Class::Object::BUILDALL(Cpanel::ServiceManager::Services::Mysql=HASH(0x275cef8), HASH(0xb50fe0)) called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/x86_64-linux-64int/Cpanel/Class/Object.pm line 41 Cpanel::Class::Object::new("Cpanel::ServiceManager::Services::Mysql", "service", "mysql") called at /usr/local/cpanel/Cpanel/ServiceManager.pm line 99 Cpanel::ServiceManager::new("Cpanel::ServiceManager", "service", "mysql") called at bin/restartsrv_base.pl line 84 scripts::restartsrv_base::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99 eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90 Try::Tiny::try(CODE(0x280d850), Try::Tiny::Catch=REF(0xb3eff8)) called at bin/restartsrv_base.pl line 130 scripts::restartsrv_base::run("--html", "--wait", "--verbose") called at bin/restartsrv_base.pl line 33

I also tried to restart via Putty and it is freeze like forever nothing happened.

Could you help me how to fix this please.

Thanks,
Karen
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,219
463
Hello Karen,

It looks like you've opened support ticket #10367993 to report this behavior and one of our Technical Analysts has responded. Can you respond to the ticket to report any further issues or questions?

Thank you.