SOLVED MariaDB Upgrade - The system was not able to ensure the availability of the “MariaDB-client” package

Andrew Davis

Member
May 23, 2017
11
4
3
Trinidad/USA
cPanel Access Level
Website Owner
Hello,
I am unable to upgrade from MySQL to MariaDB while using the WHM interface.

Software » MySQL/MariaDB Upgrade

I follow the steps correctly, choosing the recommended MariaDB 10.1 version.

I cannot get past this stage:

Code:
2017-09-12 01:27:59 21523 [Note] /usr/sbin/mysqld: Normal shutdown
2017-09-12 01:19:48 21523 [Note] /usr/sbin/mysqld: ready for connections.

mysql restarted successfully.

The system was not able to ensure the availability of the “MariaDB-client” package: (XID sq48jb) “/usr/bin/yum” reported error code “1” when it ended: Error: No matching Packages to list
Obtained version information from system.

Proceeding with MySQL/MariaDB upgrade despite the following: Normal: The selected MariaDB version (10.1) is more than one generation newer than the currently installed version. The upgrade process will iterate over each intervening version to ensure tables are upgraded appropriately.

The process quits at this point.
I contacted my hosting company and they were unable to resolve the issue for me.


This particular portion is the problem area, with an Error icon:
The system was not able to ensure the availability of the “MariaDB-client” package: (XID sq48jb) “/usr/bin/yum” reported error code “1” when it ended: Error: No matching Packages to list


XID "sq48jb" is random/changing each time I try.


What can be done to fix this?
Thanks.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

Can you verify which operating system is installed on this system? EX:

Code:
cat /etc/redhat-release
Also, are you using any custom YUM repos in the /etc/yum.repos.d/ directory, or do you have mariadb added to the "Exclude=" line in the /etc/yum.conf file?

Thank you.
 

Andrew Davis

Member
May 23, 2017
11
4
3
Trinidad/USA
cPanel Access Level
Website Owner
Hello, thanks for the response.

Can you verify which operating system is installed on this system? EX:
Yes: CentOS release 6.9 (Final)


Also, are you using any custom YUM repos in the /etc/yum.repos.d/ directory, or do you have mariadb added to the "Exclude=" line in the /etc/yum.conf file?
Not as far as I am aware.
I am not manually installing MariaDB via SSH.
I'm using the WHM interface at "Software » MySQL/MariaDB Upgrade",
so I haven't manually installed/changed anything, nor edited any files.


I just checked via SSH, and I actually see this line in the /etc/yum.conf file:
Code:
exclude=ansible1.9,mysql,mariadb,mariadb-*,Percona-XtraDB-*,Percona-*-55,Percon$
So I made a backup copy of this .conf file.
Then removed this portion "mariadb,mariadb-*," and saved yum.conf.

Now I went back to WHM » Software » MySQL/MariaDB Upgrade and attempted the upgrade process again.

...

MySQL/MariaDB Upgrade Completed.

Currently installed: 10.1.26-MariaDB




So this solved my problem:

Removing the "mariadb,mariadb-*," portion from the "exclude=" line in "/etc/yum.conf.".
(Save - Run Update process again)


Thanks for the assistance!
-Andrew
 
  • Like
Reactions: cPanelMichael

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
Hello,

I'm glad to see the issue is now solved. Thank you for updating us with the outcome.