• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • 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.

Issue Upgrade MariaDB

H

helpchrisplz

Basic Pleskian
Hi there.

I have just taken out a new server running MariaDB 10.3.17 on Plesk Obsidian Version 18.0.30 Update #2

One of my new websites is going to use the new version of Magento that lists MariaDB 10.4 as a requirement so I have followed this guide to upgrade to MariaDB 10.4:
 How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

My server runs CentOS 8 so I have followed the example in the Plesk on CentOS 8 section but I have run into an issue.

When I get to this step I get some errors
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin --verbose --all-databases --routines --triggers > /tmp/all-databases.sql

Code: 
Error: Transaction test error:
  file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/armscii8.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/ascii.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp1250.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp1251.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp1256.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp1257.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp850.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp852.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/cp866.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/dec8.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/geostd8.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/greek.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/hebrew.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/hp8.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/keybcs2.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/koi8r.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/koi8u.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/latin1.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/latin2.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/latin5.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/latin7.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/macce.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/macroman.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64
  file /usr/share/mysql/charsets/swe7.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21-1.module_el8.2.0+493+63b41e36.x86_64

I have attached the full output of my terminal and the error is at the end of the attached log.
Please can anyone let me know what I can do? Thank you.
 

Attachments

  • install-MariaDB-10-4.log.zip
    9.9 KB · Views: 2
I've upgraded about a dozen CentOS 8 servers to MariaDB 10.4 for Magento 2.4 using the instructions in the Plesk link you referenced and have never had an issue.

The 'Upgrade MYSQL databases' command should be
Code: 
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin
and you'll have no errors.

Also be sure to copy the entire code, including the hotfix line when creating the repo file.
 
Hi sorry

Its when I got to this command that I got the error:
yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common

and that's 2 commands above the command you mentioned: MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin

Code: 
[root@inspiring-bohr ~]# yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common
MariaDB                                                                           354 kB/s | 517 kB     00:01   
CentOS-8 - AppStream                                                               19 MB/s | 5.8 MB     00:00   
CentOS-8 - Base                                                                   8.9 MB/s | 2.2 MB     00:00   
CentOS-8 - Extras                                                                  68 kB/s | 8.1 kB     00:00   
CentOS-8 - PowerTools                                                             2.2 MB/s | 1.9 MB     00:00   
grafana extension repository                                                       11 MB/s | 3.3 MB     00:00   
nodejs extension repository                                                       855 kB/s |  83 kB     00:00   
panel-migrator extension repository                                               295 kB/s |  37 kB     00:00   
ruby extension repository                                                         363 kB/s |  42 kB     00:00   
PLESK_18_0_30 extras                                                              1.6 MB/s | 162 kB     00:00   
PHP 7.1 for Plesk 17                                                              475 kB/s |  29 kB     00:00   
PHP 7.2 for Plesk 17                                                              462 kB/s |  29 kB     00:00   
PHP 7.3                                                                           456 kB/s |  29 kB     00:00   
PHP 7.4                                                                           471 kB/s |  29 kB     00:00   
Dependencies resolved.
==================================================================================================================
 Package                            Architecture        Version                      Repository              Size
==================================================================================================================
Installing:
 MariaDB-backup                     x86_64              10.4.15-1.el8                mariadb                6.7 M
     replacing  mariadb-backup.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
 MariaDB-client                     x86_64              10.4.15-1.el8                mariadb                 12 M
     replacing  mariadb.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
 MariaDB-common                     x86_64              10.4.15-1.el8                mariadb                 87 k
     replacing  mariadb-common.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
     replacing  mariadb-errmsg.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
 MariaDB-server                     x86_64              10.4.15-1.el8                mariadb                 26 M
     replacing  mariadb-server.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
     replacing  mariadb-server-utils.x86_64 3:10.3.17-1.module_el8.1.0+257+48736ea6
 MariaDB-shared                     x86_64              10.4.15-1.el8                mariadb                116 k
     replacing  mariadb-connector-c.x86_64 3.0.7-1.el8
     replacing  mariadb-connector-c-config.noarch 3.0.7-1.el8
 galera-4                           x86_64              26.4.5-1.el8                 mariadb                 13 M
Installing dependencies:
 boost-program-options              x86_64              1.66.0-7.el8                 AppStream              140 k
 socat                              x86_64              1.7.3.3-2.el8                AppStream              302 k

Transaction Summary
==================================================================================================================
Install  8 Packages

Total download size: 59 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): MariaDB-common-10.4.15-1.el8.x86_64.rpm                                    129 kB/s |  87 kB     00:00   
(2/8): MariaDB-backup-10.4.15-1.el8.x86_64.rpm                                    2.4 MB/s | 6.7 MB     00:02   
(3/8): MariaDB-shared-10.4.15-1.el8.x86_64.rpm                                    1.0 MB/s | 116 kB     00:00   
(4/8): MariaDB-client-10.4.15-1.el8.x86_64.rpm                                    3.7 MB/s |  12 MB     00:03   
(5/8): boost-program-options-1.66.0-7.el8.x86_64.rpm                              1.0 MB/s | 140 kB     00:00   
(6/8): socat-1.7.3.3-2.el8.x86_64.rpm                                             3.9 MB/s | 302 kB     00:00   
(7/8): galera-4-26.4.5-1.el8.x86_64.rpm                                            14 MB/s |  13 MB     00:00   
(8/8): MariaDB-server-10.4.15-1.el8.x86_64.rpm                                    7.2 MB/s |  26 MB     00:03   
------------------------------------------------------------------------------------------------------------------
Total                                                                              14 MB/s |  59 MB     00:04     
warning: /var/cache/dnf/mariadb-8e0daa38f21ca158/packages/MariaDB-backup-10.4.15-1.el8.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 1bb943db: NOKEY
MariaDB                                                                            19 kB/s | 8.2 kB     00:00   
Importing GPG key 0x1BB943DB:
 Userid     : "MariaDB Package Signing Key <[email protected]>"
 Fingerprint: 1993 69E5 404B D5FC 7D2F E43B CBCB 082A 1BB9 43DB
 From       : https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
Is this ok [y/N]: y
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
The downloaded packages were saved in cache until the next successful transaction.
You can remove cached packages by executing 'yum clean packages'.
Error: Transaction test error:
  file /usr/share/mysql/charsets/Index.xml from install of MariaDB-common-10.4.15-1.el8.x86_64 conflicts with file from package mysql-common-8.0.21

in response to:
Also be sure to copy the entire code, including the hotfix line when creating the repo file.
Click to expand...
I attached the full terminal output so I'm not sure what you mean?
I did install elasticsearch on the server prior to doing upgrading MariaDB.
 
ok I get you now.

it does include module_hotfixes=1

Code: 
cat /etc/yum.repos.d/MariaDB.repo
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos8-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
priority=1
module_hotfixes=1

any other things you could suggest, please?
 
You must log in or register to reply here.

Similar threads

P
Issue Upgrade Mariadb 10.3 to 10.6 completes but trying to start MariaDB fails with error "systemctl status mariadb.service" and "journalctl -xe"
Replies
12
Views
510
PeterK900
P
N
Resolved Update MariaDB from 10.4.32 to 10.5
2
Replies
28
Views
8K
NITROFOX
N
J
Issue Update MariaDB 5.5 to 10.5 failed, system crash
Replies
1
Views
697
JuanCar
J
Daerik
Issue Error Upgrading Plesk Obsidian 18.0.63 to 18.0.64: HTTPS Error 404 - Not Found (MaxScale Repo)
Replies
6
Views
693
Daerik
Daerik
Dork
Issue Database Mangement problem
Replies
6
Views
1K
JuanCar
J
Back
Top