Skip to main content

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

Steini Petur
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) 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. [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.

Comments

11 comments

Date Votes
  • cPRex Jurassic Moderator
    I'm glad you were able to get that resolved with the data from the other thread!
    0
  • 123Host
    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
    0
  • xml
    Thank you for for providing this easy solution
    0
  • Steini Petur
    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.
    0
  • Steini Petur
    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
    0
  • Steini Petur
    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 shit 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.
    0
  • MindServer
    Follow this thread. Please notify us when solve the problem for can enable updates again. Thank you very much.
    0
  • cPRex Jurassic Moderator
    We'll be updating the main thread with additional clarification as we get it!
    0
  • Subwayhost
    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?
    0
  • MindServer
    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: Have a nice day.
    0
  • Steini Petur
    Execute the autofix: /scripts/autorepair fix_mariadb_show_grants_roles This solved the problem in my server. You have more information here:
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post