• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Issue Upgrade to MariaDB 10.1 fails

speedbird

Basic Pleskian
Hi there...,
I'm on CentOS 7.3 and Plesk Onyx and followed this guide:
https://it-fvb.de/plesk-12-5-auf-centos-7-upgrade-mariadb-von-version-5-50-auf-10-1.html

It says to stop watchdog -> check
Stop MariaDB -> check
Remove MariaDB Benchmark -> check
Start yum update -> check

But then the start of MariaDB fails afterwards with something like this:

Status: "InnoDB: Error: Unable to lock ./namexyz_piwik/piwik_access.ibd, error: 37"
CGroup: /system.slice/mariadb.service

I tried to manually remove the ibd file but then it just picks another .ibd file it complains about. No matter what, I can't get it to work. The only option left is to roll back the snapshot to 5.5

Tried it several times already all to the same result.

I tried 10.0 also because I thought it might work to update 10.0 to 10.1 afterwards but all I got was a load of lines when running yum just like this:

file /etc/init.d/mysql conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /etc/my.cnf.d/server.cnf conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /usr/bin/aria_chk conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /usr/bin/aria_dump_log conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /usr/bin/aria_ftdump conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /usr/bin/aria_pack conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
file /usr/bin/aria_read_log conflicts between attempted installs of MariaDB-server-10.0.29-1.el7.centos.x86_64 and MariaDB-Galera-server-10.0.29-1.el7.centos.x86_64
...and many more.

so I had to give up on that approach as well.

Any ideas? Thanks!
 
that´s the guide I followed. Anyway I got reply from Plesk support with solution to "conflicts between attempted installs of":

are caused by the fact that there is a conflict between MariaDB-* and MariaDB-Galera-* packages. I was able to resolved it by adding 'exclude=MariaDB-Galera*' line to the end of /etc/yum.repos.d/mariadb.repo file.
 
Back
Top