Percona Server with XtraDB

libmysqlclient18 chosen from the distro repo instead of percona's (Ubuntu Precise)

Reported by Quenten Grasso on 2013-04-29
82
This bug affects 23 people
Affects Status Importance Assigned to Milestone
Percona Server
Status tracked in 5.6
5.1
Critical
Ignacio Nin
5.5
Critical
Ignacio Nin
5.6
Critical
Ignacio Nin
Percona XtraDB Cluster
Undecided
Ignacio Nin

Bug Description

 aptitude install percona-xtradb-cluster-common-5.5 percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5 percona-xtrabackup rsync xinetd -y -f

The following NEW packages will be installed:
  libaio1{a} libdbi-perl{a} libmysqlclient18{a} libnet-daemon-perl{a} libplrpc-perl{a} mysql-common{a} percona-xtrabackup
  percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-galera-2.x{a} percona-xtradb-cluster-server-5.5
0 packages upgraded, 10 newly installed, 0 to remove and 0 not upgraded.
Need to get 37.4 MB of archives. After unpacking 124 MB will be used.
The following packages have unmet dependencies:
 percona-xtradb-cluster-common-5.5 : Conflicts: mysql-common but 5.5.31-0ubuntu0.12.04.1 is to be installed.
                                     Conflicts: mysql-common:i386 which is a virtual package.
                                     Conflicts: mysql-common-4.1 which is a virtual package.
                                     Conflicts: mysql-common-4.1:i386 which is a virtual package.
The following actions will resolve these dependencies:

     Keep the following packages at their current version:
1) libmysqlclient18 [Not Installed]
2) mysql-common [Not Installed]
3) percona-xtrabackup [Not Installed]
4) percona-xtradb-cluster-client-5.5 [Not Installed]
5) percona-xtradb-cluster-server-5.5 [Not Installed]

No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

This only started recently after a clean installation of ubuntu and latest updates i think ubuntu.

Quenten Grasso (qgrasso-d) wrote :
Download full text (3.3 KiB)

So if we try the install percona without percona-xtradb-cluster-common-5.5 package, we get

---------------------------
aptitude install percona-xtradb-cluster-client-5.5 percona-xtradb-cluster-server-5.5 percona-xtrabackup rsync xinetd -y

The following NEW packages will be installed:
  libaio1{a} libdbi-perl{a} libmysqlclient18{a} libnet-daemon-perl{a} libplrpc-perl{a} mysql-common{a} percona-xtrabackup percona-xtradb-cluster-client-5.5
  percona-xtradb-cluster-common-5.5{ab} percona-xtradb-cluster-galera-2.x{a} percona-xtradb-cluster-server-5.5
0 packages upgraded, 11 newly installed, 0 to remove and 0 not upgraded.
Need to get 37.4 MB of archives. After unpacking 124 MB will be used.
The following packages have unmet dependencies:
 percona-xtradb-cluster-common-5.5 : Conflicts: mysql-common but 5.5.31-0ubuntu0.12.04.1 is to be installed.
                                     Conflicts: mysql-common:i386 which is a virtual package.
                                     Conflicts: mysql-common-4.1 which is a virtual package.
                                     Conflicts: mysql-common-4.1:i386 which is a virtual package.
The following actions will resolve these dependencies:

     Keep the following packages at their current version:
1) libmysqlclient18 [Not Installed]
2) mysql-common [Not Installed]
3) percona-xtrabackup [Not Installed]
4) percona-xtradb-cluster-client-5.5 [Not Installed]
5) percona-xtradb-cluster-server-5.5 [Not Installed]

No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.

---------------------------

aptitude versions libmysqlclient18
Package libmysqlclient18:
p 5.5.22-0ubuntu1 precise 500
p 5.5.30-rel30.2-500.precise <NULL> 500
p 5.5.31-0ubuntu0.12.04.1 precise-security,precise-updates 500

Package libmysqlclient18-dev:
p 5.5.30-rel30.2-500.precise <NULL> 500

Package libmysqlclient18-dev:i386:
p 5.5.30-rel30.2-500.precise <NULL> 500

Package libmysqlclient18:i386:
p 5.5.22-0ubuntu1 precise 500
p 5.5.30-rel30.2-500.precise <NULL> 500
p 5.5.31-0ubuntu0.12.04.1 ...

Read more...

Quenten Grasso (qgrasso-d) wrote :
Download full text (4.0 KiB)

 apt-cache show libmysqlclient18

Package: libmysqlclient18
Priority: optional
Section: libs
Installed-Size: 3453
Maintainer: Ubuntu Developers <email address hidden>
Original-Maintainer: Debian MySQL Maintainers <email address hidden>
Architecture: amd64
Source: mysql-5.5
Version: 5.5.31-0ubuntu0.12.04.1
Depends: mysql-common (>= 5.5.31-0ubuntu0.12.04.1), libc6 (>= 2.14), zlib1g (>= 1:1.1.4)
Pre-Depends: multiarch-support
Filename: pool/main/m/mysql-5.5/libmysqlclient18_5.5.31-0ubuntu0.12.04.1_amd64.deb
Size: 948190
MD5sum: 7f2fbab0fc0821d7c31b8407624b69d0
SHA1: 81d1b64b30c8afcf306a6bd8244a44f96b46007b
SHA256: b5f37214cd40f0e38608cbed9b6e57f3566cc96d8431b0a9db4b024aea4563af
Description-en: MySQL database client library
 MySQL is a fast, stable and true multi-user, multi-threaded SQL database
 server. SQL (Structured Query Language) is the most popular database query
 language in the world. The main goals of MySQL are speed, robustness and
 ease of use.
 .
 This package includes the client library.
Multi-Arch: same
Homepage: http://dev.mysql.com/
Description-md5: 49de807663510f5f2afd3e71efe199f1
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Origin: Ubuntu
Supported: 5y
Task: lamp-server, kubuntu-desktop, kubuntu-active-desktop, kubuntu-active, edubuntu-desktop-kde, edubuntu-desktop-gnome, mythbuntu-frontend, mythbuntu-frontend, mythbuntu-desktop, mythbuntu-backend-slave, mythbuntu-backend-slave, mythbuntu-backend-master, mythbuntu-backend-master, ubuntustudio-generation, ubuntustudio-video, ubuntustudio-audio-plugins, ubuntustudio-recording

Package: libmysqlclient18
Source: percona-server-5.5
Version: 5.5.30-rel30.2-500.precise
Architecture: amd64
Maintainer: Percona Server Development Team <email address hidden>
Installed-Size: 3103
Depends: dpkg (>= 1.15.4) | install-info
Replaces: libpercona-server-client18
Homepage: http://www.percona.com/software/percona-server/
Priority: extra
Section: libs
Filename: pool/main/p/percona-server-5.5/libmysqlclient18_5.5.30-rel30.2-500.precise_amd64.deb
Size: 836288
SHA256: 401c40581c8052bfa73b6e6bd39cba622ba65dd22b718019a2e6df14cbd73e31
SHA1: e1c93c8fc3e78803ef64819046ae5fcc23bb864c
MD5sum: 6276ad3e00984061bdd970ed41620e4f
Description: Percona Server database client library
 Percona Server is a fast, stable and true multi-user,
 multi-threaded SQL database server. SQL (Structured Query Language)
 is the most popular database query language in the world. The main
 goals of Percona Server are speed, robustness and ease of use.
 .
 This package includes the client library.

Package: libmysqlclient18
Priority: optional
Section: libs
Installed-Size: 3449
Maintainer: Ubuntu Developers <email address hidden>
Original-Maintainer: Debian MySQL Maintainers <email address hidden>
Architecture: amd64
Source: mysql-5.5
Version: 5.5.22-0ubuntu1
Depends: mysql-common (>= 5.5.22-0ubuntu1), libc6 (>= 2.14), zlib1g (>= 1:1.1.4)
Pre-Depends: multiarch-support
Filename: pool/main/m/mysql-5.5/libmysqlclient18_5.5.22-0ubuntu1_amd64.deb
Size: 945874
MD5sum: e3cc9fb2bd07e81cb5005d267a648467
SHA1: fd4ba41b7ba35a18d90034dafb2a93d5c90fc2ff
SHA256: 6f4c0211...

Read more...

Quenten Grasso (qgrasso-d) wrote :

so if i'm reading this correctly, maybe the issue is the percona package from the repo is older then the latest ubuntu package?

==== ubuntu package =====

Package: libmysqlclient18
Priority: optional
Section: libs
Installed-Size: 3453
Maintainer: Ubuntu Developers <email address hidden>
Original-Maintainer: Debian MySQL Maintainers <email address hidden>
Architecture: amd64
Source: mysql-5.5
Version: 5.5.31-0ubuntu0.12.04.1
Depends: mysql-common (>= 5.5.31-0ubuntu0.12.04.1), libc6 (>= 2.14), zlib1g (>= 1:1.1.4)

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

===== Percona Package ======

Package: libmysqlclient18
Source: percona-server-5.5
Version: 5.5.30-rel30.2-500.precise
Architecture: amd64
Maintainer: Percona Server Development Team <email address hidden>
Installed-Size: 3103
Depends: dpkg (>= 1.15.4) | install-info
Replaces: libpercona-server-client18
Homepage: http://www.percona.com/software/percona-server/
Priority: extra
Section: libs
Filename: pool/main/p/percona-server-5.5/libmysqlclient18_5.5.30-rel30.2-500.precise_amd64.deb

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

However clearly i'm not sure just trying to point out a few ideas..
Thanks,

Quenten Grasso (qgrasso-d) wrote :

I just had a brain storm to prove my issue i ended up adding this to

*** Can be used as a work around until its resolved with the Percona Repo ***

/etc/apt/preferences,

Package: *
Pin: origin repo.percona.com
Pin-Priority: 610

Which pins the Pecona Repo sources for packages which a relevant to this issue, and did a apt-get update and tried reinstalling the packages successfully.

Or if your lazy like me try pasting this

cat >> /etc/apt/preferences <<EOF
Package: *
Pin: origin repo.percona.com
Pin-Priority: 610
EOF

Enjoy

jason tevnan (jason-tevnan) wrote :

So the timeline is complete:
A few people (myself included) posted on an old closed issue regarding this problem: https://bugs.launchpad.net/percona-server/+bug/1103655

Changed in percona-server:
status: New → Confirmed
importance: Undecided → Critical
assignee: nobody → Ignacio Nin (ignacio-nin)
milestone: none → 5.5.31-30.3
Ignacio Nin (ignacio-nin) wrote :

This bug is confirmed for quantal and precise platforms. The source of the problem, as it has been explained in some of the comments, is that the official repo's libmysqlclient18 is being chosen over our version. The official repo Depends: on mysql-common, which installs a my.cnf that we with to avoid.

We will solve this by upgrading the epoch: in our packages for that versions, which will cause our versions to be chosen. This will have the same effect as pinning our repo.

Thanks for your reports!

Changed in percona-server:
status: Confirmed → In Progress
Changed in percona-xtradb-cluster:
status: New → Invalid
assignee: nobody → Ignacio Nin (ignacio-nin)
summary: - Ubuntu Precise, percona-xtradb-cluster-common-5.5
+ libmysqlclient18 chosen from the distro repo instead of percona's
+ (Ubuntu Precise)
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers