Issue Upgrade to MariaDB 10.1 fails

[speedbird]

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!

 

[nubevps]

same problem here trying to update from 5.5.56 to 5.5.59.

 

[IgorG]

and followed this guide:
PLESK 12.5 & Onyx auf CentOS 7 – Upgrade MariaDB von Version 5.50 auf 10.1 | IT-Service Falk von Broen

Try to use Plesk Guide - How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux

 

[nubevps]

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.