MySQL server is currently offline

[Thiago Sabaia]

Symptoms

Updating from MariaDB 10.3.22 to 10.3.23 breaks the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes support for MariaDB 10.3.

The cPanel -> MySQL Databases interface will display these errors:

"The MySQL server is currently offline."

"Error encountered while fetching data: There is no such grant defined for user 'cpses_cpdamak3oz' on host 'localhost' DBDISKUSED cpuser_user 0 DISKUSED 0 DB cpuser_user USER cpuser_db"

 

The following errors can also be found in cPanel's error log:

[2020-05-12 23:36:14 -0500] warn [cpmysql] Error encountered while fetching data: There is no such grant defined for user 'cpses_cpdamak3oz' on host 'localhost' at /usr/local/cpanel/Cpanel/DBAdmin.pm line 186, <STDIN> line 1.

Invalid grant string: GRANT USAGE ON *.* TO `cptech_db`@`localhost` IDENTIFIED BY PASSWORD '*redacted'

[2020-05-12 23:36:14 -0500] 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=[{"version":"2.4","action":"run","data":"Error encountered while fetching data: There is no such grant defined for user 'cpses_cpdamak3oz' on host 'localhost'\nDBDISKUSED\tcptech_dbv\t0\nDISKUSED\t0\nDB\tcptech_dbv\nUSER\tcptech_db\n","timeout":0,"mode":"simple","status":1,"exit_code":2816,"error":1,"statusmsg":"adminbin Cpanel/cpmysql/DBCACHE: exit 11"}] at /usr/local/cpanel/Cpanel/Wrap.pm line 120, <$socket> line 1.

 

Description

The issue is related to changes in grants in MariaDB 10.3.23. An internal case has been filed with our developers to get this resolved.

For reference, the case number is CPANEL-32712. Follow this article to receive an email notification when a solution is published in the product. 

 

Workaround

A fix is being worked on by our developers, however, there is no known workaround at this time. We recommend updating to cPanel version 88, presently in the CURRENT build tier if an immediate solution is required.

 

https://support.cpanel.net/hc/en-us/articles/360048322953-Updating-to-MariaDB-10-3-23-on-cPanel-breaks-the-MySQL-Databases-interface

https://forums.cpanel.net/threads/cpanel-32712-updating-to-mariadb-10-3-23-on-cpanel-breaks-the-mysql-databases-interface.672141/

Editado Maio 13, 2020 por Thiago Sabaia
Inclusão do Link do Forum

[barreto]

Tivemos esse problema com um servidor ontem. Resolvemos fazendo downgrade da versão do MariaDB.

 

[carlosvv]

1 minuto atrás, barreto disse:

Tivemos esse problema com um servidor ontem. Resolvemos fazendo downgrade da versão do MariaDB.

 

deixa eu adivinhar seu servidor também tinha cloudlinux.

[Felipe Pinheiro]

Eu tive esse problema também, no meu caso resolveu com o seguinte comando.

 

yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel

 

Editado Maio 13, 2020 por Felipe Pinheiro

[chuvadenovembro]

Por aqui, optei por atualizar a versão do cpanel (pois usamos versão stable), a versão current resolveu o problema...

E respondendo a pergunta do colega, aqui utilizamos cloudlinux sim...

Um detalhe, o multiphp.ini ta sem opção...ou seja, o cliente obrigatóriamente precisa editar o php.ini na aba editor.

Aconteceu isso com mais alguém que optou pela atualização do cpanel?

[Thiago Sabaia]

Correção liberada https://docs.cpanel.net/changelogs/86-change-log/