The MySQL server is currently offline.

borayeris

Member
Jan 28, 2015
21
4
53
cPanel Access Level
Root Administrator
I have a dedicated server which has WHM/cPanel . In cP every user (domain) can open MySQL Databases list except 1. The error is

"The MySQL server is currently offline.
The adminbin “cpmysql” in the “Cpanel” namespace call to function “DBCACHE” ended prematurely: The subprocess reported the “” (255) error when it ended."
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

Please post the output from /usr/local/cpanel/logs/error_log when you notice this error message in the UI.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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.
 
  • Like
Reactions: thuminh

borayeris

Member
Jan 28, 2015
21
4
53
cPanel Access Level
Root Administrator
Code:
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('<cpanel Mysql="initcache()">') called at cpanel.pl line 4293
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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('<cpanel Mysql="initcache()">') called at cpanel.pl line 4293
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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('<cpanelif !$mysqlrunning>') called at cpanel.pl line 4276
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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('<cpanelif !$mysqlrunning>') called at cpanel.pl line 4276
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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('<cpanelif !$mysql_sane>') called at cpanel.pl line 4276
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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('<cpanelif !$mysql_sane>') called at cpanel.pl line 4276
   main::dotag_finished_headers(0) called at cpanel.pl line 4113
   main::cpanel_parseblock('<cpanel setvar="headerimg=../images/topmysql.gif">\x0A<cpanel setvar="dprefix=../">\x0A<cpanel setvar="headerinclude=sql/index_head.html">\x0A<cpanel Branding="include(stdheader.html)">\x0A<cpanel Mysql="initcache()">\x0A<cpanelif $FORM{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=$FORM{\'itemsperpage\'}">\x0A</cpanelif>\x0A<cpanelif !$FORM{\'itemsperpage\'} || !$CPVAR{\'itemsperpage\'}>\x0A  <cpanel setvar="itemsperpage=10">\x0A</cpanelif>\x0A\x0A<div class="body-content">\x0A<cpanelfeature !mysql>\x0A  <meta http-equiv="refresh" content="0;url=../index.html" />\x0A</cpanelfeature>\x0A\x0A<cpanelif !$mysqlrunning>\x0A  <p class="alert_box"><cptext \'The MySQL server is currently [boolean,_1,online,offline].\',$mysqlrunning></p>\x0A</cpanelif>\x0A<cpanelif $CPERROR{\'mysql\'}>\x0A  <div class="error_details"><cpanel print="$CPERROR{\'mysql\'}"></div>\x0A</cpanelif>\x0A<cpanelif !$mysql_sane>\x0A  <div class="error_details"><cpanel print=$mysql_sane_errmsg></div>\x0A</cpanelif>\x0A\x0A<cpanelif $mysql_sane>\x0A<cpanelfeature mysql>\x0A<cpanelif $mysqlrunning>\x0A<cpanel relinclude="sql/index_include.html">\x0A</cpanelif>\x0A</cpanelfeature>\x0A</cpanelif>\x0A\x0A</div><!-- end body-content -->\x0A\x0A<cpanel Branding="include(stdfooter.html)">\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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
To update, the issue was resolved after disabling "WHM » Server Configuration » Tweak Settings » SQL » Use INFORMATION_SCHEMA to acquire MySQL disk usage" .

Thank you.
 

James Bowlin

Member
Jun 18, 2015
10
0
1
Kansas
cPanel Access Level
Root Administrator
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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.
 

AzeDK

Member
Jul 14, 2011
14
5
128
cPanel Access Level
Root Administrator
Running the downgrade solves the issue:
Code:
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y
 
  • Like
Reactions: ModServ

Steini Petur

Well-Known Member
Apr 24, 2016
54
11
8
Iceland
cPanel Access Level
Root Administrator
Running the downgrade solves the issue:
Code:
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.
 
  • Like
Reactions: ExpertWebWorld

AndyB78

Well-Known Member
Oct 7, 2003
79
2
158
Romania
cPanel Access Level
Root Administrator
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:
Code:
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?
 

ExpertWebWorld

Registered
Jun 12, 2012
3
0
51
Panchkula, India, India
cPanel Access Level
Reseller Owner
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
 

MindServer

Well-Known Member
Mar 18, 2020
189
30
28
Spain
cPanel Access Level
Root Administrator
I had the same error, I used the mentioned command and solved him:

Code:
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!
 
Last edited:

Steini Petur

Well-Known Member
Apr 24, 2016
54
11
8
Iceland
cPanel Access Level
Root Administrator
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.