File /usr/lib64/mysql/libmysqlclient.so.18.0.0 from install of cl-MariaDB103-libs-10.3.39-3.el7.cloudlinux.x86_64 conflicts with file from package mysqlclient18-compat-10.1.28-1.el7.cloudlinux.x86_64

Issue

The following error appears During yum update:

file /usr/lib64/mysql/libmysqlclient.so.18.0.0 from install of cl-MariaDB103-libs-10.3.39-3.el7.cloudlinux.x86_64 conflicts with file from package mysqlclient18-compat-10.1.28-1.el7.cloudlinux.x86_64

Or:

# yum update
This system is receiving updates from CloudLinux Network server.
Last metadata expiration check: 3:27:27 ago on Sunday 15 October 2023 10:45:11 AM IST.
Error:
 Problem 1: package cl-MariaDB103-libs-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 conflicts with cl-MariaDB104-libs provided by cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64
  - both package cl-MariaDB-meta-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 and cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64 obsolete mysqlclient18-compat
  - cannot install the best update candidate for package cl-MariaDB103-libs-10.3.39-3.module_el8.8.0+6682+4c6417b1.cloudlinux.x86_64
  - cannot install the best update candidate for package cl-MariaDB-meta-10.3.39-3.module_el8.8.0+6682+4c6417b1.cloudlinux.x86_64
 Problem 2: cannot install the best update candidate for package mysqlclient18-compat-10.2.36-4.el8.cloudlinux.x86_64
  - both package cl-MariaDB-meta-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 and cl-MariaDB105-libs-10.5.22-2.module_el8.8.0+6705+3dc75a2b.cloudlinux.x86_64 obsolete mysqlclient18-compat
  - package cl-MariaDB103-libs-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 conflicts with cl-MariaDB102-libs provided by cl-MariaDB102-libs-10.2.44-4.module_el8.8.0+6691+52e44a78.cloudlinux.x86_64
  - package cl-MariaDB103-libs-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 conflicts with cl-MariaDB104-libs provided by cl-MariaDB104-libs-10.4.30-3.module_el8.8.0+6696+5b8667ab.cloudlinux.x86_64
  - package cl-MariaDB103-libs-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 conflicts with cl-MariaDB105-libs provided by cl-MariaDB105-libs-10.5.22-1.module_el8.8.0+6698+2084b712.cloudlinux.x86_64
  - package cl-MariaDB103-libs-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 conflicts with cl-MariaDB105-libs provided by cl-MariaDB105-libs-10.5.22-2.module_el8.8.0+6705+3dc75a2b.cloudlinux.x86_64
  - package cl-MariaDB103-10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux.x86_64 requires cl-MariaDB103-libs = 10.3.39-5.module_el8.8.0+6711+366791cd.cloudlinux, but none of the providers can be installed
  - cannot install the best update candidate for package cl-MariaDB103-10.3.39-3.module_el8.8.0+6682+4c6417b1.cloudlinux.x86_64
(try to add '--allowerasing' to command line to replace conflicting packages or '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)

Environment

• MySQL
• mysqlclient18-compat

Solution

1. Remove the mysqlclient18-compat, using:

   rpm -e --nodeps mysqlclient18-compat

   Or:

   # rpm -e --justdb --nodeps mysqlclient18-compat-10.1.28-1.el7.cloudlinux.x86_64

2. Re-run update 
   

   # yum update

Cause

Product issue was fixed in CLOS-1828