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

[Andrew Davis]

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:

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]

Hello,

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

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]

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:

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

 

[cPanelMichael]

Hello,

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

 

[Andrew Davis]

You're very welcome. Thanks again.
Kind regards.