Issue System updates: package conflicts

[mcbus94]

Server operating system version

AlmaLinux 9.7 (Moss Jungle Cat)

Plesk version and microupdate number

Plesk Obsidian v18.0.74_build1800251121.15 os_RedHat el9

We have got automatic system updated. We are receiving this attached mail that contains error log from about 5 days.

If I try to execute updated from Plesk->Tools and settings->System Updated, when I click "update all" nothing happes.

If I try to execute via ssh "yum update" I receive this error:

Total 41 MB/s | 94 MB 00:02
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 mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/ascii.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp1250.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp1251.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp1256.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp1257.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp850.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp852.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/cp866.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/dec8.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/geostd8.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/greek.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/hebrew.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/hp8.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/koi8r.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/koi8u.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/latin1.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/latin2.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/latin5.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/latin7.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/macce.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/macroman.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64
file /usr/share/mysql/charsets/swe7.xml from install of mysql-common-8.0.43-1.el9_6.x86_64 conflicts with file from package MariaDB-common-10.11.15-1.el9.x86_64

How can I solve?

Thank you in advance. I appreciate your support.

 

[scsa20]

Do you have MySQL installed as well or in the process of removing MySQL for MariaDB? Can you confirm what packages you currently have? (This can be checked using rpm -qa | grep -i maria and rpm -qa | grep -i mysql).

 

[mcbus94]

We use only MariaDB.
Here below results:
rpm -qa | grep -i maria:

MariaDB-shared-10.11.15-1.el9.x86_64
MariaDB-common-10.11.15-1.el9.x86_64
MariaDB-client-10.11.15-1.el9.x86_64
MariaDB-server-10.11.15-1.el9.x86_64
plesk-libmariadbclient-3.4-3.4.7-2.redhat.9+p18.0.74.0+t251031.0848.x86_64

rpm -qa | grep -i mysql

plesk-mysql-server-18.0.2-2.redhat.9+p18.0.61.0+t240426.1307.noarch
perl-DBD-MySQL-4.050-13.el9.x86_64
mysql-selinux-1.0.14-1.el9_6.noarch
plesk-php82-mysql-8.2.29-0redhat.9.251022.1328.x86_64
alt-php-internal-mysqlnd-8.2.28-6.el9.x86_64
plesk-php84-mysql-8.4.15-0redhat.9.251121.1238.x86_64
plesk-php83-mysql-8.3.28-0redhat.9.251121.1312.x86_64

Thank you I appreciate your help

 

[Bitpalast]

I think the repository from where the updated files are coming is not the MariaDB repository, but a MySQL repository. Check /etc/yum.repos.d, find the SQL repository (repositories maybe), e.g. mariadb.repo. It should contain a section that points to a MariaDB source such as

[mariadb-main]
name = MariaDB Server
baseurl = https://dlm.mariadb.com/repo/mariadb-server/10.11.14/yum/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
module_hotfixes = 1

or similar, depending on version and operating system. It must not point to a MySQL source.

 

[MHC_1]

We have got this exact issue; however the issue is caused by the update for:

Update Packages​

Install the following updates:

• perl-DBD-MySQL 4.053-1.el9

2 dependent packages

• mysql-common 8.0.43-1.el9_6
• mysql-libs 8.0.43-1.el9_6

I do not know where the Perl-DBD-MySQL package comes from but running it causes the Plesk Update GUI to become unresponsive. On CLI the yum update has these two MySQL dependencies which can't install due to clashing with MariaDB.

How do we get this perl-DBD-MySQL 4.053-1.el9 package to update from Maria DB repo's?

( And yes we have a companion Perl-DBD-MariaDB package listed too. )

 

[Sebahat.hadzhi]

@MHC_1 , you can lock the perl-DBD-MySQL package from Tools and settings > Update settings > All packages. If you don't see the "All packages" section, please refer to the instructions here on how to enable it.


As per out team - In the latest version of perl-DBD-MySQL package, it now depends on mysql-libs, which depends on mysql-common, and mysql-common conflicts with MariaDB-common

 

[MHC_1]

@MHC_1 , you can lock the perl-DBD-MySQL package from Tools and settings > Update settings > All packages. If you don't see the "All packages" section, please refer to the instructions here on how to enable it.


As per out team - In the latest version of perl-DBD-MySQL package, it now depends on mysql-libs, which depends on mysql-common, and mysql-common conflicts with MariaDB-common

Hello!
Yes this has already been done (Locking that package). I wasn't sure if there was a workaround we could do but looks like maybe not. Thanks.

 

[mcbus94]

I think the repository from where the updated files are coming is not the MariaDB repository, but a MySQL repository. Check /etc/yum.repos.d, find the SQL repository (repositories maybe), e.g. mariadb.repo. It should contain a section that points to a MariaDB source such as

[mariadb-main]
name = MariaDB Server
baseurl = https://dlm.mariadb.com/repo/mariadb-server/10.11.14/yum/rhel/8/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
module_hotfixes = 1

or similar, depending on version and operating system. It must not point to a MySQL source.

Hi @Bitpalast
the repository is Mariadb and not Mysql:

cat /etc/yum.repos.d/mariadb.repo

[mariadb-main]
name = MariaDB Server
baseurl = https://dlm.mariadb.com/repo/mariadb-server/10.11/yum/rhel/9/x86_64
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
module_hotfixes = 1


[mariadb-tools]
name = MariaDB Tools
baseurl = Index of /legacy/tools/rhel/9/x86_64/
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
gpgcheck = 1
enabled = 1

 

[mcbus94]

Sorry the doubledmessage,
I have also the package perl-DBD-MySQL 4.053-1.el9 that need to be updated. This was the issue.
I have locked the package auto update.