• We value your experience with Plesk during 2024
    Plesk strives to perform even better in 2025. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2024.
    Please take this short survey:
    https://pt-research.typeform.com/to/AmZvSXkx
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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

J
Issue Update MariaDB 5.5 to 10.5 failed, system crash
Replies
1
Views
745
JuanCar
J
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
547
scsa20
scsa20
davidds64
Question How to upgrade MariaDB to latest version with Plesk Obsidian on Alma Linux 9
Replies
5
Views
1K
davidds64
davidds64
Daerik
Issue Error Upgrading Plesk Obsidian 18.0.63 to 18.0.64: HTTPS Error 404 - Not Found (MaxScale Repo)
Replies
6
Views
836
Daerik
Daerik
iGraphics
Question How to update MariaDB 10.5.24 to 10.11
Replies
2
Views
2K
Peter Debik
P
Back
Top