Problem mysql restart via WHM

[jaheem]

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]

Hello,

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

/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]

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]

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.