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

Steini Petur · Nov 4, 2020

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 that, after googling I found out that this only was applying to 10.3.23, but mine is at WHM 90 and with 10.3.26, I tested re-setup in WHM but nothing worked. I actually also found an issue with the yum mirror after that with MariaDB

That led me to this (extra mirrors for MariaDB repo if the OVH one is failing which was doing for me)
https://mariadb.com/kb/en/yum/+comments/2712

Anyway not having found much about 10.3.26 not working as it should on 90 I still went with this comment
https://forums.cpanel.net/threads/c...mysql-databases-interface.672141/post-2756025

Which tells you to run the following code

[root@eldborg yum.repos.d]# yum downgrade MariaDB-server MariaDB-common MariaDB- shared MariaDB-client MariaDB-compat MariaDB-devel

And sure enough, going down from 10.3.26 to 10.3.25 fixed this for me, I don't know if MariaDB just failed updating to 10.3.26 originally because of repository issue or not but I am down to 10.3.25 and the MySQL Databases function in cPanel is now working.

Code:

[root@eldborg yum.repos.d]# yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Loaded plugins: fastestmirror, rhnplugin, universal-hooks
This system is receiving updates from CLN.
Loading mirror speeds from cached hostfile
* EA4: 91.197.228.252
* cpanel-addons-production-feed: 91.197.228.252
* cpanel-plugins: 91.197.228.252
* cloudlinux-x86_64-server-7: cln.webempresa.eu
* epel: epel.hysing.is
MariaDB103                                               | 2.9 kB     00:00
Resolving Dependencies
--> Running transaction check
---> Package MariaDB-client.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-client.x86_64 0:10.3.26-1.el7.centos will be erased
---> Package MariaDB-common.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-common.x86_64 0:10.3.26-1.el7.centos will be erased
---> Package MariaDB-compat.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-compat.x86_64 0:10.3.26-1.el7.centos will be erased
---> Package MariaDB-devel.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-devel.x86_64 0:10.3.26-1.el7.centos will be erased
---> Package MariaDB-server.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-server.x86_64 0:10.3.26-1.el7.centos will be erased
---> Package MariaDB-shared.x86_64 0:10.3.25-1.el7.centos will be a downgrade
---> Package MariaDB-shared.x86_64 0:10.3.26-1.el7.centos will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================================================================================================
Package                                                    Arch                                               Version                                                          Repository                                              Size
=============================================================================================================================================================================================================================================
Downgrading:
MariaDB-client                                             x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                              11 M
MariaDB-common                                             x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                              81 k
MariaDB-compat                                             x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                             2.2 M
MariaDB-devel                                              x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                             7.1 M
MariaDB-server                                             x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                              24 M
MariaDB-shared                                             x86_64                                             10.3.25-1.el7.centos                                             MariaDB103                                             113 k

Transaction Summary
=============================================================================================================================================================================================================================================
Downgrade  6 Packages

Total download size: 45 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/6): MariaDB-common-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                 |  81 kB  00:00:02
(2/6): MariaDB-compat-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                 | 2.2 MB  00:00:46
(3/6): MariaDB-devel-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                  | 7.1 MB  00:02:58
(4/6): MariaDB-client-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                 |  11 MB  00:04:35
(5/6): MariaDB-shared-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                 | 113 kB  00:00:04
(6/6): MariaDB-server-10.3.25-1.el7.centos.x86_64.rpm                                                                                                                                                                 |  24 MB  00:09:23
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                                                         58 kB/s |  45 MB  00:13:10
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : MariaDB-common-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               1/12
  Installing : MariaDB-compat-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               2/12
  Installing : MariaDB-client-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               3/12
  Installing : MariaDB-server-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               4/12
  Installing : MariaDB-devel-10.3.25-1.el7.centos.x86_64                                                                                                                                                                                5/12
  Installing : MariaDB-shared-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               6/12
  Cleanup    : MariaDB-server-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               7/12
  Cleanup    : MariaDB-client-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               8/12
  Cleanup    : MariaDB-shared-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               9/12
  Cleanup    : MariaDB-devel-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               10/12
  Cleanup    : MariaDB-compat-10.3.26-1.el7.centos.x86_64                                                                                                                                                                              11/12
  Cleanup    : MariaDB-common-10.3.26-1.el7.centos.x86_64                                                                                                                                                                              12/12
/etc/yum/universal-hooks/pkgs/MariaDB-server/posttrans/100-build_mysql_conf: running in the background.
  Verifying  : MariaDB-client-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               1/12
  Verifying  : MariaDB-compat-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               2/12
  Verifying  : MariaDB-devel-10.3.25-1.el7.centos.x86_64                                                                                                                                                                                3/12
  Verifying  : MariaDB-common-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               4/12
  Verifying  : MariaDB-server-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               5/12
  Verifying  : MariaDB-shared-10.3.25-1.el7.centos.x86_64                                                                                                                                                                               6/12
  Verifying  : MariaDB-server-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               7/12
  Verifying  : MariaDB-compat-10.3.26-1.el7.centos.x86_64                                                                                                                                                                               8/12
  Verifying  : MariaDB-devel-10.3.26-1.el7.centos.x86_64                                                                                                                                                                                9/12
  Verifying  : MariaDB-common-10.3.26-1.el7.centos.x86_64                                                                                                                                                                              10/12
  Verifying  : MariaDB-client-10.3.26-1.el7.centos.x86_64                                                                                                                                                                              11/12
  Verifying  : MariaDB-shared-10.3.26-1.el7.centos.x86_64                                                                                                                                                                              12/12

Removed:
  MariaDB-client.x86_64 0:10.3.26-1.el7.centos   MariaDB-common.x86_64 0:10.3.26-1.el7.centos   MariaDB-compat.x86_64 0:10.3.26-1.el7.centos   MariaDB-devel.x86_64 0:10.3.26-1.el7.centos   MariaDB-server.x86_64 0:10.3.26-1.el7.centos
  MariaDB-shared.x86_64 0:10.3.26-1.el7.centos

Installed:
  MariaDB-client.x86_64 0:10.3.25-1.el7.centos   MariaDB-common.x86_64 0:10.3.25-1.el7.centos   MariaDB-compat.x86_64 0:10.3.25-1.el7.centos   MariaDB-devel.x86_64 0:10.3.25-1.el7.centos   MariaDB-server.x86_64 0:10.3.25-1.el7.centos
  MariaDB-shared.x86_64 0:10.3.25-1.el7.centos

Complete!

I just didn't see much about this online, and not much in the same place, had to find all the key pieces all overgoogle so If this could save anyone the headache then I am glad.

Thank you.

cPRex · Nov 5, 2020

I'm glad you were able to get that resolved with the data from the other thread!

123Host · Nov 5, 2020

Downgrading MariaDB is a high-risk action that is NOT a resolution to this matter.

To resolve it, cPanel needs to URGENTLY release a patch

xml · Nov 5, 2020

Thank you for for providing this easy solution

Steini Petur · Nov 5, 2020

cPRex said:
I'm glad you were able to get that resolved with the data from the other thread!

I want to iterate that I wasn't trying ti hijack the other thread, I just googled few threads and few sites came up and in combination I took the plunge to do this on a very live server of 1000 people. It took me a while before I dared doing this because there is no way I am doing a "sql dumping" of 1000 clients. I just wanted to let people know that 10.3.26 down to .25 did succeed without issues.. I had to do this to 6 other nodes.. Hi risk or not, it had to be done until patch is released.

Steini Petur · Nov 5, 2020

Code:

  999  2020-11-05 07:17:39 yum downgrade MariaDB-server MariaDB-common MariaDB- shared MariaDB-client MariaDB-compat MariaDB-devel
1000  2020-11-05 20:45:16 exit
1001  2020-11-06 04:02:23 history
[root@jolnir ~]# mysql --version
mysql  Ver 15.1 Distrib 10.3.26-MariaDB, for Linux (x86_64) using readline 5.1

Seems like it's back to 10.3.26, automatically.. Forgot to disable the auto updates, to do that you can add

The cPanel & WHM Update Configuration File - cpupdate.conf | cPanel & WHM Documentation

The cpupdate.conf file on your server determines how cPanel & WHM updates your system.

docs.cpanel.net

[root@jolnir ~]# cat /etc/cpupdate.conf
CPANEL=release
RPMUP=manual
SARULESUP=daily
STAGING_DIR=/usr/local/cpanel
UPDATES=daily

Just remember to set to daily when cPanel has officially resolved this.

Steini Petur · Nov 6, 2020

123Host said:
Downgrading MariaDB is a high-risk action that is NOT a resolution to this matter.

To resolve it, cPanel needs to URGENTLY release a patch

It's not too high of a risk, it's of course not ideal to downgrade anything but it can be downgraded so that is what I did, the alternative is to deal with nonstop tickets about it failing and just tell your clients at 123Host that they are **** out of luck, Im guessing you downgrade rather than deal with that, and turn of automatic update just until cPanel patches this

.. I just did this to 9 nodes, 100% success rate.

MindServer · Nov 6, 2020

Follow this thread.

Please notify us when solve the problem for can enable updates again. Thank you very much.

cPRex · Nov 6, 2020

We'll be updating the main thread with additional clarification as we get it! In Progress - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

Subwayhost · Nov 16, 2020

I've the same issue here

The MySQL server is currently offline.

adminbin Cpanel/cpmysql/DBCACHE: exit 11

I updated cpanel and this is not working
I downgraded mariadb and this not working too !!

Any help?

MindServer · Nov 16, 2020

Subwayhost said:
I've the same issue here

The MySQL server is currently offline.

adminbin Cpanel/cpmysql/DBCACHE: exit 11

I updated cpanel and this is not working
I downgraded mariadb and this not working too !!

Any help?

Execute the autofix: /scripts/autorepair fix_mariadb_show_grants_roles

This solved the problem in my server. You have more information here: In Progress - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

Have a nice day.

Steini Petur · Dec 2, 2020

MindServer said:
Execute the autofix: /scripts/autorepair fix_mariadb_show_grants_roles

This solved the problem in my server. You have more information here: In Progress - CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

Have a nice day.

This command fixed my issues with MariaDB 10.3.27, this was exactly the command that fixed that issue so thank you

Thread starter	Similar threads	Forum	Replies	Date
A	Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment?	Databases	5	Sep 13, 2023
E	How to load MariaDB 10.3 on a WHM system with MySQL 8.0?	Databases	2	Sep 8, 2023
	How to make MariaDB 10.11 available on supported OS?	Databases	9	Aug 30, 2023
	MariaDB upgrade from 10.3 to 10.5 or 10.6?	Databases	5	Aug 26, 2023
N	root, mysql, mariadb.sys gone from mysql.user	Databases	4	Aug 26, 2023

Search

Search

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

Steini Petur

Well-Known Member

cPRex

Jurassic Moderator

123Host

Well-Known Member

xml

Well-Known Member

Steini Petur

Well-Known Member

Steini Petur

Well-Known Member

The cPanel & WHM Update Configuration File - cpupdate.conf | cPanel & WHM Documentation

Steini Petur

Well-Known Member

MindServer

Well-Known Member

cPRex

Jurassic Moderator

Subwayhost

Member

MindServer

Well-Known Member

Steini Petur

Well-Known Member