Add libmysqlclient.so.18(libmysqlclient_16) and libmysqlclient.so.18(libmysqlclient_18) to Provides of Percona-Server-shared-55 and Percona-XtraDB-Cluster-shared

[Raghavendra D Prabhu]

> yum install percona-toolkit

Loaded plugins: changelog, fastestmirror, langpacks, presto, refresh-packagekit, security, yum-fast-downloader
Loading mirror speeds from cached hostfile
 * fedora: fedora.iitm.ac.in
 * livna: rpm.livna.org
 * rpmfusion-free: mirror.bjtu.edu.cn
 * rpmfusion-free-updates: mirror.bjtu.edu.cn
 * rpmfusion-nonfree: mirror.bjtu.edu.cn
 * rpmfusion-nonfree-updates: mirror.bjtu.edu.cn
 * updates: fedora.iitm.ac.in
Resolving Dependencies
--> Running transaction check
---> Package percona-toolkit.noarch 0:2.1.3-2 will be installed
--> Processing Dependency: perl(DBD::mysql) >= 1.0 for package: percona-toolkit-2.1.3-2.noarch
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:4.020-2.fc17 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: perl-DBD-MySQL-4.020-2.fc17.x86_64
Package mysql-libs is obsoleted by Percona-Server-shared-51, but obsoleting package does not provide for requirements
--> Finished Dependency Resolution
Error: Package: perl-DBD-MySQL-4.020-2.fc17.x86_64 (fedora)
           Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Available: mysql-libs-5.5.23-1.fc17.x86_64 (fedora)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Available: mysql-libs-5.5.27-1.fc17.x86_64 (updates)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest

======================

This is because:

rpm -q --provides Percona-Server-shared-55-5.5.27-rel28.1.296.rhel6.x86_64

libmysqlclient.so.18()(64bit)
libtool(/usr/lib64/mysql/plugin/libfnv1a_udf.la)
libtool(/usr/lib64/mysql/plugin/libfnv_udf.la)
libtool(/usr/lib64/mysql/plugin/libmurmur_udf.la)
mysql-shared
Percona-Server-shared-55 = 5.5.27-rel28.1.296.rhel6
Percona-Server-shared-55(x86-64) = 5.5.27-rel28.1.296.rhel6

So, Percona-Server-shared doesn't provide libmysqlclient.so.18(libmysqlclient_16)(64bit) which is why the build fails.

In contrast, mysql-libs (the upstream counterpart) provides following:

    config(mysql-libs) = 5.5.27-1.fc17
    libmysqlclient.so.18
    libmysqlclient.so.18(libmysqlclient_16)
    libmysqlclient.so.18(libmysqlclient_18)
    mysql-libs = 5.5.27-1.fc17
    mysql-libs(x86-32) = 5.5.27-1.fc17

from http://pkgs.org/fedora-17/fedora-updates-i386/mysql-libs-5.5.27-1.fc17.i686.rpm.html#provides

1. So, we need to update the spec file for Percona-Server-shared with

    libmysqlclient.so.18(libmysqlclient_16)
    libmysqlclient.so.18(libmysqlclient_18)

2. Alternatively, we can also put mysql-libs in provides. There is no mysql-shared. This also causes problems elsewhere.

Note, that this problem will arise in CentOS too once perl-DBD-MySQL is updated in its repos.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Affects Percona-XtraDB-Cluster-shared as well since it has similar provides. (from lp:1045763)

[Robin Bowes (robinbowes)]

I reported this over 19 months ago in lp:722404

[Brian Fraser (fraserbn)]

Is this a duplicate of https://bugs.launchpad.net/percona-toolkit/+bug/1031427 ?

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Brian,

It is not a duplicate.

This bug deals with requirements of the newer perl-DBD-MySQL --
libmysqlclient.so.18(libmysqlclient_16) and
libmysqlclient.so.18(libmysqlclient_18) --
library present in Fedora.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Just to add to previous comment, this bug does affect percona-toolkit if one tries to install it on Fedora (or any platforms where perl-DBD-MySQL.x86_64 4.020 or newer is used. But the issue is independent from lp:1031427

[Raghavendra D Prabhu (raghavendra-prabhu)]

I also tested the upstream (MySQL) shared library and seems it
just has libmysqlclient.so.18(), so it should fail too.

[Frederic Descamps (lefred)]

It will be indeed nice to have such lib in the package we provide. It will allow us to use some Percona tools on Fedora too (on desktop for some tests):

libmysqlclient.so.18(libmysqlclient_16)(64bit)

[David Busby (d-busby)]

Note this also affects other tools such as sysbench:
---
rpm -q Percona-Server-shared-compat --provides ✭master
MySQL-shared
libmysqlclient.so.12()(64bit)
libmysqlclient.so.14()(64bit)
libmysqlclient.so.14(libmysqlclient_14)(64bit)
libmysqlclient.so.15()(64bit)
libmysqlclient.so.15(libmysqlclient_15)(64bit)
libmysqlclient.so.16()(64bit)
libmysqlclient.so.16(libmysqlclient_16)(64bit)
libmysqlclient_r.so.12()(64bit)
libmysqlclient_r.so.14()(64bit)
libmysqlclient_r.so.14(libmysqlclient_14)(64bit)
libmysqlclient_r.so.15()(64bit)
libmysqlclient_r.so.15(libmysqlclient_15)(64bit)
libmysqlclient_r.so.16()(64bit)
libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
mysql-libs
Percona-Server-shared-compat = 5.5.29-rel29.4.401.rhel6
Percona-Server-shared-compat(x86-64) = 5.5.29-rel29.4.401.rhel6
---

---
yum install sysbench ✭master
Loaded plugins: langpacks, presto, refresh-packagekit
Resolving Dependencies
--> Running transaction check
---> Package sysbench.x86_64 0:0.4.12-6.fc17 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: sysbench-0.4.12-6.fc17.x86_64
Package mysql-libs-5.5.29-1.fc17.x86_64 is obsoleted by Percona-Server-shared-compat-5.5.29-rel29.4.401.rhel6.x86_64 which is already installed
--> Processing Dependency: libpq.so.5()(64bit) for package: sysbench-0.4.12-6.fc17.x86_64
--> Running transaction check
---> Package postgresql-libs.x86_64 0:9.1.7-1.fc17 will be installed
---> Package sysbench.x86_64 0:0.4.12-6.fc17 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: sysbench-0.4.12-6.fc17.x86_64
Package mysql-libs-5.5.29-1.fc17.x86_64 is obsoleted by Percona-Server-shared-compat-5.5.29-rel29.4.401.rhel6.x86_64 which is already installed
--> Finished Dependency Resolution
Error: Package: sysbench-0.4.12-6.fc17.x86_64 (fedora)
           Requires: libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Available: mysql-libs-5.5.23-1.fc17.x86_64 (fedora)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
           Available: mysql-libs-5.5.29-1.fc17.x86_64 (updates)
               libmysqlclient.so.18(libmysqlclient_16)(64bit)
 You could try using --skip-broken to work around the problem
---

[Raghavendra D Prabhu (raghavendra-prabhu)]

Yes, it looks like it not only affects Fedora but also CentOS (which we support in builds in contrast to Fedora).

[Ovais Tariq (ovais-tariq)]

Hi,

Any chance the fix would make it to 5.5.29-30.0

[Ovais Tariq (ovais-tariq)]

Just wanted to add here that the branch with the fix has been tested by two users for whom it has worked perfectly well.

[Daniel Nichter (daniel-nichter)]

Ignacio|56: Daniel: https://bugs.launchpad.net/percona-server/+bug/1050654 has been fixed as part of the fixes for Percona Server-

[Ignacio Nin (ignacio-nin)]

Hello,

As for PXC, this is no longer reproducible in either CentOS 5 or 6, possible due to related fixes in the other projects -- particularly the fix for bug lp:1031427.

Marking as Fix Released.

[mente (crahobzy)]

I'm not able to update from Percona 5.5.30 to 5.5.31. Not sure whether this bug is a appropriate place to post, but I can create a new one if it's not only my problem. My steps to reproduce:
$ yum --enablerepo=percona upgrade
....
--> Running transaction check
---> Package Percona-Server-client-55.x86_64 0:5.5.30-rel30.2.508.rhel6 will be updated
---> Package Percona-Server-client-55.x86_64 0:5.5.31-rel30.3.520.rhel6 will be an update
---> Package Percona-Server-server-55.x86_64 0:5.5.30-rel30.2.500.rhel6 will be updated
---> Package Percona-Server-server-55.x86_64 0:5.5.31-rel30.3.520.rhel6 will be an update
---> Package Percona-Server-shared-51.x86_64 0:5.1.68-rel14.6.551.rhel6 will be obsoleting
---> Package Percona-Server-shared-55.x86_64 0:5.5.28-rel29.1.335.rhel6 will be updated
---> Package Percona-Server-shared-55.x86_64 0:5.5.31-rel30.3.520.rhel6 will be obsoleting
---> Package Percona-Server-shared-compat.x86_64 0:5.5.31-rel30.3.520.rhel6 will be obsoleting
---> Package mysql-libs.x86_64 0:5.5.31-1.el6.remi will be obsoleted
---> Package percona-toolkit.noarch 0:2.1.8-1 will be updated
---> Package percona-toolkit.noarch 0:2.2.2-1 will be an update
---> Package percona-xtrabackup.x86_64 0:2.1.1-600.rhel6 will be updated
---> Package percona-xtrabackup.x86_64 0:2.1.3-608.rhel6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

...
Running Transaction Test

Transaction Check Error:
  file /usr/lib64/mysql/libmysqlclient.so.16.0.0 from install of Percona-Server-shared-51-5.1.68-rel14.6.551.rhel6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
  file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of Percona-Server-shared-51-5.1.68-rel14.6.551.rhel6.x86_64 conflicts with file from package compat-mysql51-5.1.54-1.el6.remi.x86_64
  file /usr/lib64/libmysqlclient.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-51-5.1.68-rel14.6.551.rhel6.x86_64 and Percona-Server-shared-compat-5.5.31-rel30.3.520.rhel6.x86_64
  file /usr/lib64/libmysqlclient_r.so.16.0.0 conflicts between attempted installs of Percona-Server-shared-51-5.1.68-rel14.6.551.rhel6.x86_64 and Percona-Server-shared-compat-5.5.31-rel30.3.520.rhel6.x86_64

Error Summary
-------------

Using CentOS 6.4. Conflicting package is from remi repository. https://bugs.launchpad.net/percona-server/+bug/1104522 could be related.

[Laurynas Biveinis (laurynas-biveinis)]

Please post a new bug. Thanks!

[David Busby (d-busby)]

update mariadb-libs now appearing as candidate on Fedora18

---
--> Running transaction check
---> Package MySQL-python.x86_64 0:1.2.3-6.fc18 will be installed
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: MySQL-python-1.2.3-6.fc18.x86_64
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: MySQL-python-1.2.3-6.fc18.x86_64
--> Running transaction check
---> Package mariadb-libs.x86_64 0:5.5.31-1.fc18 will be installed
--> Finished Dependency Resolution

...
 mariadb-libs-5.5.31-1.fc18.x86_64 conflicts with file from package Percona-Server-server-51-5.1.69-rel14.7.572.rhel6.x86_64
...

Percona-Server-shared-51-5.1.69-rel14.7.572.rhel6.x86_64
Percona-Server-client-51-5.1.69-rel14.7.572.rhel6.x86_64
Percona-Server-server-51-5.1.69-rel14.7.572.rhel6.x86_64

---

[Shahriyar Rzayev (rzayev-sehriyar)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

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