Issue MariaDB 10.5 to 10.11 upgrade failure on AlmaLinux 9.5

[sder]

Server operating system version

AlmaLinux 9.5

Plesk version and microupdate number

18.0.66

I am trying to upgrade MariaDB from 10.5 to 10.11 on AlmaLinux 9.5 by following the steps provided in the post of

Question - update MariaDB from 10.3.35 to 10.6 or 10.10 or 10.11

Hello, I want to upgrade MariaDB from to 10.3.35 to 10.6 or 10.10 or 10.11 (preffered) On this server I have Opencarts (2.0.3.2 and 3.x version) and Wordpress' (last and latest versions). Also, 3-4 Joomla websites Shall I have problems with these websites? OS: AlmaLinux: 8.8 Plesk Obsidian...

talk.plesk.com

with the following environment:

OS: AlmaLinux 9.5
Plesk: Obsidian, Version 18.0.66
MariaDB: 10.5.22

The steps followed through are:

1. Create dump backup folder:
# mkdir /root/dbBackups

2. Dump databases, just in case(don't proceed if this action failed):
# plesk db -Ne 'show databases' | egrep -vE '(information_schema|performance_schema|mysql)' | xargs -l bash -c 'mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` $0 > /root/dbBackups/$0.sql'

3. Create /etc/yum.repos.d/mariadb.repo with the following contents:
[mariadb] name = MariaDB baseurl=Index of /yum/10.11/rhel8-amd64/ module_hotfixes=1 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

4. Stop mariadb server:
# systemctl stop mariadb

5. Remove it:
# rpm -e --nodeps `rpm -qf /usr/libexec/mysqld`

6. Create repository cache and install new MariaDB from it:
# yum makecache
# yum install mariadb-server
(will be prompted to hit "Y" a number of times)
...

The upgrade failed at step 6 when executing
# yum install mariadb-server
with the following errors:

Error:
Problem: package MariaDB-server-10.11.10-1.el8.x86_64 from mariadb requires galera-4, but none of the providers can be installed
- cannot install the best candidate for the job
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.13-1.el8.x86_64 from mariadb
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.14-1.el8.x86_64 from mariadb
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.16-1.el8.x86_64 from mariadb
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.18-1.el8.x86_64 from mariadb
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.19-1.el8.x86_64 from mariadb
- nothing provides libboost_program_options.so.1.66.0()(64bit) needed by galera-4-26.4.20-1.el8.x86_64 from mariadb
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

to resolve the errors, I tried to following as recommended by some posts:

# yum install -y https://dl.fedoraproject.org/pub/epel/epel-release-latest-9.noarch.rpm
# yum install boost-program-options

it seems that the installed boost-program-options version is 1.75.0

# rpm -qi boost-program-options
Name : boost-program-options
Version : 1.75.0
Release : 8.el9

and running command
# yum install mariadb-server
again will give the same errors.

Can somebody suggest a fix?

Thanks

 

[scsa20]

Looks like the mariadb repo you're installing from is from rhel8 instead of 9 so that alone could be one of the problems. Also make sure you are setting your packages sources correctly. For EPEL you might wanna look at Installing EPEL and RPM Fusion | AlmaLinux Wiki and for the sources for your dnf/yum for mariadb look at Download MariaDB Server - MariaDB.org (AlmaLinux 9 uses RHEL 9 for example).

You might also want to read up on the upgrade process at https://support.plesk.com/hc/en-us/...-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux (note that they're using 10.4 as the example but replace 10.4 with 10.11).

 

[sder]

@scsa20 Thanks for providing the hints. After changing rhel8 to rhel9 in the mariadb.repo file, the installation was successful.

 

[sder]

Based on tanasis and Peter Debik's notes, below are the steps followed through to successfully upgrade MariaDB 10.5 to 10.11 on AlmaLinux 9
---------------------------------------------------------------------------------------------------------------------------------------------------
How to upgrade MariaDB from 10.3/10.5/10.6 to 10.11 on AlmaLinux 9

Warning: run your upgrade in a test environment first before performing upgrade in production

Actions performed as root.

1. Create dump backup folder:
# mkdir /upgrade/dbbackups

2. Dump databases, just in case (don't proceed if this action failed):
# plesk db -Ne 'show databases' | egrep -vE '(information_schema|performance_schema|mysql)' | xargs -l bash -c 'mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` $0 > /upgrade/dbbackups/$0.sql'

3. Create /etc/yum.repos.d/mariadb.repo with the following contents:
[mariadb]
name = MariaDB
baseurl=Index of /yum/10.11/rhel9-amd64/
module_hotfixes=1
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

4. Stop mariadb server:
# systemctl stop mariadb

5. Remove it:
# rpm -e --nodeps `rpm -qf /usr/libexec/mysqld`

6. Create repository cache and install new MariaDB from it:
# yum makecache
# yum install mariadb-server
(will be prompted to hit "Y" a number of times)

7. Adjust config's bind_address value:
# sed -i 's/::ffff://' /etc/my.cnf

8. Start MariaDB 10.11:
# systemctl start mariadb

9. Upgrade tables:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

10. Let your Plesk installation know you have a new MariaDB version
# plesk sbin packagemng -sdf

-- possible issue fixes

If the following errors happen during installation process
Error: Transaction test error:
file /usr/share/man/man1/mariabackup.1.gz from install of MariaDB-server-10.11.10-1.el9.x86_64 conflicts with file from package mariadb-backup-3:10.5.22-1.el9_2.alma.1.x86_64
file /usr/share/man/man1/mbstream.1.gz from install of MariaDB-server-10.11.10-1.el9.x86_64 conflicts with file from package mariadb-backup-3:10.5.22-1.el9_2.alma.1.x86_64

run the following commands to fix

# rpm -qa | grep mariadb

mariadb-connector-c-config-3.2.6-1.el9_0.noarch
mariadb-common-10.5.22-1.el9_2.alma.1.x86_64
mariadb-errmsg-10.5.22-1.el9_2.alma.1.x86_64
mariadb-connector-c-3.2.6-1.el9_0.x86_64
mariadb-10.5.22-1.el9_2.alma.1.x86_64
plesk-libmariadbclient-3.4-3.4.1-2.redhat.9+p18.0.64.0+t240829.1940.x86_64
mariadb-gssapi-server-10.5.22-1.el9_2.alma.1.x86_64
mariadb-server-utils-10.5.22-1.el9_2.alma.1.x86_64
mariadb-backup-10.5.22-1.el9_2.alma.1.x86_64

# rpm -ev --nodeps mariadb-backup-10.5.22-1.el9_2.alma.1.x86_64

Preparing packages...
mariadb-backup-3:10.5.22-1.el9_2.alma.1.x86_64