DNF update, MariaDB Problems.

[pierre]

Hi,

On one server, it is impossible to do a dnf update, it seems there is a conflict with different versions of MariaDB.

Error: Transaction test error:
  file /usr/lib64/libmariadb.so.3 from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/libmysqlclient.so.18 from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/auth_gssapi_client.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/caching_sha2_password.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/client_ed25519.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/dialog.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/mysql_clear_password.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/sha256_password.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/libmysqlclient.so from install of cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-devel-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/auth_gssapi_client.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/caching_sha2_password.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/client_ed25519.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/dialog.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/mysql_clear_password.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/sha256_password.so from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/lib64/mysql/plugin/auth_gssapi_client.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /usr/lib64/mysql/plugin/caching_sha2_password.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /usr/lib64/mysql/plugin/client_ed25519.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /usr/lib64/mysql/plugin/dialog.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /usr/lib64/mysql/plugin/mysql_clear_password.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /usr/lib64/mysql/plugin/sha256_password.so conflicts between attempted installs of cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  file /etc/my.cnf from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/charsets/Index.xml from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /lib64/security/pam_user_map.so from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/czech/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/danish/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/dutch/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/english/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/estonian/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/french/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/german/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/greek/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/hungarian/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
  file /usr/share/mysql/italian/errmsg.sys from install of cl-MariaDB103-libs-10.3.39-4.module_el8.8.0+6692+710afbab.cloudlinux.x86_64 conflicts with file from package cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
...
​

Any ideas ?

[john]

I've experienced the same issue on our servers, the following article fixed the issue.

https://cloudlinux.zendesk.com/hc/en-us/articles/9587297247260-Yum-update-error-file-usr-lib64-mysql-libmysqlclient-so-18-0-0-conflicts

[Miguel Varela]

Howdy pierre,

This is definitely not supposed to happen, can you try to upgrade to the same MariaDB version again using our Python script?

Here are the exact commands:

/usr/share/lve/dbgovernor/mysqlgovernor.py --mysql-version=mariadb103
/usr/share/lve/dbgovernor/mysqlgovernor.py --install

Even though this upgrade/install (to the same version, to see if solves the issues with the packages) doesn't touch /var/lib/mysql other than the main MySQL database, you should always create a backup of /var/lib/mysql, just in case. Once you've performed the two commands above, then you can try to run: yum clean all && yum update

Please give it a try and do keep us posted

[pierre]

Thank you Miguel.
I tried to follow the documentation to correctly backup Mysql but, anyhow, it seems outdated and/or my server doesn't recognize the --skip-networking and --skip-grant-tables options.
Note, this is a fresh server installation from 2 months ago.
Beside this, the current installed MariaDB version seems to be 10.6 (Ver 15.1 Distrib 10.6.14-MariaDB, for Linux (x86_64) using readline 5.1) and not 10.3. Could this be part of the problem ?

[Miguel Varela]

Thank you Miguel.
I tried to follow the documentation to correctly backup Mysql but, anyhow, it seems outdated and/or my server doesn't recognize the --skip-networking and --skip-grant-tables options.
Note, this is a fresh server installation from 2 months ago.
Beside this, the current installed MariaDB version seems to be 10.6 (Ver 15.1 Distrib 10.6.14-MariaDB, for Linux (x86_64) using readline 5.1) and not 10.3. Could this be part of the problem ?

Hey there,

Thank you for the further information.

Yes, that's most likely the issue.

Please run:

rpm -qa|grep MariaDB*

Let us know the results

[pierre]

Thank you very much.
Below the result of the command:

cl-MariaDB-meta-devel-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB-meta-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB-meta-client-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB106-devel-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB106-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
​

[Miguel Varela]

Thank you very much.
Below the result of the command:

cl-MariaDB-meta-devel-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB106-server-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB106-libs-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB-meta-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB-meta-client-10.6.15-1.module_el8.8.0+6704+ff54af0a.x86_64
cl-MariaDB106-devel-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
cl-MariaDB106-10.6.14-3.module_el8.8.0+6684+f38051c7.x86_64
​

Hey,

Thank you.

As I suspected, you've got MariaDB 10.6 but somehow yum is trying tor retrieve packages for the wrong MariaDB version.

I'd recommend you to open a ticket with us - our team is available to help 24/7 and we'll sort this for you - sorry it can't be done via the forums, but this does requires us to investigate further :-)

[pierre]

Thank you very much. I'll open a ticket right now.

[Miguel Varela]

Thank you very much. I'll open a ticket right now.

Pierre,

Sure thing!

Rest assured that we'll sort this for you :-)

Cheers!

[john]

I've experienced the same issue on our servers, the following article fixed the issue.

https://cloudlinux.zendesk.com/hc/en-us/articles/9587297247260-Yum-update-error-file-usr-lib64-mysql-libmysqlclient-so-18-0-0-conflicts

[Miguel Varela]

I've experienced the same issue on our servers, the following article fixed the issue.
https://cloudlinux.zendesk.com/hc/en...-0-0-conflicts

Hi John!

Thank you for updating us, I appreciate it.

That indeed fixes it - it's an incompatibility and we've had a few clients affected with the given package.

I'm glad it's all sorted now.


Should you need anything else you'll always be welcome to! :-)


Have an excellent day!