Skip to main content

The MySQL server is currently offline.

Comments

20 comments

  • cPanelMichael
    Hello, Please post the output from /usr/local/cpanel/logs/error_log when you notice this error message in the UI. Thank you.
    0
  • borayeris
    [Removed]
    0
  • cPanelMichael
    Please post only the relevant output from the error log, as opposed to posting the entire error log. Also, ensure you post the log in CODE tags. Thank you.
    0
  • borayeris

    DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/local/cpanel/Cpanel/Exception.pm line 127. Cpanel::Exception::new("Cpanel::Exception::Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x16236f8), HASH(0x282a988)) called at /usr/local/cpanel/Cpanel/Exception.pm line 57 Cpanel::Exception::create("Database::Error", Cpanel::ExceptionMessage::Raw=SCALAR(0x16236f8), HASH(0x282a988)) called at /usr/local/cpanel/Cpanel/Exception.pm line 65 Cpanel::Exception::create_raw("Database::Error", "DBD::mysql::st execute failed: Lost connection to MySQL serve"..., HASH(0x282a988)) called at /usr/local/cpanel/Cpanel/DBI.pm line 101 Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::st=HASH(0x280ff90), "DBD::mysql::st execute failed: Lost connection to MySQL serve"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 92 Cpanel::DBI::_error_handler("DBD::mysql::st execute failed: Lost connection to MySQL serve"..., Cpanel::DBI::Mysql::st=HASH(0x280ff90), undef) called at /usr/local/cpanel/Cpanel/Mysql.pm line 222 Cpanel::Mysql::_diskusage(Cpanel::Mysql=HASH(0x27e0190)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 1605 Cpanel::Mysql::dbcache(Cpanel::Mysql=HASH(0x27e0190), "") called at bin/admin/Cpanel/cpmysql.pl line 426 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request The adminbin "cpmysql" in the "Cpanel" namespace call to function "DBCACHE" ended prematurely: The subprocess reported the "" (255) error when it ended.: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: raw_response=[{"statusmsg":"The adminbin "cpmysql" in the "Cpanel" namespace call to function "DBCACHE" ended prematurely: The subprocess reported the "" (255) error when it ended.","mode":"simple","status":1,"version":"2.3","data":"","exit_code":65280,"timeout":0,"error":1,"action":"run"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 117 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'DBCACHE', 'data', '', 'action', 'run', 'env', HASH(0x687ed58)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'DBCACHE', '') called at cpanel.pl line 2922 main::domysql('initcache', ARRAY(0x686a868)) called at cpanel.pl line 1990 eval {...} called at cpanel.pl line 1990 main::_api1('Mysql', 'mysql', 'initcache()', 'initcache', ARRAY(0x686a868), 'safe_html_encode', undef, undef) called at cpanel.pl line 1663 main::real_exectag('') called at cpanel.pl line 4293 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: statusmsg=[The adminbin "cpmysql" in the "Cpanel" namespace call to function "DBCACHE" ended prematurely: The subprocess reported the "" (255) error when it ended.] at /usr/local/cpanel/Cpanel/Wrap.pm line 127 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'DBCACHE', 'data', '', 'action', 'run', 'env', HASH(0x687ed58)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'DBCACHE', '') called at cpanel.pl line 2922 main::domysql('initcache', ARRAY(0x686a868)) called at cpanel.pl line 1990 eval {...} called at cpanel.pl line 1990 main::_api1('Mysql', 'mysql', 'initcache()', 'initcache', ARRAY(0x686a868), 'safe_html_encode', undef, undef) called at cpanel.pl line 1663 main::real_exectag('') called at cpanel.pl line 4293 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831 [2015-05-29 12:57:04 -0500] warn [Mysql::initcache] Encountered error in Mysql::initcache: The adminbin "cpmysql" in the "Cpanel" namespace call to function "DBCACHE" ended prematurely: The subprocess reported the "" (255) error when it ended. [2015-05-29 12:57:04 -0500] warn [cpmysql] Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBAdmin.pm line 160 Cpanel::DBAdmin::_log_error_and_output_return(Cpanel::Mysql=HASH(0x1cd0190), 'Error while connecting to MySQL: [_1]', 'Can\'t connect to local MySQL server through socket \'/tmp/mysql.sock\' (2)') called at /usr/local/cpanel/Cpanel/Mysql.pm line 164 Cpanel::Mysql::_get_dbh(Cpanel::Mysql=HASH(0x1cd0190), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Mysql.pm line 109 Cpanel::Mysql::new('Cpanel::Mysql', HASH(0x1cd01d8)) called at bin/admin/Cpanel/cpmysql.pl line 125 main::try {...} () called at /usr/local/cpanel/Cpanel/CPAN/Try/Tiny.pm line 119 eval {...} called at /usr/local/cpanel/Cpanel/CPAN/Try/Tiny.pm line 108 Cpanel::CPAN::Try::Tiny::try(CODE(0x1cbf420), Try::Tiny::Catch=REF(0x160e230)) called at bin/admin/Cpanel/cpmysql.pl line 129 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request The adminbin "cpmysql" in the "Cpanel" namespace call to function "ALIVE" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.: namespace=[Cpanel] module=[cpmysql] function=[ALIVE]: set error in context setvar: raw_response=[{"statusmsg":"The adminbin "cpmysql" in the "Cpanel" namespace call to function "ALIVE" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.","mode":"simple","status":1,"version":"2.3","data":"Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)\nError while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 164.\n","exit_code":256,"timeout":0,"error":1,"action":"run"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 117 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'ALIVE', 'data', '', 'action', 'run', 'env', HASH(0x680e678)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'ALIVE') called at /usr/local/cpanel/Cpanel/ExpVar/Utils.pm line 41 Cpanel::ExpVar::Utils::chomped_adminrun('cpmysql', 'ALIVE') called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 179 Cpanel::ExpVar::SinglePass::__ANON__() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 218 Cpanel::ExpVar::SinglePass::expand(HASH(0x6836110), undef) called at /usr/local/cpanel/Cpanel/ExpVar.pm line 141 Cpanel::ExpVar::expvar('!$mysqlrunning') called at cpanel.pl line 2363 main::execiftag('') called at cpanel.pl line 4276 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[cpmysql] function=[ALIVE]: set error in context setvar: statusmsg=[The adminbin "cpmysql" in the "Cpanel" namespace call to function "ALIVE" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.] at /usr/local/cpanel/Cpanel/Wrap.pm line 127 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'ALIVE', 'data', '', 'action', 'run', 'env', HASH(0x680e678)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'ALIVE') called at /usr/local/cpanel/Cpanel/ExpVar/Utils.pm line 41 Cpanel::ExpVar::Utils::chomped_adminrun('cpmysql', 'ALIVE') called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 179 Cpanel::ExpVar::SinglePass::__ANON__() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 218 Cpanel::ExpVar::SinglePass::expand(HASH(0x6836110), undef) called at /usr/local/cpanel/Cpanel/ExpVar.pm line 141 Cpanel::ExpVar::expvar('!$mysqlrunning') called at cpanel.pl line 2363 main::execiftag('') called at cpanel.pl line 4276 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831 [2015-05-29 12:57:04 -0500] warn [cpmysql] Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/DBAdmin.pm line 160 Cpanel::DBAdmin::_log_error_and_output_return(Cpanel::Mysql=HASH(0x25c0190), 'Error while connecting to MySQL: [_1]', 'Can\'t connect to local MySQL server through socket \'/tmp/mysql.sock\' (2)') called at /usr/local/cpanel/Cpanel/Mysql.pm line 164 Cpanel::Mysql::_get_dbh(Cpanel::Mysql=HASH(0x25c0190), __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/Mysql.pm line 109 Cpanel::Mysql::new('Cpanel::Mysql', HASH(0x25c01d8)) called at bin/admin/Cpanel/cpmysql.pl line 125 main::try {...} () called at /usr/local/cpanel/Cpanel/CPAN/Try/Tiny.pm line 119 eval {...} called at /usr/local/cpanel/Cpanel/CPAN/Try/Tiny.pm line 108 Cpanel::CPAN::Try::Tiny::try(CODE(0x25af420), Try::Tiny::Catch=REF(0x160e230)) called at bin/admin/Cpanel/cpmysql.pl line 129 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request The adminbin "cpmysql" in the "Cpanel" namespace call to function "VERSION" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.: namespace=[Cpanel] module=[cpmysql] function=[VERSION]: set error in context print: raw_response=[{"statusmsg":"The adminbin "cpmysql" in the "Cpanel" namespace call to function "VERSION" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.","mode":"simple","status":1,"version":"2.3","data":"Error while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)\nError while connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 164.\n","exit_code":256,"timeout":0,"error":1,"action":"run"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 117 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'VERSION', 'data', '', 'action', 'run', 'env', HASH(0x686dda8)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'VERSION') called at /usr/local/cpanel/Cpanel/ExpVar/Utils.pm line 55 Cpanel::ExpVar::Utils::initialize_mysql_version_varcache() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 165 Cpanel::ExpVar::SinglePass::__ANON__() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 218 Cpanel::ExpVar::SinglePass::expand(HASH(0x6836110), undef) called at /usr/local/cpanel/Cpanel/ExpVar.pm line 141 Cpanel::ExpVar::expvar('!$mysql_sane') called at cpanel.pl line 2363 main::execiftag('') called at cpanel.pl line 4276 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831 [2015-05-29 12:57:04 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[cpmysql] function=[VERSION]: set error in context print: statusmsg=[The adminbin "cpmysql" in the "Cpanel" namespace call to function "VERSION" ended prematurely: The subprocess reported the "EPERM" (1) error when it ended.] at /usr/local/cpanel/Cpanel/Wrap.pm line 127 Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'cpmysql', 'function', 'VERSION', 'data', '', 'action', 'run', 'env', HASH(0x686dda8)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 105 Cpanel::AdminBin::adminrun('cpmysql', 'VERSION') called at /usr/local/cpanel/Cpanel/ExpVar/Utils.pm line 55 Cpanel::ExpVar::Utils::initialize_mysql_version_varcache() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 165 Cpanel::ExpVar::SinglePass::__ANON__() called at /usr/local/cpanel/Cpanel/ExpVar/SinglePass.pm line 218 Cpanel::ExpVar::SinglePass::expand(HASH(0x6836110), undef) called at /usr/local/cpanel/Cpanel/ExpVar.pm line 141 Cpanel::ExpVar::expvar('!$mysql_sane') called at cpanel.pl line 2363 main::execiftag('') called at cpanel.pl line 4276 main::dotag_finished_headers(0) called at cpanel.pl line 4113 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x0A \x0A\x0A\x0A \x0A\x0A\x0A
    \x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x0A\x0A') called at cpanel.pl line 4027 main::y(GLOB(0x600d0d0)) called at cpanel.pl line 5396 main::run_standard_mode() called at cpanel.pl line 831

    0
  • cPanelMichael
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome. Thank you.
    0
  • borayeris
    The ticket id is: 6591609.
    0
  • cPanelMichael
    To update, the issue was resolved after disabling "WHM " Server Configuration " Tweak Settings " SQL " Use INFORMATION_SCHEMA to acquire MySQL disk usage" . Thank you.
    0
  • James Bowlin
    To update, the issue was resolved after disabling "WHM " Server Configuration " Tweak Settings " SQL " Use INFORMATION_SCHEMA to acquire MySQL disk usage" . Thank you.

    Or in other words it's an error with the WHM software code and you guys don't know how to fix it properly so that people can use all of the settings and features of WHM.
    0
  • cPanelMichael
    Or in other words it's an error with the WHM software code and you guys don't know how to fix it properly so that people can use all of the settings and features of WHM.

    Hello :) Here is the description of this option as found in "WHM >> Tweak Settings": Using INFORMATION_SCHEMA ensures that disk usage by MySQL tables is included in totals. However, enabling this option may cause a significant drop in performance as MySQL may become unresponsive until data collection is complete. Disabling this option causes the system to query the filesystem directly, potentially excluding disk space used by some database tables. Note: If you use a remote MySQL server, you must turn this setting On in order to calculate MySQL disk usage.
    Are you experiencing a similar problem on accounts with large numbers of databases? Thank you.
    0
  • lukapaunovic
    [wrong thread guys sorry]
    0
  • AzeDK
    Running the downgrade solves the issue:
    yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y
    0
  • Steini Petur
    Running the downgrade solves the issue:
    yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y

    That worked for me from 10.3.26 to 10.3.25 but the error here is not the same, Ithink this post is too old, the adminbin issue we're having Exit code is not the same..backwhen this post was originally done that was not the issue most likely.
    0
  • AndyB78
    To update, the issue was resolved after disabling "WHM " Server Configuration " Tweak Settings " SQL " Use INFORMATION_SCHEMA to acquire MySQL disk usage" . Thank you.

    Thank you for your update! Unfortunately this didn't work for me.
    Running the downgrade solves the issue:
    yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y

    Thanks for sharing this fix. This worked for me. So another failed update from MariaDB?
    0
  • 123Host
    So another failed update from MariaDB?

    No, you have it around the wrong way. The MariaDB update was fine, it works perfectly. They don't have to build 3rd party compatibility into the software. It is the other way around.
    0
  • ExpertWebWorld
    That worked for me from 10.3.26 to 10.3.25 but the error here is not the same, Ithink this post is too old, the adminbin issue we're having Exit code is not the same..backwhen this post was originally done that was not the issue most likely.

    yest this command work atleast now database now open from cpanel rather then its showing mysql offline msg
    0
  • MindServer
    I had the same error, I used the mentioned command and solved him:
    yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y
    You need know that in this server I only have 10 cPanel accounts with 1 Database in each one, I not have many accounts. -Why happens this error? -In next update WHM/cPanel will update MariaDB again. This problem will happens again?. Thanks!
    0
  • Steini Petur
    yest this command work atleast now database now open from cpanel rather then its showing mysql offline msg

    I had the same error, I used the mentioned command and solved him:

    Make sure you set /etc/cpupdate.conf to "RPMUP=manual" until cPanel patches because if its set daily, you'll get bumped up to 10.3.26 again today, happened to me had to downgrade all over again all my nodes.
    0
  • ModServ
    Running the downgrade solves the issue:
    yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y

    This fixed it.
    0
  • jjdewit
    Make sure you set /etc/cpupdate.conf to "RPMUP=manual" until cPanel patches because if its set daily, you'll get bumped up to 10.3.26 again today, happened to me had to downgrade all over again all my nodes.

    This also worked for me. Thanks for sharing all.
    0
  • cPRex Jurassic Moderator
    The main thread for this issues is here: https://forums.cpanel.net/threads/mariadb-10-3-26-causing-adminbin-error-mysql-currently-offline-when-its-not.681053/#post-2798357 but let me know if you have any questions!
    0

Please sign in to leave a comment.