[MDEV-33366] Update MariaDB from 10.4.32 to 10.5 Created: 2024-02-02  Updated: 2024-02-03

Status: Needs Feedback
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.4.32, 10.5.23
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Ricardo Ribeiro Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

AlmaLinux 8 - Plesk Panel


Attachments: JPEG File mariadb.jpg    

 Description   

Hi all,

I recently upgraded the old version from 10.3 to 10.4.32, and now I wanted to do the rest of the updates, starting with 10.5, but I'm getting the following error:

If you can help me, I would appreciate it.

yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
Upgrading directly from MySQL 10.4 to MariaDB 10.5 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
 
A manual upgrade is required.
 
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
 
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
 
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-10.5.23-1.el8.x86_64) scriptlet failed, exit status 1
 
Error in PREIN scriptlet in rpm package MariaDB-server
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 5/10
error: MariaDB-server-10.5.23-1.el8.x86_64: install failed
 
Upgrading : MariaDB-backup-10.5.23-1.el8.x86_64 5/10
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 5/10
Running scriptlet: MariaDB-client-10.4.32-1.el8.x86_64 6/10
error: MariaDB-server-10.4.32-1.el8.x86_64: erase skipped
 
Cleanup : MariaDB-client-10.4.32-1.el8.x86_64 6/10
Running scriptlet: MariaDB-client-10.4.32-1.el8.x86_64 6/10
Running scriptlet: MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Cleanup : MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Running scriptlet: MariaDB-backup-10.4.32-1.el8.x86_64 7/10
Running scriptlet: MariaDB-common-10.4.32-1.el8.x86_64 8/10
Cleanup : MariaDB-common-10.4.32-1.el8.x86_64 8/10
Running scriptlet: MariaDB-common-10.4.32-1.el8.x86_64 8/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Cleanup : MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-common-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-client-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-backup-10.5.23-1.el8.x86_64 9/10
Running scriptlet: MariaDB-shared-10.4.32-1.el8.x86_64 9/10
Verifying : MariaDB-backup-10.5.23-1.el8.x86_64 1/10
Verifying : MariaDB-backup-10.4.32-1.el8.x86_64 2/10
Verifying : MariaDB-client-10.5.23-1.el8.x86_64 3/10
Verifying : MariaDB-client-10.4.32-1.el8.x86_64 4/10
Verifying : MariaDB-common-10.5.23-1.el8.x86_64 5/10
Verifying : MariaDB-common-10.4.32-1.el8.x86_64 6/10
Verifying : MariaDB-server-10.5.23-1.el8.x86_64 7/10
Verifying : MariaDB-server-10.4.32-1.el8.x86_64 8/10
Verifying : MariaDB-shared-10.5.23-1.el8.x86_64 9/10
Verifying : MariaDB-shared-10.4.32-1.el8.x86_64 10/10
 
Upgraded:
MariaDB-backup-10.5.23-1.el8.x86_64 MariaDB-client-10.5.23-1.el8.x86_64
MariaDB-common-10.5.23-1.el8.x86_64 MariaDB-shared-10.5.23-1.el8.x86_64
Failed:
MariaDB-server-10.4.32-1.el8.x86_64 MariaDB-server-10.5.23-1.el8.x86_64
 
Error: Transaction failed

I try more, and continue...

problem continue when try update to MariaDb 10.5

Upgraded:
MariaDB-backup-10.5.23-1.el8.x86_64 MariaDB-client-10.5.23-1.el8.x86_64
MariaDB-common-10.5.23-1.el8.x86_64 MariaDB-shared-10.5.23-1.el8.x86_64
Failed:
MariaDB-server-10.4.32-1.el8.x86_64 MariaDB-server-10.5.23-1.el8.x86_64
 
Error: Transaction failed

Try plesk tool upgrade:

Removing previous mariadb-server provider ...
Removing previous packages (MariaDB-devel-10.5.23-1.el8.x86_64) ...
Upgrading packages (MariaDB-server MariaDB-client MariaDB-shared MariaDB-common MariaDB-devel MariaDB-backup) ...
AlmaLinux 8 - BaseOS 12 MB/s | 5.2 MB 00:00
AlmaLinux 8 - AppStream 22 MB/s | 12 MB 00:00
AlmaLinux 8 - Extras 61 kB/s | 20 kB 00:00
AlmaLinux 8 - PowerTools 7.8 MB/s | 3.1 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 35 MB/s | 16 MB 00:00
kernelcare 41 kB/s | 47 kB 00:01
MariaDB Server 460 kB/s | 622 kB 00:01
...grafana extension repository 1.4 MB/s | 108 kB 00:00
panel-migrator extension repository 600 kB/s | 34 kB 00:00
site-import extension repository 684 kB/s | 34 kB 00:00
sophos-av extension repository 21 kB/s | 1.3 kB 00:00
All matches were filtered out by exclude filtering for argument: MariaDB-server
* Maybe you meant: mariadb-server
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Error: Unable to find a match: MariaDB-server
 
Removing previous mariadb-server provider ...
Removing previous packages (MariaDB-devel-10.5.23-1.el8.x86_64) ...
Upgrading packages (MariaDB-server MariaDB-client MariaDB-shared MariaDB-common MariaDB-devel MariaDB-backup) ...
AlmaLinux 8 - BaseOS 12 MB/s | 5.2 MB 00:00
AlmaLinux 8 - AppStream 22 MB/s | 12 MB 00:00
AlmaLinux 8 - Extras 61 kB/s | 20 kB 00:00
AlmaLinux 8 - PowerTools 7.8 MB/s | 3.1 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 35 MB/s | 16 MB 00:00
kernelcare 41 kB/s | 47 kB 00:01
MariaDB Server 460 kB/s | 622 kB 00:01
...site-import extension repository 684 kB/s | 34 kB 00:00
sophos-av extension repository 21 kB/s | 1.3 kB 00:00
All matches were filtered out by exclude filtering for argument: MariaDB-server
* Maybe you meant: mariadb-server
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Error: Unable to find a match: MariaDB-server
Service mariadb doesn't exist
 
Usage: register_service {--enable service [options] | --disable service | --list | --full-list}
Enables or disables the specified service.
 
--enable enable the specified service
--disable disable the specified service
--list show list of services
--full-list show list of services with status
 
enable options:
--with-resource-controller register the service in Plesk Resource Controller

I Run this command:

[root@ns340238 ~]# sudo rpm -qa | grep -i mariadb
MariaDB-common-10.5.23-1.el8.x86_64
MariaDB-client-10.4.32-1.el8.x86_64
plesk-libmariadbclient-3.1-3.1.8-1centos.8.200603.1842.x86_64
MariaDB-backup-10.5.23-1.el8.x86_64
MariaDB-server-10.4.32-1.el8.x86_64
plesk-libmariadbclient-3.3-3.3.5-2.redhat.8+p18.0.59.0+t240111.0903.x86_64
MariaDB-shared-10.5.23-1.el8.x86_64



 Comments   
Comment by Sergei Golubchik [ 2024-02-02 ]

Please, read the message that you've got from the first upgrade, it includes step-by-step instructions of what to do.
Let me quote it again:

Upgrading directly from MySQL 10.4 to MariaDB 10.5 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
 
A manual upgrade is required.
 
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
 
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
 
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.

Comment by Ricardo Ribeiro [ 2024-02-03 ]

Thanks, but I'm afraid of losing something, I've done it before and lost access to the dashboard, I was only able to restore after a backup, not if I'll be able to do it again.

I've tried a few commands and I always get these results:

[root@ns340238 ~]# yum install MariaDB-server galera-4 MariaDB-client MariaDB-sh ared MariaDB-backup MariaDB-common

AlmaLinux 8 - BaseOS 14 MB/s | 5.2 MB 00:00
AlmaLinux 8 - AppStream 26 MB/s | 12 MB 00:00
AlmaLinux 8 - Extras 53 kB/s | 20 kB 00:00
AlmaLinux 8 - PowerTools 8.8 MB/s | 3.1 MB 00:00
Extra Packages for Enterprise Linux 8 - x86_64 24 MB/s | 16 MB 00:00
kernelcare 39 kB/s | 47 kB 00:01
MariaDB 780 kB/s | 622 kB 00:00
PLESK_18_0_58 extras 1.5 MB/s | 157 kB 00:00
PHP 8.0 189 kB/s | 19 kB 00:00
PHP 8.1 242 kB/s | 19 kB 00:00
PHP 8.2 366 kB/s | 19 kB 00:00
PHP 8.3 270 kB/s | 19 kB 00:00
grafana extension repository 1.6 MB/s | 108 kB 00:00
panel-migrator extension repository 827 kB/s | 34 kB 00:00
site-import extension repository 796 kB/s | 34 kB 00:00
sophos-av extension repository 20 kB/s | 1.3 kB 00:00
Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
Package galera-4-26.4.16-1.el8.x86_64 is already installed.
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Error:
Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts wit h MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System

  • cannot install the best candidate for the job
  • problem with installed package MariaDB-server-10.4.32-1.el8.x86_64
    (try to add '-allowerasing' to command line to replace conflicting packages or 'skip-broken' to skip uninstallable packages or '-nobest' to use not only bes t candidate packages)
    [root@ns340238 ~]#
    [root@ns340238 ~]# yum --allowwerasing install MariaDB-server galera-4 MariaDB-c lient MariaDB-shared MariaDB-backup MariaDB-common
    usage: yum install [-c [config file]] [-q] [-v] [--version]
    [--installroot [path]] [--nodocs] [--noplugins]
    [-enableplugin [plugin]] [-disableplugin [plugin]]
    [--releasever RELEASEVER] [--setopt SETOPTS]
    [--skip-broken] [-h] [--allowerasing] [-b | --nobest] [-C]
    [-R [minutes]] [-d [debug level]] [--debugsolver]
    [--showduplicates] [-e ERRORLEVEL] [--obsoletes]
    [--rpmverbosity [debug level name]] [-y] [--assumeno]
    [-enablerepo [repo]] [-disablerepo [repo] | --repo
    [repo]] [--enable | --disable] [-x [package]]
    [-disableexcludes [repo]] [-repofrompath [repo,path]]
    [--noautoremove] [--nogpgcheck] [--color COLOR] [--refresh]
    [-4] [-6] [--destdir DESTDIR] [--downloadonly]
    [--comment COMMENT] [--bugfix] [--enhancement]
    [--newpackage] [--security] [--advisory ADVISORY]
    [--bz BUGZILLA] [--cve CVES]
    [--sec-severity {Critical,Important,Moderate,Low}

    ]
    [--forcearch ARCH]
    PACKAGE [PACKAGE ...]
    yum install: error: unrecognized arguments: --allowwerasing
    [root@ns340238 ~]# yum --allowerasing install MariaDB-server galera-4 MariaDB-cl ient MariaDB-shared MariaDB-backup MariaDB-common
    Last metadata expiration check: 0:01:02 ago on Sat 03 Feb 2024 01:01:22 PM WET.
    Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
    Package galera-4-26.4.16-1.el8.x86_64 is already installed.
    Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
    Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
    Error:
    Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts wit h MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System

  • cannot install the best candidate for the job
  • conflicting requests
    (try to add '-skip-broken' to skip uninstallable packages or '-nobest' to use not only best candidate packages)
    [root@ns340238 ~]# yum --nobest install MariaDB-server galera-4 MariaDB-client M ariaDB-shared MariaDB-backup MariaDB-common
    Last metadata expiration check: 0:01:19 ago on Sat 03 Feb 2024 01:01:22 PM WET.
    Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
    Package galera-4-26.4.16-1.el8.x86_64 is already installed.
    Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
    Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
    Dependencies resolved.

Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts wit h MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System

  • cannot install the best candidate for the job
  • problem with installed package MariaDB-server-10.4.32-1.el8.x86_64
    ================================================================================
    Package Architecture Version Repository Size
    ================================================================================
    Skipping packages with conflicts:
    (add '--best --allowerasing' to command line to force their upgrade):
    MariaDB-client x86_64 10.5.23-1.el8 mariadb 13 M

Transaction Summary
================================================================================
Skip 1 Package

Nothing to do.
Complete!
[root@ns340238 ~]# yum --nobest install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
Last metadata expiration check: 0:01:49 ago on Sat 03 Feb 2024 01:01:22 PM WET.
Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
Package galera-4-26.4.16-1.el8.x86_64 is already installed.
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Dependencies resolved.

Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts with MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System

  • cannot install the best candidate for the job
  • problem with installed package MariaDB-server-10.4.32-1.el8.x86_64
    ================================================================================================================================
    Package Architecture Version Repository Size
    ================================================================================================================================
    Skipping packages with conflicts:
    (add '--best --allowerasing' to command line to force their upgrade):
    MariaDB-client x86_64 10.5.23-1.el8 mariadb 13 M

Transaction Summary
================================================================================================================================
Skip 1 Package

Nothing to do.
Complete!
[root@ns340238 ~]# yum --best --allowerasing install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
Last metadata expiration check: 0:02:15 ago on Sat 03 Feb 2024 01:01:22 PM WET.
Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
Package galera-4-26.4.16-1.el8.x86_64 is already installed.
Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
Error:
Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts with MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System

  • cannot install the best candidate for the job
  • conflicting requests
    (try to add '--skip-broken' to skip uninstallable packages)
    [root@ns340238 ~]# yum --skip-broken install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
    Last metadata expiration check: 0:02:40 ago on Sat 03 Feb 2024 01:01:22 PM WET.
    Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
    Package galera-4-26.4.16-1.el8.x86_64 is already installed.
    Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
    Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
    Dependencies resolved.
    Nothing to do.
    Complete!
    [root@ns340238 ~]# yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common Last metadata expiration check: 0:02:59 ago on Sat 03 Feb 2024 01:01:22 PM WET.
    Package MariaDB-server-10.4.32-1.el8.x86_64 is already installed.
    Package galera-4-26.4.16-1.el8.x86_64 is already installed.
    Package MariaDB-client-10.4.32-1.el8.x86_64 is already installed.
    Package MariaDB-shared-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-backup-10.5.23-1.el8.x86_64 is already installed.
    Package MariaDB-common-10.5.23-1.el8.x86_64 is already installed.
    Error:
    Problem: package MariaDB-client-10.5.23-1.el8.x86_64 from mariadb conflicts with MariaDB-server <= 10.5.10 provided by MariaDB-server-10.4.32-1.el8.x86_64 from @System
  • cannot install the best candidate for the job
  • problem with installed package MariaDB-server-10.4.32-1.el8.x86_64
    (try to add '-allowerasing' to command line to replace conflicting packages or 'skip-broken' to skip uninstallable packages or '-nobest' to use not only best candidate packages)
Generated at Thu Feb 08 10:38:22 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.