Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33366

Update MariaDB from 10.4.32 to 10.5

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.4.32, 10.5.23
    • N/A
    • Packaging, Upgrades
    • None
    • AlmaLinux 8 - Plesk Panel

    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

      Attachments

        1. mariadb.jpg
          277 kB
          Ricardo Ribeiro

        Activity

          People

            Unassigned Unassigned
            nitrofox Ricardo Ribeiro
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.