• 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

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

N
Resolved Update MariaDB from 10.4.32 to 10.5
2
Replies
28
Views
4K
NITROFOX
N
Jan Bludau
Resolved Debian 11 to Debian 12
Replies
2
Views
2K
Jan Bludau
Jan Bludau
H
Question Upgrade CentOS 7.9 to Alma Linux python errors
Replies
4
Views
3K
Heppi75
H
M
Resolved Migration from Centos to Rocky issue with ModSecurity
Replies
10
Views
2K
gzamanis
G
GDuck24
Issue 18.0.59 (Update #2) failing to update to 18.0.60
Replies
2
Views
320
daniiii_e
D
Back
Top