The MySQL server is currently offline.

[Dumitru]

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

 

[cPRex]

Hey there! Check out this post for much more detail on the issue: In Progress - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

 

[WebHostPro]

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 list

 

[Steini Petur]

Hah wish i read this forum before I posted my thread, I got the same with 10.3.26

SOLVED - MariaDB 10.3.26 causing adminbin error (MySQL currently offline) When it's not!

Guys, I ran into a very weird error, my error had to do with adminbin I had updated MariaDB to the latest MariaDB in 10.3 series, and it broke the client "cPanel > MySQL Databases" with a weird error saying The MySQL server is currently offline. adminbin Cpanel/cpmysql/DBCACHE Something like...

forums.cpanel.net

 

[kincheng]

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, <STDIN> 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=[

 

[Steini Petur]

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.

 

[MindServer]

Hey there! Check out this post for much more detail on the issue: In Progress - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

When cPanel cron execute update today, MariaDB will broke again?.

Thank you very much.

 

[cPRex]

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.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offlin...

support.cpanel.net

If you performed the version downgrade the article tells you the best way to proceed.

 

[MindServer]

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.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offlin...

support.cpanel.net

If you performed the version downgrade the article tells you the best way to proceed.

With downgrade the databases are working correctly. We need apply the mentioned guide or can I wait until cPanel solve the problem in next update?: 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.

 

[cPRex]

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.

 

[MindServer]

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.

 

[cPRex]

That will perform the downgrade, but will not keep a future upgrade from happening. We're actually no longer recommending the downgrade process, but following the steps outlined here:

Updating MariaDB to v10.2.35 or v10.3.26, causes MySQL Databases interface to show MySQL as offline.

Symptoms Updating MariaDB to v10.2.35 or v10.3.26 may hinder select sites to be inaccessible and the MySQL Database interface within cPanel may populate "The MySQL server is currently offlin...

support.cpanel.net

 

[altinsoft]

Follow.

 

[A Hartonian]

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_64

 

[cPRex]

@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?

 

[A Hartonian]

@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?

Used the following command from this documentation that was posted by you to fix it:

/scripts/autorepair fix_mariadb_show_grants_roles

The other day got carried away and forgot to update this thread

 

[cPRex]

Nice - I'm glad that worked!