SOLVED Unable to Upgrade from MariaDB 10.3 to 10.5

[Sujoy Dhar]

Hi,

Recently I tried to upgrade from MariaDB 10.3 to MariaDB 10.5 but it Failed and thrown the below error message , Can you please help me in this ?

The system was not able to ensure the availability of the “MariaDB-client” package: The package “MariaDB-client” with version “10.5” is not available via yum: Loaded plugins: fastestmirror, rhnplugin, universal-hooks, versionlock
This system is receiving updates from CLN.
Determining fastest mirrors
* EA4: 184.94.196.94
* cpanel-addons-production-feed: 184.94.196.94
* cpanel-plugins: 184.94.196.94
* cloudlinux-x86_64-server-7: az1-clmirror.a2hosting.com
* elrepo: dfw.mirror.rackspace.com
* epel: irltoolkit.mm.fcix.net
Excluding 6 updates due to versionlock (use "yum versionlock status" to show them)
Installed Packages
MariaDB-client.x86_64 10.3.25-1.el7.centos @MariaDB103
Obtained version information from system.
Proceeding with MySQL/MariaDB upgrade despite the following:
Critical: In MariaDB 10.4 and later, the mysql.global_priv table has replaced the mysql.user table. The mysql.user table is converted into a view of the mysql.global_priv table during the database upgrade. The dedicated mariadb.sys user is created as the definer of the new mysql.user view.
Critical: The "mytop" package is not compatible due to MDEV-22552. If "mytop" is installed, the upgrade process will uninstall the "mytop" package.
Normal: All binaries previously beginning with `mysql` now begin with `mariadb`. Symlinks are created for the corresponding mysql commands to ensure backwards compatibility. Usually that should not cause any changed behavior, but when starting the MariaDB server via systemd, or via the `mysqld_safe` script symlink, the server process will now always be started as `mariadbd`,
not`mysqld`. Any 3rd party software or scripts looking for the `mysqld` name in the system process list
must now look for `mariadbd` instead.

 

[Sujoy Dhar]

I have followed this : https://support.cpanel.net/hc/en-us...-5-can-result-in-a-missing-MariaDB-server-RPM

But now my Database server is fully down and my ticket ID is #94501105

Kindly help me someone to make my database server up again.

 

[andrew.n]

@cPRex for visibility here. How did you try to upgrade it exactly? from WHM or via command line?

 

[cPRex]

After checking the ticket, it looks like the client had some additional MySQL tools that were not compatible with the update. These were Galera and mytop. After removing those, the update worked well and the client confirmed things were working normally.

 

[Sujoy Dhar]

So let me complete this :


Before upgrading make sure you do run the below command first :

mv /usr/local/bin/mytop{,.Disabled}

yum remove galera

Check is the versionlock is clear or not ?

# yum versionlock list
...
0:MariaDB-server-10.3.36-1.el7.centos.*
0:MariaDB-shared-10.3.36-1.el7.centos.*
0:MariaDB-devel-10.3.36-1.el7.centos.*
0:MariaDB-common-10.3.36-1.el7.centos.*
0:MariaDB-compat-10.3.36-1.el7.centos.*
0:MariaDB-client-10.3.36-1.el7.centos.*
versionlock status done

In my case it was lock and Full database was Down so unable to understand what could be done . Then another Support " Donell Cox " run the below command :

yum versionlock clear

Then the Database server gone up and I have Resumed the upgrade and it worked.

 

[kodeslogic]

@Sujoy Dhar
Thank you for sharing the details with the community.