Unable to upgrade MariaDB from 5.5 to 10.5 version on Centos 7 OS: # [error] MariaDB Server version 10.5 is not working.

Symptoms

• Plesk is installed on Centos 7 server
• Plesk version is outdated i.e. older than 18.0.70
• The version of MariaDB is 5.5

• In an attempt to upgrade MariaDB to 10.5 version via Plesk > Tools & Settings > Database Servers > Upgrade Now, the process fails with the following error message:

  CONFIG_TEXT: Running mariadb_repo_setup for 'mariadb-10.5' ...
  # [info] Skipping check for script prerequisites.
  # [error] MariaDB Server version 10.5 is not working.
  # Please verify that the version is correct.
  # Not all releases of MariaDB are available on all distributions.
  #
  # The latest MariaDB Server versions are:
  # 10.5.29 10.6.22 10.11.12 11.4.6 11.7.2 11.8.1
  #
  # More information on MariaDB releases is available at:
  # https://mariadb.com/kb/en/release-notes/
  Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

• The similar error occurs in an attempt to execute the command below:

  # curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=10.5

Cause

This is a Plesk bug with the ID #PPPM-14946

Resolution

Bug is fixed in 18.0.70, update Plesk to latest version to apply the fix. 

In case, update is not possible then as a workaround manually upgrade MariaDB by using the steps from the KB article How to upgrade MariaDB on Plesk for Linux, section Manual procedure and subsection Plesk on CentOS 7 / RHEL 7