percona server 5.1 fails via apt-get

[Muhammad Irfan]

When trying to install percona server 5.1 with apt-get it complains about libdbd-mysql-perl module while it's already installed.

$ apt-get install percona-server-client-5.1 percona-server-server-5.1
The following packages have unmet dependencies:
percona-server-server-5.1 : Depends: libdbd-mysql-perl but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
$ dpkg -l | grep -i "dbd"
ii libaprutil1-dbd-sqlite3 1.4.1-3 amd64 Apache Portable Runtime Utility Library - SQLite3 Driver
ii libdbd-mysql-perl 4.021-1+b1 amd64 Perl5 database interface to the MySQL database

[Valerii Kravchuk (valerii-kravchuk)]

What exact Debian/Ubuntu version is it? I see the following on Debian 6.0.9, for example:

root@debian6:/home/openxs# dpkg -l | grep dbd
ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database
root@debian6:/home/openxs# dpkg -l | grep -i percona
ii libmysqlclient16 5.1.73-rel14.11-603.squeeze Percona Server database client library
rc libmysqlclient18 5.5.35-rel33.0-611.squeeze Percona Server database client library
ii percona-server-client-5.1 5.1.73-rel14.11-603.squeeze Percona Server database client binaries
ii percona-server-common 5.1.73-rel14.11-603.squeeze Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-common-5.5 5.5.36-rel34.2-648.squeeze Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-server-5.1 5.1.73-rel14.11-603.squeeze Percona Server database server binaries
rc percona-server-server-5.5 5.5.36-rel34.2-648.squeeze Percona Server database server binaries
rc percona-server-server-5.6 5.6.16-64.2-569.squeeze Percona Server database server binaries
ii percona-toolkit 2.2.7 Advanced MySQL and system command-line tools
root@debian6:/home/openxs# mysql -uroot -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 45
Server version: 5.1.73-rel14.11 (Percona Server (GPL), 14.11, Revision 603)

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

[Muhammad Irfan (muhammad-irfan)]

Distributor ID: Debian
Description: Debian GNU/Linux 7.4 (wheezy)
Release: 7.4
Codename: wheezy

[Valerii Kravchuk (valerii-kravchuk)]

I can not reproduce this on wheezy as well:

root@debian71:/home/openxs# ps aux | grep mysqld
root 5206 0.1 0.0 1936 584 ? S 11:05 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 5269 2.5 3.9 314904 30540 ? Sl 11:05 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/debian71.err --pid-file=/var/lib/mysql/debian71.pid
root 5438 0.0 0.1 3552 808 pts/0 S+ 11:06 0:00 grep mysqld
root@debian71:/home/openxs# mysql -uroot -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.73-rel14.11 (Percona Server (GPL), 14.11, Revision 603)

Copyright (c) 2009-2013 Percona LLC and/or its affiliates
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit
Bye
root@debian71:/home/openxs# dpkg -l | grep -i dbd
ii libdbd-mysql-perl 4.021-1+b1 i386 Perl5 database interface to the MySQL database
root@debian71:/home/openxs# dpkg -l | grep -i Percona
ii libmysqlclient-dev 5.6.15-rel63.0-519.wheezy i386 Percona Server database development files
ii libmysqlclient16 5.1.73-rel14.11-603.wheezy i386 Percona Server database client library
ii libmysqlclient18 5.5.35-rel33.0-611.wheezy i386 Percona Server database client library
ii libmysqlclient18.1 5.6.15-rel63.0-519.wheezy i386 Percona Server database client library
ii libperconaserverclient18.1 5.6.17-66.0-608.wheezy i386 Percona Server database client library
ii percona-server-client-5.1 5.1.73-rel14.11-603.wheezy i386 Percona Server database client binaries
ii percona-server-common 5.1.73-rel14.11-603.wheezy i386 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-common-5.6 5.6.17-66.0-608.wheezy i386 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-server-5.1 5.1.73-rel14.11-603.wheezy i386 Percona Server database server binaries
rc percona-server-server-5.6 5.6.16-64.2-569.wheezy i386 Percona Server database server binaries

Had you executed apt-get autoremove maybe before installing 5.1?

[Tomislav Plavcic (tplavcic)]

It doesn't install on wheezy because percona-server-common conflicts with mysql-common (tried on clean vm).
libdbd-mysql-perl depends on libmysqlclient18 (>= 5.5.24+dfsg-1) and for that it wishes to pull mysql-common (>= 5.5.37-0+wheezy1), since percona-server-common is in conflict with mysql-common there can be no installation.

It works on squeeze, raring, precise because libmysqlclient18 there is smaller version then ours in the repo (5.5.35-33.0), since in wheezy current version from upstream is bigger 5.5.37 it wishes to pull that one and also mysql-common with it.

Valerii maybe you had it installed from before when there was no newer version of libmysqlclient18 from upstream, or you have packages from PXC or something like that.

In PS 5.5 and 5.6 that conflict was removed so upstream libraries get also installed, the problem with 5.1 is that it doesn't understand options in my.cnf which mysql-common (>= 5.5.37) installs since it's from newer version (you can try that from experimental repo currently where the conflict was removed for the next release).

[Tomislav Plavcic (tplavcic)]

@Valerii
can you please check clean installation just with enabled main repo - just to check that we're not missing something?

[Valerii Kravchuk (valerii-kravchuk)]

Let me clarify what exactly to do here. So, I have to install clear Debian wheezy (make sure there is no libmysqlclient18 there), then install libdbd-mysql-perl, then add Percona main repository and try to install percona-server-client-5.1 and percona-server-server-5.1 from it. Please, confirm.

[Valerii Kravchuk (valerii-kravchuk)]

So, I've started with this state:

root@debian71:~# cat /etc/debian_version
7.5
root@debian71:~# dpkg -l | grep -i mysql
root@debian71:~# dpkg -l | grep -i percona

Then I've installed libdbd-mysql-perl:

root@debian71:~# apt-get install libdbd-mysql-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libdbi-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl mysql-common
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl
  libplrpc-perl mysql-common
0 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Need to get 1,852 kB of archives.
After this operation, 6,295 kB of additional disk space will be used.
Do you want to continue [Y/n]?
Get:1 http://ftp.ua.debian.org/debian/ wheezy/main libnet-daemon-perl all 0.48-1 [46.2 kB]
Get:2 http://security.debian.org/ wheezy/updates/main mysql-common all 5.5.37-0+wheezy1 [83.1 kB]
Get:3 http://ftp.ua.debian.org/debian/ wheezy/main libplrpc-perl all 0.2020-2 [36.0 kB]
Get:4 http://security.debian.org/ wheezy/updates/main libmysqlclient18 i386 5.5.37-0+wheezy1 [663 kB]
Get:5 http://ftp.ua.debian.org/debian/ wheezy/main libdbi-perl i386 1.622-1 [897 kB]
Get:6 http://ftp.ua.debian.org/debian/ wheezy/main libdbd-mysql-perl i386 4.021-1+b1 [127 kB]
Fetched 1,852 kB in 3s (476 kB/s)
Selecting previously unselected package mysql-common.
(Reading database ... 48631 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.37-0+wheezy1_all.deb) ...
Selecting previously unselected package libmysqlclient18:i386.
Unpacking libmysqlclient18:i386 (from .../libmysqlclient18_5.5.37-0+wheezy1_i386.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.622-1_i386.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1+b1_i386.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.37-0+wheezy1) ...
Setting up libmysqlclient18:i386 (5.5.37-0+wheezy1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.622-1) ...
Setting up libdbd-mysql-perl (4.021-1+b1) ...
root@debian71:~# dpkg -l | grep -i mysql
ii libdbd-mysql-perl 4.021-1+b1 i386 Perl5 database interface to the MySQL database
ii libmysqlclient18:i386 5.5.37-0+wheezy1 i386 MySQL database client library
ii mysql-common 5.5.37-0+wheezy1 all MySQL database common files, e.g. /etc/mysql/my.cnf

Then I added Percona main repository:

root@debian71:~# grep percona /etc/apt/sources.list
deb http://repo.percona.com/apt wheezy main
deb-src http://repo.percona.com/apt wheezy main
root@debia...

[Tomislav Plavcic (tplavcic)]

To simplify (and this currently doesn't work for me) you can just install clean wheezy, enable Percona main repo and try to install percona-server-server-5.1
That should pull client and libdbd-mysql-perl packages.
You can just make a note if libmysqlclient18 and mysql-common were installed before the PS5.1 installation.

If you can install it any other way from main repo I would very much appreciate if you clarify with which steps you manage to do that?
Thank you!

[Tomislav Plavcic (tplavcic)]

And after adding main repo and before installation do the apt-get update - not sure if that would change anything.

[Tomislav Plavcic (tplavcic)]

Sorry, didn't see your comment as we were writing at the same time.
So it's not working but do you currently know at any steps how I can successfully install from the main repo on wheezy (how was it done in your comment #3)?
Thanks!

[Shahriyar Rzayev (rzayev-sehriyar)]

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