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

Steini Petur

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

[[email protected] 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:
[[email protected] 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.
 
Last edited by a moderator:

123Host

Active Member
Apr 24, 2015
29
1
53
USA
cPanel Access Level
Root Administrator
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
 

Steini Petur

Well-Known Member
Apr 24, 2016
45
10
8
Iceland
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: cPRex

Steini Petur

Well-Known Member
Apr 24, 2016
45
10
8
Iceland
cPanel Access Level
Root Administrator
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
[[email protected] ~]# 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


[[email protected] ~]# 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

Well-Known Member
Apr 24, 2016
45
10
8
Iceland
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: cPRex and xml

MindServer

Well-Known Member
Mar 18, 2020
176
27
28
Spain
cPanel Access Level
Root Administrator
  • Like
Reactions: cPRex