percona-release repo conflict with CentOS 7 mariadb installation

[Shahriyar Rzayev]

After installation of percona-release-0.1-3.noarch for installing xtrabackup, if you try to install MariaDB:

[root@centos-base ~]# yum localinstall percona-release-0.1-3.noarch.rpm

[root@centos-base ~]# yum install mariadb-server
Loaded plugins: auto-update-debuginfo, fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bakinter.net
 * epel: epel.mirror.srv.co.ge
 * epel-debuginfo: epel.mirror.srv.co.ge
 * extras: mirror.bakinter.net
 * updates: mirror.bakinter.net
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.44-1.el7_1 will be installed
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-server-5.5.44-1.el7_1.x86_64
--> Processing Dependency: mariadb(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-server-5.5.44-1.el7_1.x86_64
--> Running transaction check
---> Package Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.24-25.11.1.el7 will be obsoleting
---> Package mariadb.x86_64 1:5.5.44-1.el7_1 will be installed
---> Package mariadb-libs.x86_64 1:5.5.41-2.el7_0 will be updated
---> Package mariadb-libs.x86_64 1:5.5.41-2.el7_0 will be obsoleted
---> Package mariadb-libs.x86_64 1:5.5.44-1.el7_1 will be an update
Removing mariadb-libs.x86_64 1:5.5.44-1.el7_1 - u due to obsoletes from Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.24-25.11.1.el7 - u
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.44-1.el7_1 will be an update
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-server-5.5.44-1.el7_1.x86_64
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-5.5.44-1.el7_1.x86_64
--> Finished Dependency Resolution
Error: Package: 1:mariadb-server-5.5.44-1.el7_1.x86_64 (updates)
           Requires: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Removing: 1:mariadb-libs-5.5.41-2.el7_0.x86_64 (@base)
               mariadb-libs(x86-64) = 1:5.5.41-2.el7_0
           Obsoleted By: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 (percona-release-x86_64)
               Not found
           Updated By: 1:mariadb-libs-5.5.44-1.el7_1.x86_64 (updates)
               mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
Error: Package: 1:mariadb-5.5.44-1.el7_1.x86_64 (updates)
           Requires: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Removing: 1:mariadb-libs-5.5.41-2.el7_0.x86_64 (@base)
               mariadb-libs(x86-64) = 1:5.5.41-2.el7_0
           Obsoleted By: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 (percona-release-x86_64)
               Not found
           Updated By: 1:mariadb-libs-5.5.44-1.el7_1.x86_64 (updates)
               mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

After removing percona repo , will be able to install MariaDB.

[Shahriyar Rzayev (rzayev-sehriyar)]

Also there is a problem with update:

[root@centos-base ~]# yum update
Loaded plugins: auto-update-debuginfo, fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.bakinter.net
 * epel: epel.mirror.srv.co.ge
 * epel-debuginfo: epel.mirror.srv.co.ge
 * extras: mirror.bakinter.net
 * updates: mirror.bakinter.net
Resolving Dependencies
--> Running transaction check
---> Package Percona-Server-shared-55.x86_64 0:5.5.44-rel37.3.el7 will be obsoleting
---> Package Percona-Server-shared-56.x86_64 0:5.6.25-rel73.1.el7 will be obsoleting
---> Package Percona-XtraDB-Cluster-shared-55.x86_64 1:5.5.41-25.11.853.el7 will be obsoleting
---> Package Percona-XtraDB-Cluster-shared-56.x86_64 1:5.6.24-25.11.1.el7 will be obsoleting
---> Package mariadb-libs.x86_64 1:5.5.44-1.el7_1 will be obsoleted
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-5.5.44-1.el7_1.x86_64
--> Processing Dependency: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1 for package: 1:mariadb-server-5.5.44-1.el7_1.x86_64
--> Processing Conflict: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 conflicts Percona-Server-shared-56
--> Processing Conflict: Percona-Server-shared-56-5.6.25-rel73.1.el7.x86_64 conflicts Percona-Server-shared-55
--> Processing Conflict: 1:Percona-XtraDB-Cluster-shared-55-5.5.41-25.11.853.el7.x86_64 conflicts Percona-XtraDB-Cluster-shared-56
--> Processing Conflict: 1:Percona-XtraDB-Cluster-shared-55-5.5.41-25.11.853.el7.x86_64 conflicts Percona-Server-shared-55
--> Processing Conflict: Percona-Server-shared-55-5.5.44-rel37.3.el7.x86_64 conflicts Percona-Server-shared-56
--> Finished Dependency Resolution
Error: Percona-Server-shared-55 conflicts with Percona-Server-shared-56-5.6.25-rel73.1.el7.x86_64
Error: Percona-XtraDB-Cluster-shared-55 conflicts with 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64
Error: Package: 1:mariadb-5.5.44-1.el7_1.x86_64 (@updates)
           Requires: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Removing: 1:mariadb-libs-5.5.44-1.el7_1.x86_64 (@updates)
               mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Obsoleted By: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 (percona-release-x86_64)
               Not found
           Available: 1:mariadb-libs-5.5.41-2.el7_0.x86_64 (base)
               mariadb-libs(x86-64) = 1:5.5.41-2.el7_0
Error: Percona-XtraDB-Cluster-shared-56 conflicts with Percona-Server-shared-56-5.6.25-rel73.1.el7.x86_64
Error: Percona-XtraDB-Cluster-shared-55 conflicts with Percona-Server-shared-55-5.5.44-rel37.3.el7.x86_64
Error: Percona-Server-shared-56 conflicts with Percona-Server-shared-55-5.5.44-rel37.3.el7.x86_64
Error: Package: 1:mariadb-server-5.5.44-1.el7_1.x86_64 (@updates)
           Requires: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Removing: 1:mariadb-libs-5.5.44-1.el7_1.x86_64 (@updates)
               mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Obsoleted By: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 (percona-release-x86_64)
               Not found
           Available: 1:mariadb-libs-5.5.41-2.el7_0.x86_64 (base)
               mariadb-libs(x86-64) = 1:5.5.41-2....

[Aurimas (aurimas)]

same here:

Error: Package: 1:mariadb-devel-5.5.44-1.el7_1.x86_64 (updates)
           Requires: mariadb-libs(x86-64) = 1:5.5.44-1.el7_1
           Removing: 1:mariadb-libs-5.5.41-2.el7_0.x86_64 (@anaconda)
               mariadb-libs(x86-64) = 1:5.5.41-2.el7_0
           Obsoleted By: 1:Percona-XtraDB-Cluster-shared-56-5.6.24-25.11.1.el7.x86_64 (percona-release-x86_64)
               Not found
           Updated By: 1:mariadb-libs-5.5.44-1.el7_1.x86_64 (updates)
               mariadb-libs(x86-64) = 1:5.5.44-1.el7_1

resolved with:

yum erase mariadb-devel

[Tomislav Plavcic (tplavcic)]

@Aurimas: your issue is different and will be resolved when we add that our "-devel" package Obsoletes the one from mariadb.
That is installation of PS/PXC 5.5/5.6 should then work even if you have mariadb-devel package installed.

The issue that @Shahriyar has is because our package obsoletes mariadb-libs and we have only one repository so he can't install mariadb server and have our repository for something else like PXB.
It will be resolved when we introduce multiple repositories (like one for tools, one for PS 5.5, one for PS 5.6 and so on - like Oracle has it, and I think MariaDB also has separated repositories).
So the used will have to enable the repository for the product that he actually wants to use.
We might consider removing that "Obsolete" clause and leave mariadb-libs installed but it has my.cnf with some mariadb directories inside which doesn't look ok for us.

[Jervin R (revin)]

This is still happening for PXC 5.7 packages conflicting with mariadb-libs.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1026

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-924