Unable to upgrade Plesk with Percona: mariadb-server >= 5.0.60 is needed by plesk-mysql-server – Plesk

Symptoms

• The following error occurs on attempt to perform an upgrade to Plesk Onyx 17.8:

  Running Transaction Check Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.8.11-cos7.build1708180301.19.x86_64'] YumRPMCheckError: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-17.8.11-cos7.build1708180301.19.x86_64']

  Or for upgrades to Plesk Obsidian:

  Fatal error during packages installation: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-18.0-2.centos.7+p18.0.17.0+t190721.1104.noarch']
  YumRPMCheckError: [u'ERROR with transaction check vs depsolve:', 'mariadb-server >= 5.0.60 is needed by plesk-mysql-server-18.0-2.centos.7+p18.0.17.0+t190721.1104.noarch']

• MySQL/MariaDB was replaced with Percona after Plesk was installed.

Cause

It is caused by a bug in the product with the ID PPPM-11024 which will be fixed in future Plesk updates.

The plesk-mysql-server package was not replaced with plesk-mysql-server-community package.

Note: Consider subscribing to this article in order to get notified when the fix is released or check for the ID in our changelog

Resolution

It is required to install this package manually in order to resolve the issue.

For that, a .repo file will be created with name=current_plesk_version dist (to make the repo available for the current version of Plesk).

Below is the instruction for CentOS 7 and Plesk Onyx 17.5. Adjust the baseurl and name parameters in .repo file according to the OS that is used on the server:

Note: In case the upgrade is to Plesk Obsidian, the following steps need to be followed as a two steps process, upgrade to 17.8 first and then to Obisidian afterwards.

1. Log in to the server via SSH

2. Use any text editor to create /etc/yum.repos.d/plesk178.repo file with the following content:

   [PLESK_17_8_11-dist]
   name=PLESK_17_5_3 dist
   baseurl=http://autoinstall.plesk.com/PSA_17.8.11/dist-rpm-CentOS-7-x86_64/
   enabled=1
   gpgcheck=1

   One-click solution

   It is possible to use the following one-liner for that:

   # printf '[PLESK_17_8_11-dist] %snname=PLESK_17_5_3 dist %snbaseurl=http://autoinstall.plesk.com/PSA_17.8.11/dist-rpm-CentOS-7-x86_64/ %snenabled=1 %sngpgcheck=1 %sn' > /etc/yum.repos.d/plesk178.repo

3. Install plesk-mysql-server-community package:</>

   # yum install plesk-mysql-server-community

4. Remove /etc/yum.repos.d/plesk178.repo file:

   # rm -f /etc/yum.repos.d/plesk178.repo

5. Initialize the upgrade to Plesk Onyx 17.8 once again.

6. Upgrade to Plesk Obsidian if needed

   Note: Remove the plesk-mysql-server package before the upgrade process

   The package can be removed with the following command:

   # yum remove plesk-mysql-server-17.5.3-cos7.build1705170317.16.x86_64