percona-server-client-5.6.16-64.2-569.wheezy doesn't provide 'mysql-client'

Bug #1297587 reported by Timur Bakeyev
32
This bug affects 5 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Tomislav Plavcic
5.1
Invalid
Undecided
Unassigned
5.5
Fix Released
High
Tomislav Plavcic
5.6
Fix Released
High
Tomislav Plavcic

Bug Description

Transferring from the bug #1294211 as, seems, last comments were skipped on resolution.

I was happily running percona-server-server-5.6(5.6.15-rel63.0-519.wheezy) on my Debian GNU/Linux 7.4 (wheezy) amd64 installation, but with the recent update of Percona server 'apt-get dist-upgrade' gives me the following:

# dpkg -l|grep percona
ii percona-server-client-5.6 5.6.15-rel63.0-519.wheezy amd64 Percona Server database client binaries
ii percona-server-common-5.6 5.6.15-rel63.0-519.wheezy amd64 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-server-5.6 5.6.15-rel63.0-519.wheezy amd64 Percona Server database server binaries

# apt-get dist-upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages will be REMOVED:
  percona-server-client-5.6 percona-server-server-5.6
The following NEW packages will be installed:
  mysql-client mysql-client-5.5 mysql-common
The following packages will be upgraded:
  percona-server-common-5.6
1 upgraded, 3 newly installed, 2 to remove and 0 not upgraded.

The root of the problem is combination of the packages installed on my system, in particular - zabbix-server-mysql. It requires 'mysql-client | mariadb-client':

Package: zabbix-server-mysql
Source: zabbix
Version: 1:2.2.2-1+wheezy
Architecture: amd64
Maintainer: Kodai Terashima <email address hidden>
Installed-Size: 7599
Pre-Depends: debconf
Depends: libc6 (>= 2.7), libcurl3-gnutls (>= 7.16.2), libiksemel3, libldap-2.4-2 (>= 2.4.7), libmysqlclient18 (>= 5.5.24+dfsg-1), libodbc1 (>= 2.2.11) | unixodbc (>= 2.2.11), libopenipmi0, libsnmp15 (>= 5.4.3~dfsg), libssh2-1 (>= 1.0), libssl1.0.0 (>= 1.
0.0), libxml2 (>= 2.7.4), debconf (>= 0.5) | debconf-2.0, mysql-client | mariadb-client, fping, adduser, dbconfig-common (>= 1.8.19), lsb-base
Recommends: mysql-server (>= 4.0.16-2), snmpd, snmptt
Suggests: zabbix-frontend-php, logrotate
Conflicts: zabbix-proxy-mysql, zabbix-proxy-pgsql, zabbix-proxy-sqlite3, zabbix-server-pgsql

While Percona server provides:

Package: percona-server-client-5.6
Source: percona-server-5.6
Version: 5.6.16-64.2-569.wheezy
Architecture: amd64
Maintainer: Percona Server Development Team <email address hidden>
Installed-Size: 38104
Depends: debianutils (>= 1.6), libdbi-perl, percona-server-common-5.6 (>= 5.6.16-64.2-569.wheezy), libperconaserverclient18.1 (>= 5.6.16-64.2-569.wheezy), libc6 (>= 2.11), libgcc1 (>= 1:4.1.1), libncurses5 (>= 5.5-5~), libssl1.0.0 (>= 1.0.0), libstdc++6 (>= 4.1.1), libtinfo5, zlib1g (>= 1:1.1.4)
Breaks: mariadb-client, mariadb-client-5.5, mariadb-client-core-5.5, mysql-client-5.0, mysql-client-5.1, mysql-client-5.5, mysql-client-5.6, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Replaces: mariadb-client, mariadb-client-5.5, mariadb-client-core-5.5, mysql-client-5.0, mysql-client-5.1, mysql-client-5.5, mysql-client-5.6, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Provides: virtual-mysql-client

vs older version:

Package: percona-server-client-5.6
Status: install ok installed
Priority: extra
Section: database
Installed-Size: 37475
Maintainer: Percona Server Development Team <email address hidden>
Architecture: amd64
Source: percona-server-5.6
Version: 5.6.15-rel63.0-519.wheezy
Replaces: mysql-client (<< 5.6.15-rel63.0-519.wheezy), mysql-client-5.0, mysql-client-5.1, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Depends: debianutils (>= 1.6), libdbi-perl, percona-server-common-5.6 (>= 5.6.15-rel63.0-519.wheezy), libmysqlclient18.1
Conflicts: mysql-client (<< 5.6.15-rel63.0-519.wheezy), mysql-client-5.0, mysql-client-5.1, mysql-client-core-5.1, percona-server-client-5.1, percona-server-client-5.5, percona-xtradb-client-5.0
Provides: mysql-client, virtual-mysql-client

In particular, 'provides' section now misses 'mysql-client'. So, in my case, when zabbix-server-mysql requests 'mysql-client' it brings mysql-client-5.5, which kicks off percona-server-*.

So, again, please revert to the previous behavior, so it' would be possible to use percona-server as a full replacement for mysql-server/mariadb-server on Debain.

I can assume, that there is a move towards 'virtual-mysql-client' in the Debian, but ATM:

apt-rdepends -r virtual-mysql-client

virtual-mysql-client
  Reverse Depends: cacti (0.8.8a+dfsg-5+deb7u2)
  Reverse Depends: drupal7 (7.14-2+deb7u2)
  Reverse Depends: jffnms (0.9.3-3)
  Reverse Depends: owncloud-mysql (5.0.14.a+dfsg-1~bpo70+2)
  Reverse Depends: redmine-mysql (1.4.4+dfsg1-2+deb7u1)
  Reverse Depends: roundcube-mysql (0.7.2-9+deb7u1)
  Reverse Depends: simba (0.8.4-4.2)

# apt-rdepends -r mysql-client

mysql-client
  Reverse Depends: audiolink (>= 0.05-1.2)
  Reverse Depends: auth2db-common (0.2.5-2+dfsg-4)
  Reverse Depends: automysqlbackup (2.6+debian.3-1)
  Reverse Depends: bacula-director-mysql (5.2.6+dfsg-9)
  Reverse Depends: beancounter (0.8.10)
  Reverse Depends: cqrlog (1.4.1-1)
  Reverse Depends: dpm-name-server-mysql (1.8.2-1+b2)
  Reverse Depends: dpsyco-mysql (1.0.36)
  Reverse Depends: drupal7 (7.14-2+deb7u2)
  Reverse Depends: frontaccounting (2.2.10-3.1)
  Reverse Depends: jffnms (0.9.3-3)
  Reverse Depends: lfc-server-mysql (1.8.2-1+b2)
  Reverse Depends: libdspam7-drv-mysql (3.10.1+dfsg-11)
  Reverse Depends: movabletype-opensource (5.1.4+dfsg-4+deb7u1)
  Reverse Depends: mysql-testsuite-5.5 (= 5.5.33+dfsg-0+wheezy1)
  Reverse Depends: mysql-workbench (5.2.40+dfsg-2)
  Reverse Depends: ndoutils-nagios3-mysql (1.4b9-1.1+b1)
  Reverse Depends: netmrg (0.20-6.1)
  Reverse Depends: ocsinventory-reports (2.0.5-1.1)
  Reverse Depends: opendnssec-enforcer-mysql (1:1.3.9-5)
  Reverse Depends: owncloud-mysql (5.0.14.a+dfsg-1~bpo70+2)
  Reverse Depends: percona-xtrabackup-20 (2.0.8-587.wheezy)
  Reverse Depends: percona-xtrabackup-test (2.1.8-733-1.wheezy)
  Reverse Depends: phpbb3 (3.0.10-4+deb7u1)
  Reverse Depends: piwi (0.8+20041206-3)
  Reverse Depends: postfix-cluebringer-mysql (2.0.10-1)
  Reverse Depends: postfixadmin (2.3.5-2)
  Reverse Depends: redmine-mysql (1.4.4+dfsg1-2+deb7u1)
  Reverse Depends: roundcube-mysql (0.7.2-9+deb7u1)
  Reverse Depends: rt4-db-mysql (>= 4.0.7-5+deb7u2)
  Reverse Depends: scuttle (0.7.4-8.1)
  Reverse Depends: wordpress (3.6.1+dfsg-1~deb7u1)
  Reverse Depends: zabbix-proxy-mysql (1:2.2.2-1+wheezy)
  Reverse Depends: zabbix-server-mysql (1:2.2.2-1+wheezy)
  Reverse Depends: zoneminder (1.25.0-4)

Some packages have:

Depends: mysql-client | virtual-mysql-client

So appear in both lists, but still, mysql-client is more popular.

Tags: pkg

Related branches

tags: added: pkg
Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

This is easy to confirm on any Debian with recent 5.5 and 5.6 .deb packages:

[openxs@chief ~]$ dpkg -I percona-server-client-5.6_5.6.16-64.2-569.precise_amd64.deb | grep Provides
 Provides: virtual-mysql-client
[openxs@chief ~]$ dpkg -I percona-server-client-5.5_5.5.36-rel34.2-648.precise_amd64.deb | grep Provides
 Provides: virtual-mysql-client

Revision history for this message
Bruno Baketaric (bruno-baketaric) wrote :

By the way, the same applies to percona-server-server-5.6_5.6.16-64.2-569.wheezy:

apt-cache show percona-server-server-5.6 | grep Provides
Provides: virtual-mysql-server

Revision history for this message
Peter Schwaller (peter-schwaller) wrote :

Sorry for all the trouble this has caused you. We expect to release a new version of 5.6 next week which fixes this. A version of 5.5 will either be next week, or soon after that.

Revision history for this message
Paul D. Walker (pauldwalker) wrote :

Question: do you have a recommended way to apply the new package (assume Ubuntu) to correct the problem with the broken package state, without uninstalling the relevant packages and reinstalling them again?

Many thanks.

Revision history for this message
Paul D. Walker (pauldwalker) wrote :

replying to my own question:

I went to the percona repository, downloaded the latest packages for
- libperconaserverclient18.1_5.6
- percona-server-common-5.6
- percona-server-client-5.6
- percona-server-server-5.6

installed them using the dpkg --install <deb package name> in the above order. (I forget if I installed libperconaserver first or percona-server-common).

After that, further apt-get update/install commands no longer threw errors.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

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

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.