Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Problem mysql restart via WHM

Discussion in 'Database Discussion' started by jaheem, Nov 3, 2017.

  1. jaheem

    jaheem Member

    Joined:
    May 31, 2017
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. karentan

    karentan Registered

    Joined:
    Sep 25, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    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
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,167
    Likes Received:
    1,933
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice