• 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

Question Unable to update MariaDB-server

T

towerman

New Pleskian
Hello guys,

since some weeks, my Plesk server said that there is an update about MariaDB-server 10.5.13-1.el7.centos.
If I try to install it, the install seems to be OK but I still have that update to do.
Is there anything I've to do more?

I'm running Plesk Obsidian v18.0.39_build1800211014.23 os_CentOS 7 - CentOS Linux 7.9.2009

Thanks in advance.
 
Please check the actual version of MariaDB with the following command:

# rpm -qa | grep mariadb-server
 
What about

# rpm -qa | grep maria

and

# rpm -qa | grep mysql

?
 
For example, on my test Plesk server based on CentOS 7 I see the following status of MariaDB server package:

# plesk sbin pum -l | grep -i maria
2021-11-18 15:43:20 INFO: pum is called with arguments: ['-l']
Package 'mariadb' version '1:5.5.68-1.el7' is up-to-date
Package 'mariadb-devel' version '1:5.5.68-1.el7' is up-to-date
Package 'mariadb-libs' version '1:5.5.68-1.el7' is up-to-date
Package 'mariadb-server' version '1:5.5.68-1.el7' is up-to-date
Package 'plesk-libmariadbclient-3.1' version '3.1.8-1centos.7.200603.1842' is up-to-date
2021-11-18 15:43:26 INFO: pum completed successfully
 
This is what I get

Code: 
[root@plesk ~]# plesk sbin pum -l | grep -i maria
2021-11-18 09:55:52 INFO: pum is called with arguments: ['-l']
Package 'MariaDB-client' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-common' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-compat' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-server' version '10.3.31-1.el7.centos'  is updatable to version '10.5.13-1.el7.centos'
Package 'MariaDB-shared' version '10.5.13-1.el7.centos'  is up-to-date
Package 'plesk-libmariadbclient-1.0' version '1.0.0-1centos.7.190329.1026'  is up-to-date
Package 'plesk-libmariadbclient-3.0' version '3.0.9-1centos.7.200430.1921'  is up-to-date
Package 'plesk-libmariadbclient-3.1' version '3.1.8-1centos.7.200603.1842'  is up-to-date
2021-11-18 09:56:09 INFO: pum completed successfully
 
towerman said:
Package 'MariaDB-server' version '10.3.31-1.el7.centos' is updatable to version '10.5.13-1.el7.centos'
Click to expand...
Try to perform update now with:

# plesk sbin pum -u

and then check again

# plesk sbin pum -l | grep -i maria
 
IgorG said:
Try to perform update now with:

# plesk sbin pum -u

and then check again

# plesk sbin pum -l | grep -i maria
Click to expand...

Nothing to do

Code: 
[root@plesk ~]# plesk sbin pum -u
2021-11-18 10:05:02 INFO: pum is called with arguments: ['-u']
Determining fastest mirrors
 * atomic: mirrors.thzhost.com
 * base: mirrors.prometeus.net
 * extras: mirrors.prometeus.net
 * updates: mirrors.prometeus.net
2021-11-18 10:05:13 INFO: updating packages: MariaDB-server
No Presto metadata available for mariadb
Running Transaction Check

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.3.31-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.3 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: %pre(MariaDB-server-10.5.13-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.5.13-1.el7.centos.x86_64
MariaDB-server-10.3.31-1.el7.centos.x86_64 was supposed to be removed but is not!
Verify: 1/2: MariaDB-server.x86_64 0:10.3.31-1.el7.centos - ud
Verify: 2/2: MariaDB-server.x86_64 0:10.5.13-1.el7.centos - u
2021-11-18 10:05:18 INFO: pum completed successfully

[root@plesk ~]# plesk sbin pum -l | grep -i maria
2021-11-18 10:05:29 INFO: pum is called with arguments: ['-l']
Package 'MariaDB-client' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-common' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-compat' version '10.5.13-1.el7.centos'  is up-to-date
Package 'MariaDB-server' version '10.3.31-1.el7.centos'  is updatable to version '10.5.13-1.el7.centos'
Package 'MariaDB-shared' version '10.5.13-1.el7.centos'  is up-to-date
Package 'plesk-libmariadbclient-1.0' version '1.0.0-1centos.7.190329.1026'  is up-to-date
Package 'plesk-libmariadbclient-3.0' version '3.0.9-1centos.7.200430.1921'  is up-to-date
Package 'plesk-libmariadbclient-3.1' version '3.1.8-1centos.7.200603.1842'  is up-to-date
2021-11-18 10:05:32 INFO: pum completed successfully
 
IgorG said:
Try to use this instruction: https://support.plesk.com/hc/en-us/...5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux-
Click to expand...

Tried with the script, but error again

Code: 
[root@plesk ~]# ./mariadb-10.5-upgrade.sh
Dumping all databases
stopping MariaDB service
creating backup of mysql directory
removing mysql-server package in case it exists
errore: il pacchetto MariaDB-server-10.3.31-1.el7.centos.x86_64
MariaDB-server-10.3.31-1.el7.centos.x86_64 non è stato installato
Upgrading MariaDB
Plugin abilitati:fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: mirrors.thzhost.com
 * base: mirrors.prometeus.net
 * extras: mirrors.prometeus.net
 * updates: mirrors.prometeus.net
mariadb                                                                                                                                                                                  | 3.4 kB  00:00:00
Il pacchetto MariaDB-client-10.5.13-1.el7.centos.x86_64 è già installato e aggiornato all'ultima versione
Il pacchetto MariaDB-compat-10.5.13-1.el7.centos.x86_64 è già installato e aggiornato all'ultima versione
Il pacchetto MariaDB-shared-10.5.13-1.el7.centos.x86_64 è già installato e aggiornato all'ultima versione
Risoluzione dipendenze
--> Esecuzione del controllo di transazione
---> Pacchetto MariaDB-server.x86_64 0:10.3.31-1.el7.centos settato per essere aggiornato
---> Pacchetto MariaDB-server.x86_64 0:10.5.13-1.el7.centos settato per essere un aggiornamento
--> Risoluzione delle dipendenze completata

Dipendenze risolte

================================================================================================================================================================================================================
 Package                                             Arch                                        Versione                                                    Repository                                    Dim.
================================================================================================================================================================================================================
Aggiornamento:
 MariaDB-server                                      x86_64                                      10.5.13-1.el7.centos                                        mariadb                                       26 M

Riepilogo della transazione
================================================================================================================================================================================================================
Upgrade  1 Pacchetto

Dimensione totale del download: 26 M
Downloading packages:
No Presto metadata available for mariadb
MariaDB-server-10.5.13-1.el7.centos.x86_64.rpm                                                                                                                                           |  26 MB  00:00:03
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction

******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.3.31-1.el7.centos.x86_64) is installed.

Upgrading directly from MySQL 10.3 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: %pre(MariaDB-server-10.5.13-1.el7.centos.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server-10.5.13-1.el7.centos.x86_64
MariaDB-server-10.3.31-1.el7.centos.x86_64 was supposed to be removed but is not!
  Verifica in corso : MariaDB-server-10.3.31-1.el7.centos.x86_64                                                                                                                                            1/2
  Verifica in corso : MariaDB-server-10.5.13-1.el7.centos.x86_64                                                                                                                                            2/2

Fallito:
  MariaDB-server.x86_64 0:10.3.31-1.el7.centos                                                           MariaDB-server.x86_64 0:10.5.13-1.el7.centos

Completo!
This installation of MySQL is already upgraded to 10.3.31-MariaDB, use --force if you still need to run mysql_upgrade
Informing Plesk of the changes (plesk sbin packagemng -sdf)
 
Do you have any third-party repositories enabled for yum? Try to disable them.
Contact Plesk Support Team if not help.
 
You must log in or register to reply here.

Similar threads

B
Question Can I upgrade to MariaDB 10.4.33 with Plesk Obsidian 18.0.42 and CentOS 7.9.2009 Server?
Replies
1
Views
134
scsa20
scsa20
iGraphics
Question How to update MariaDB 10.5.24 to 10.11
Replies
2
Views
462
Peter Debik
P
S
Issue Cannot add remote database
Replies
3
Views
519
sistemisti
S
R
Question Info on updating MariaDB
Replies
3
Views
825
Maarten.
M
dash
  • Sticky
Question Try our new tool to upgrade your old MariaDB server from Plesk UI
2 3
Replies
49
Views
5K
othmaqsa
O
Back
Top