broken packages, Percona Server 5.5, Ubuntu 10.04

[Dane Miller]

I'm having trouble installing libdbd-mysql-perl after installing percona-server-client-5.5 on Ubuntu 10.04.  The issue seems to be the libmysqlclient16 package.

Everything works if I explicitly set the version of libmysqlclient16 to install from the *percona* repo.  However, if I don't specify a version for libmysqlclient16, apt-get freaks out.  This seems like a packaging error... or am I missing something?

Dane

# this works

apt-get install \

  percona-server-client-5.5 

  libmysqlclient16=5.1.68-rel14.6-551.lucid \

  libdbd-mysql-perl

# this breaks

apt-get install percona-server-client-5.5 libdbd-mysql-perl

Reading package lists... Done

Building dependency tree       

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

  libdbd-mysql-perl: Depends: libmysqlclient16 (>= 5.1.21-1) but it is not going to be installed

E: Broken packages

System Info:

Ubuntu 10.04.4 x86_64

apt sources:

deb http://repo.percona.com/apt lucid main

deb http://us.archive.ubuntu.com/ubuntu/ lucid main universe

deb http://us.archive.ubuntu.com/ubuntu/ lucid-updates main universe

deb http://security.ubuntu.com/ubuntu lucid-security main universe

deb http://us.archive.ubuntu.com/ubuntu/ lucid multiverse

deb http://us.archive.ubuntu.com/ubuntu/ lucid-updates multiverse

[Alexey Kopytov]

Hi Dane,

On Tue, 30 Apr 2013 15:36:07 -0700 (PDT), Dane Miller wrote:
> I'm having trouble installing libdbd-mysql-perl after installing
> percona-server-client-5.5 on Ubuntu 10.04. The issue seems to be the
> libmysqlclient16 package.
>
> Everything works if I explicitly set the version of libmysqlclient16 to
> install from the *percona* repo. However, if I don't specify a version
> for libmysqlclient16, apt-get freaks out. This seems like a packaging
> error... or am I missing something?
>
> Dane

It looks like another occurrence of
https://bugs.launchpad.net/percona-server/+bug/1174271

/Alexey

[Gergo Erdosi]

Spent hours on trying to figure out why installation fails, now found the bug report. :) Our servers are affected by this issue too, hope the fix will be released soon. We use Puppet to install Percona Server, so we can't really use workarounds.

Gergo Erdosi

[Amol]

i too get this error while installing the percona-toolkit on a ubuntu 10.04 LTS

here is a log

$ sudo dpkg --list percona*

||/ Name                                           Version                                        Description

+++-==============================================-==============================================

ii  percona-server-client-5.5                      5.5.30-rel30.2-500.lucid                       Percona Server database client binaries

ii  percona-server-common-5.5                 5.5.30-rel30.2-500.lucid                       Percona Server database common files (e.g. /etc/mysql/my.cnf)

ii  percona-server-server-5.5                     5.5.30-rel30.2-500.lucid                       Percona Server database server binaries

$ apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /etc/apt/secring.gpg --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A

gpg: requesting key CD2EFD2A from hkp server keys.gnupg.net

gpg: key CD2EFD2A: "Percona MySQL Development Team <mysq...@percona.com>" not changed

gpg: Total number processed: 1

gpg:              unchanged: 1

$ more /etc/apt/sources.list

deb http://archive.ubuntu.com/ubuntu/ lucid main restricted universe

deb-src http://archive.ubuntu.com/ubuntu/ lucid main restricted universe

deb http://archive.ubuntu.com/ubuntu/ lucid-updates main restricted universe

deb-src http://archive.ubuntu.com/ubuntu/ lucid-updates main restricted universe

deb http://security.ubuntu.com/ubuntu lucid-security main restricted universe

deb-src http://security.ubuntu.com/ubuntu lucid-security main restricted universe

deb http://repo.percona.com/apt lucid main

deb-src http://repo.percona.com/apt lucid main

$ sudo apt-get install -V percona-toolkit

Reading package lists... Done

Building dependency tree       

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

  percona-toolkit: Depends: libdbd-mysql-perl but it is not going to be installed or

                            libdbd-mysql-5.1-perl but it is not installable

E: Broken packages

$ sudo apt-get install -V percona-toolkit libdbd-mysql-perl

Reading package lists... Done

Building dependency tree       

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

  libdbd-mysql-perl: Depends: libmysqlclient16 (>= 5.1.21-1) but it is not going to be installed

E: Broken packages

$ sudo apt-get install -V percona-toolkit libdbd-mysql-perl libmysqlclient16

Reading package lists... Done

Building dependency tree       

Reading state information... Done

Some packages could not be installed. This may mean that you have

requested an impossible situation or if you are using the unstable

distribution that some required packages have not yet been created

or been moved out of Incoming.

The following information may help to resolve the situation:

The following packages have unmet dependencies:

  libmysqlclient16: Depends: mysql-common (>= 5.1.69-0ubuntu0.10.04.1)

E: Broken packages

$ sudo apt-get install -V percona-toolkit libdbd-mysql-perl libmysqlclient16 mysql-common

Reading package lists... Done

Building dependency tree       

Reading state information... Done

The following packages were automatically installed and are no longer required:

   libtalloc2 (2.0.1-1)

   bind9-host (9.7.0.dfsg.P1-1ubuntu0.9)

   smbclient (3.4.7~dfsg-1ubuntu3.10)

   dnsutils (9.7.0.dfsg.P1-1ubuntu0.9)

   libgsasl7 (1.4.4-1ubuntu1)

   libdns64 (9.7.0.dfsg.P1-1ubuntu0.9)

   dbconfig-common (1.8.44ubuntu1)

   guile-1.8-libs (1.8.7+1-3ubuntu1)

   libwbclient0 (3.4.7~dfsg-1ubuntu3.10)

   libhtml-template-perl (2.9-1)

   libisccc60 (9.7.0.dfsg.P1-1ubuntu0.9)

   samba-common (3.4.7~dfsg-1ubuntu3.10)

   snmp (5.4.2.1~dfsg0ubuntu1-0ubuntu2.2)

   liblwres60 (9.7.0.dfsg.P1-1ubuntu0.9)

   radiusclient1 (0.3.2-13)

   libbind9-60 (9.7.0.dfsg.P1-1ubuntu0.9)

   libradius1 (0.3.2-13)

   geoip-database (1.4.6.dfsg-17)

   libntlm0 (1.1-1)

   libgeoip1 (1.4.6.dfsg-17)

   wwwconfig-common (0.2.1)

   libisccfg60 (9.7.0.dfsg.P1-1ubuntu0.9)

   libnet-snmp-perl (5.2.0-3)

   libpq5 (8.4.17-0ubuntu10.04)

   samba-common-bin (3.4.7~dfsg-1ubuntu3.10)

   libisc60 (9.7.0.dfsg.P1-1ubuntu0.9)

   javascript-common (7)

   libjs-mootools (1.2.4.0~debian1-1)

Use 'apt-get autoremove' to remove them.

The following packages will be REMOVED:

   percona-server-client-5.5 (5.5.30-rel30.2-500.lucid)

   percona-server-common-5.5 (5.5.30-rel30.2-500.lucid)

   percona-server-server-5.5 (5.5.30-rel30.2-500.lucid)

The following NEW packages will be installed:

   libdbd-mysql-perl (4.012-1ubuntu1)

   libmysqlclient16 (5.1.69-0ubuntu0.10.04.1)

   mysql-common (5.1.69-0ubuntu0.10.04.1)

   percona-toolkit (2.2.2)

0 upgraded, 4 newly installed, 3 to remove and 146 not upgraded.

Need to get 3,701kB/3,838kB of archives.

After this operation, 95.5MB disk space will be freed.

Do you want to continue [Y/n]? n

Abort.

We recently upgraded this server to "percona mysql 5.5" from "mysql 5.1"

will the only workaround be to download and install the toolkit from the web?

[Dane Miller]

On Wed, May 1, 2013 at 12:08 PM, Amol <ajk...@gmail.com> wrote:
> $ sudo apt-get install -V percona-toolkit libdbd-mysql-perl libmysqlclient16

> The following packages have unmet dependencies:
> libmysqlclient16: Depends: mysql-common (>= 5.1.69-0ubuntu0.10.04.1)
> E: Broken packages

> We recently upgraded this server to "percona mysql 5.5" from "mysql 5.1"
>
> will the only workaround be to download and install the toolkit from the
> web?

Try explicitly setting the version like this...

apt-get install \
percona-toolkit \
libmysqlclient16=5.1.68-rel14.6-551.lucid \
libdbd-mysql-perl

The exact version of libmysqlclient16 will change with future percona
updates. You can find the version using "apt-cache show ..." with
some judicious grepping and filtering. For example, this works for
me:

$ apt-cache show libmysqlclient16 | grep -A1 'Source: percona'
Source: percona-server-5.1
Version: 5.1.68-rel14.6-551.lucid


Dane

[Dane Miller]

On Wed, May 1, 2013 at 12:15 AM, Alexey Kopytov
<alexey....@percona.com> wrote:
> It looks like another occurrence of
> https://bugs.launchpad.net/percona-server/+bug/1174271

Ok, thanks for linking the bug report. Shall I add a comment about
this issue (which seems related but different packages) to that
report? Why all the Ubuntu packaging problems?

Dane

[Amol]

Dane, Thanks that worked

[Ignacio Nin]

Hello Dane,

El 01/05/13 16:34, Dane Miller escribi�:

I've added a comment with the output of the issue for 5.1 in lucid.

It seems to me that this problem came because all ubuntu releases are
now providing libmysqlclient16 and libmysqlclient18 newer than ours,
causing our version never to be selected. Since we don't modify the
client, this wouldn't be a problem if these libraries wouldn't depend on
mysql-common, but we intentionally conflict with this package (because
it contains my.cnf) so installing our package with their library is
impossible.

Note that debian squeeze is not affected by this.

I'm fixing the libmysqlclient16 issue for lucid as we speak, in the same
fashion that libmysqlclient18 was fixed for quantal/precise.

Thanks for your report!


N.

--
Ignacio Nin
Build Engineer, Percona Inc.

http://www.percona.com/
(+1 877) 862-4316 ext 524
skype ignacio-nin

Our blog: http://www.mysqlperformanceblog.com/

Got MySQL support?
http://tinyurl.com/mysql-support