MySQL upgrade render MySQL DOWN if MySQL/MariaDB is version locked

Symptoms

If you attempt to upgrade MySQL/MariaDB version from WHM and you have version locked the packages, the upgrade process uninstalls the actual packages and is not able to install the new ones, rendering the MySQL service down.

Description

MySQL/MariaDB is uninstalled, and the upgrade cannot take place if packages are version locked.

We've opened an internal case for our development team to investigate this further. For reference, the case number is CPANEL-47555. Follow this article to receive an email notification when a solution is published in the product. 

Workaround

• Remove the version lock

• Install the server package, depending on the server version you have:

  yum install mysql-community-server

  yum install MariaDB-server

• Check the service to be up and running
• Perform the upgrade again

The following artcile explains how to check your version locked packages and how to remove the lock:

How to version lock RPM packages