The MySQL server is currently offline.
Hi,
I'm getting the following error when i try to access the MySQL Databases from cpanel:
The MySQL server is currently offline.
adminbin Cpanel/cpmysql/DBCACHE: exit 11
The errors from the /usr/local/cpanel/logs are
[2020-11-04 10:21:08 +0100] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request adminbin Cpanel/cpmysql/DBCACHE: exit 11: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: raw_response=[{"mode":"simple","status":1,"statusmsg":"adminbin Cpanel/cpmysql/DBCACHE: exit 11","exit_code":2816,"error":1,"action":"run","version":"2.4","data":"","timeout":0}] at /usr/local/cpanel/Cpanel/Wrap.pm line 120, <$socket> line 1.
[2020-11-04 10:21:08 +0100] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: statusmsg=[adminbin Cpanel/cpmysql/DBCACHE: exit 11] at /usr/local/cpanel/Cpanel/Wrap.pm line 129, <$socket> line 1.
Thank you
-
Yeah we have it as well. Downgraded Maria DB and it's o.k. for now. yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Then lock it up until they have a fix:yum install -y yum-plugin-versionlock && yum versionlock MariaDB-* && yum versionlock list0 -
I downgrade to 10.3.24, but it shows: Error while connecting to MySQL: (XID afp3mv) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) Error while connecting to MySQL: (XID afp3mv) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 437, line 1. Then, I try to restart MySQL server, it shows: Waiting for "mysql" to start """failed. Cpanel::Exception::Services::StartError Service Status undefined status from Cpanel::ServiceManager::Services::Mysql Service Error (XID r4rgeq) The "mysql" service failed to start. Startup Log Nov 05 16:24:04 whmhost.conceptsquares.com systemd[1]: Starting MariaDB 10.3.24 database server... Nov 05 16:24:04 whmhost.conceptsquares.com mysqld[3175]: 2020-11-05 16:24:04 0 [Note] /usr/sbin/mysqld (mysqld 10.3.24-MariaDB) starting as process 3175 ... Nov 05 16:24:05 whmhost.conceptsquares.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE Nov 05 16:24:05 whmhost.conceptsquares.com systemd[1]: Failed to start MariaDB 10.3.24 database server. Nov 05 16:24:05 whmhost.conceptsquares.com systemd[1]: Unit mariadb.service entered failed state. Nov 05 16:24:05 whmhost.conceptsquares.com systemd[1]: mariadb.service failed. mysql has failed. Contact your system administrator if the service does not automagically recover. Please help=[ 0 -
I downgrade to 10.3.24, but it shows: Error while connecting to MySQL: (XID afp3mv) The system failed to connect to the "MySQL" database "mysql" because of an error: CR_CONNECTION_ERROR (Can't connect to .......
Have you tried the basics starting with mv /etc/my.cnf /etc/my.cnf.bak and attempt to reboot your MySQL service mysql start If that fails then maybe attempt the /scripts/upcp --force and let it set up the latest cPanel release start to finish with --force. It's just what has solved mysql issues for me int he past especially my.cnf it can be a bastard.0 -
We've updated the workaround here: Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline. How time will need for solve him?. We host client's webs and need a correct solution for not broke nothing. Thank you very much.
0 -
Did you also disable updates on the system, or at least the MariaDB updates? If so, nothing will change on the server and you can wait to perform updates until the issue is resolved. 0 -
Did you also disable updates on the system, or at least the MariaDB updates? If so, nothing will change on the server and you can wait to perform updates until the issue is resolved.
I used this command:yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel -y
This will disable MariaDB updates? or how can I do this?. Thank you very much. Have a nice day.0 -
Follow. 0 -
This is what I am getting upon downgrade No Match for available package: MariaDB-server-10.3.25-1.el7.centos.x86_64 No Match for available package: MariaDB-common-10.3.25-1.el7.centos.x86_64 No Match for available package: MariaDB-shared-10.3.25-1.el7.centos.x86_64 No Match for available package: MariaDB-client-10.3.25-1.el7.centos.x86_64 No Match for available package: MariaDB-compat-10.3.25-1.el7.centos.x86_64 No Match for available package: MariaDB-devel-10.3.25-1.el7.centos.x86_640 -
@A Hartonian - did your server have 10.3 installed at some point? If not, there wouldn't be a way to perform that downgrade most likely. Can you let me know what specific issues you're having? 0 -
Nice - I'm glad that worked! 0 -
From My Side, i have Fix Using Restore Old Backup in cPanel 0
Please sign in to leave a comment.
Comments
17 comments