Bug #119743 Removing mysql-community-server causes issues
Submitted: 22 Jan 9:16 Modified: 22 Jan 9:20
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Packaging Severity:S2 (Serious)
Version:8.4.8,9.6.0 OS:Fedora (43)
Assigned to: CPU Architecture:x86

[22 Jan 9:16] Daniël van Eeden
Description:
As mysql-community-server is set to replace mariadb-connector-c-config and mysql-connector-c depends on that and is critical to many different other packages it is difficult to remove mysql-community-server on Fedora 43 once it is installed.

-------------------------------------
# dnf repoquery --whatprovides=/etc/my.cnf
Updating and loading repositories:
Repositories loaded.
mariadb-connector-c-config-0:3.4.5-2.fc43.noarch
mariadb-connector-c-config-0:3.4.8-1.fc43.noarch
mysql-community-server-0:8.4.8-10.fc43.x86_64
-------------------------------------

-------------------------------------
# rpm -q --obsoletes mysql-community-server | grep mariadb-connector-c
mariadb-connector-c-config
-------------------------------------

-------------------------------------
# dnf repoquery --obsoletes mysql-community-server | grep mariadb-connector-c-config
Updating and loading repositories:
Repositories loaded.
mariadb-connector-c-config
-------------------------------------

How to repeat:
- Run a Fedora 43 container:
-------------------------------------
podman run --rm -it fedora:43
-------------------------------------

- Install some packages from Fedora like lldpd, libreoffice-calc, sysbench
- Setup the MySQL YUM Repo
- Optional: Enable mysql-innovation-community repo
- Install mysql-community-server
-------------------------------------
dnf install -y lldpd
rpm -i https://dev.mysql.com/get/mysql84-community-release-fc43-1.noarch.rpm
dnf install -y mysql-community-server
-------------------------------------

Try to remove mysql-community-server again with DNF (answer NO)
-------------------------------------
[root@eaf83736bfc3 /]# dnf remove mysql-community-server 
Package                                                              Arch            Version                                                               Repository                                     Size
Removing:
 mysql-community-server                                              x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                   102.0 MiB
Removing dependent packages:
 lldpd                                                               x86_64          1.0.18-4.fc43                                                         fedora                                    486.4 KiB
Removing unused dependencies:
 groff-base                                                          x86_64          1.23.0-11.fc43                                                        updates                                     3.8 MiB
 libaio                                                              x86_64          0.3.111-22.fc43                                                       fedora                                     48.6 KiB
 lm_sensors-libs                                                     x86_64          3.6.0-23.fc43                                                         fedora                                     85.8 KiB
 mariadb-connector-c                                                 x86_64          3.4.8-1.fc43                                                          updates                                   516.2 KiB
 mecab                                                               x86_64          0.996-10.fc43                                                         fedora                                      1.2 MiB
 mecab-ipadic                                                        x86_64          2.7.0.20070801-33.fc43                                                fedora                                     50.6 MiB
 mecab-ipadic-EUCJP                                                  x86_64          2.7.0.20070801-33.fc43                                                fedora                                     39.7 MiB
 mysql-community-client                                              x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                    63.1 MiB
 mysql-community-client-plugins                                      x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                    13.0 MiB
 mysql-community-common                                              x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                    10.9 MiB
 mysql-community-icu-data-files                                      x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                     4.3 MiB
 mysql-community-libs                                                x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                     7.2 MiB
 ncurses                                                             x86_64          6.5-7.20250614.fc43                                                   fedora                                    609.8 KiB
-------------------------------------

Try to remove mysql-community-server again with RPM
-------------------------------------
[root@eaf83736bfc3 /]# rpm -e mysql-community-server 
error: Failed dependencies:
	/etc/my.cnf is needed by (installed) mariadb-connector-c-3.4.8-1.fc43.x86_64
-------------------------------------

You can force it, but then on the next `dnf upgrade` it will still try to install mysql-community-server
-------------------------------------
[root@eaf83736bfc3 /]# rpm --nodeps -e mysql-community-server 
Removed '/etc/systemd/system/multi-user.target.wants/mysqld.service'.
[root@eaf83736bfc3 /]# dnf check
mariadb-connector-c-0:3.4.8-1.fc43.x86_64
 missing require "/etc/my.cnf"
Check discovered 1 problem(s) in 1 package(s)
[root@eaf83736bfc3 /]# dnf install mariadb-connector-c-config
Updating and loading repositories:
Repositories loaded.
Package                                                              Arch            Version                                                               Repository                                     Size
Installing:
 mysql-community-server                                              x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                   102.0 MiB

Transaction Summary:
 Installing:         1 package

Total size of inbound packages is 21 MiB. Need to download 21 MiB.
After this operation, 102 MiB extra will be used (install 102 MiB, remove 0 B).
Is this ok [y/N]: N
Operation aborted by the user.
[root@eaf83736bfc3 /]# dnf install mariadb-connector-c-config-0:3.4.8-1.fc43
Updating and loading repositories:
Repositories loaded.
Package                                                               Arch            Version                                                                Repository                                   Size
Installing:
 mariadb-connector-c-config                                           noarch          3.4.8-1.fc43                                                           updates                                 497.0   B

Transaction Summary:
 Installing:         1 package

Total size of inbound packages is 9 KiB. Need to download 9 KiB.
After this operation, 497 B extra will be used (install 497 B, remove 0 B).
Is this ok [y/N]: y
[1/1] mariadb-connector-c-config-0:3.4.8-1.fc43.noarch                                                                                                                100% |  91.4 KiB/s |   9.0 KiB |  00m00s
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[1/1] Total                                                                                                                                                           100% |  54.8 KiB/s |   9.0 KiB |  00m00s
Running transaction
[1/3] Verify package files                                                                                                                                            100% |   0.0   B/s |   1.0   B |  00m00s
[2/3] Prepare transaction                                                                                                                                             100% |  90.0   B/s |   1.0   B |  00m00s
[3/3] Installing mariadb-connector-c-config-0:3.4.8-1.fc43.noarch                                                                                                     100% |  52.0 KiB/s |   1.0 KiB |  00m00s
Complete!
[root@eaf83736bfc3 /]# dnf check
[root@eaf83736bfc3 /]# dnf upgrade
Updating and loading repositories:
Repositories loaded.
Package                                                              Arch            Version                                                               Repository                                     Size
Installing:
 mysql-community-server                                              x86_64          8.4.8-10.fc43                                                         mysql-8.4-lts-community                   102.0 MiB
   replacing mariadb-connector-c-config                              noarch          3.4.8-1.fc43                                                          updates                                   497.0   B

Transaction Summary:
 Installing:         1 package
 Replacing:          1 package

Total size of inbound packages is 21 MiB. Need to download 21 MiB.
After this operation, 102 MiB extra will be used (install 102 MiB, remove 497 B).
Is this ok [y/N]: N
Operation aborted by the user.
[root@eaf83736bfc3 /]# 
-------------------------------------
[22 Jan 9:20] Daniël van Eeden
This also causes mysql-community-server to be installed in cases where this isn't appropriate.

Again a Fedora 43 container
---------------------------------------------
podman run --rm -it fedora:43
---------------------------------------------

Now install the MySQL YUM Repo and also install lldpd
---------------------------------------------
dnf install -y lldpd
rpm -i https://dev.mysql.com/get/mysql84-community-release-fc43-1.noarch.rpm
dnf makecache
dnf install -y lldpd
---------------------------------------------

This is the result
---------------------------------------------
# rpm -qa | grep -E '^mysql'
mysql84-community-release-fc43-1.noarch
mysql-community-common-8.4.8-10.fc43.x86_64
mysql-community-client-plugins-8.4.8-10.fc43.x86_64
mysql-community-libs-8.4.8-10.fc43.x86_64
mysql-community-client-8.4.8-10.fc43.x86_64
mysql-community-icu-data-files-8.4.8-10.fc43.x86_64
mysql-community-server-8.4.8-10.fc43.x86_64
---------------------------------------------

Suggested fix: Move `/etc/my.cnf` to mysql-community-common (After all, both client and server read this file..)