Percona XtraDB Cluster - HA scalable solution for MySQL

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

Reported by Raghavendra D Prabhu on 2012-09-13
96
This bug affects 15 people
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Undecided
Ignacio Nin
5.5
High
Alexey Bychko
5.6
High
Alexey Bychko
Percona Toolkit
High
Ignacio Nin
Percona XtraDB Cluster
High
Unassigned

Bug Description

> 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.

Related branches

lp:~abychko/percona-server/bug1050654
Merged into lp:percona-server/5.5 at revision 506
Ignacio Nin (community): Needs Information on 2013-03-26
Alexey Kopytov: Approve on 2013-03-07

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

Changed in percona-xtradb-cluster:
status: New → Confirmed
Robin Bowes (robinbowes) wrote :

I reported this over 19 months ago in lp:722404

summary: - Installation of perl-DBD-MySQL fails on Fedora 17
+ Add libmysqlclient.so.18(libmysqlclient_18) and
+ libmysqlclient.so.18(libmysqlclient_18) to Percona-Server
summary: - Add libmysqlclient.so.18(libmysqlclient_18) and
+ Add libmysqlclient.so.18(libmysqlclient_16) and
libmysqlclient.so.18(libmysqlclient_18) to Percona-Server
summary: Add libmysqlclient.so.18(libmysqlclient_16) and
- libmysqlclient.so.18(libmysqlclient_18) to Percona-Server
+ libmysqlclient.so.18(libmysqlclient_18) to Provides of Percona-Server-
+ shared-55 and Percona-XtraDB-Cluster-shared
Brian Fraser (fraserbn) wrote :
Changed in percona-toolkit:
status: New → Confirmed
assignee: nobody → Ignacio Nin (ignacio-nin)
Brian Fraser (fraserbn) on 2012-11-13
Changed in percona-toolkit:
milestone: none → 2.1.7
Changed in percona-toolkit:
milestone: 2.1.7 → 2.1.8
Changed in percona-toolkit:
importance: Undecided → High

@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.

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

Changed in percona-toolkit:
milestone: 2.1.8 → 2.2.1

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

Frederic Descamps (lefred) wrote :

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) wrote :

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
---

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

Changed in percona-xtradb-cluster:
importance: Undecided → High
Changed in percona-toolkit:
status: Confirmed → In Progress
Jaime Sicam (jssicam) on 2013-02-02
tags: added: i29120
Ovais Tariq (ovais-tariq) wrote :

Hi,

Any chance the fix would make it to 5.5.29-30.0

tags: added: i29396
tags: added: i29445
Ovais Tariq (ovais-tariq) wrote :

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

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

Changed in percona-toolkit:
status: In Progress → Fix Committed
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Changed in percona-xtradb-cluster:
status: Confirmed → Triaged
Changed in percona-xtradb-cluster:
status: Triaged → Fix Released
Changed in percona-xtradb-cluster:
status: Fix Released → Triaged
Changed in percona-xtradb-cluster:
milestone: none → 5.5.31-24.8
Ignacio Nin (ignacio-nin) wrote :

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.

Changed in percona-xtradb-cluster:
status: Triaged → Fix Released
mente (crahobzy) wrote :

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.

Please post a new bug. Thanks!

David Busby (d-busby) wrote :

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

---

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers