Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Debian Jessie 8.7 unmet dependecies installing percona-xtrabackup with mysql-wsrep-5.7 #455

Open
ofigueroa opened this issue Mar 9, 2017 · 8 comments
Open

Debian Jessie 8.7 unmet dependecies installing percona-xtrabackup with mysql-wsrep-5.7 #455

ofigueroa opened this issue Mar 9, 2017 · 8 comments
Assignees
@aglarendil

Comments

@ofigueroa
Copy link

Hi,

I am just trying to install Codership Galera MySql 5.7 from repositories with Percona Xtrabackup and the 'apt-get install' command reports unsatisfied dependencies with:

percona-xtrabackup : Depends: libdbd-mysql-perl but it is not going to be installed
    => libdbd-mysql-perl : Depends: libmysqlclient18 (>= 5.5.24+dfsg-1)
    => libmysqlclient18 : Depends: mysql-common (>= 5.5.53-0+deb8u1)

Sources:

cat /etc/apt/sources.list.d/galera.list 
deb http://releases.galeracluster.com/debian jessie main

Installed packages:

ii  galera-3                       25.3.20-1jessie          amd64        Replication framework for transactional applications
ii  mysql-wsrep-5.7                5.7.17~1debian8          amd64        Metapackage that installs mysql-wsrep client and server packages.
ii  mysql-wsrep-client-5.7         5.7.17~1debian8          amd64        MySQL Client
ii  mysql-wsrep-common-5.7         5.7.17~1debian8          amd64        MySQL Common
ii  mysql-wsrep-server-5.7         5.7.17~1debian8          amd64        MySQL Server

Even installing 'mysql-wsrep-libmysqlclient18' does not resolve the dependencies:

ii  galera-3                           25.3.20-1jessie          amd64        Replication framework for transactional applications
ii  libmysqlclient20:amd64             5.7.17~1debian8          amd64        MySQL shared client libraries
ii  mysql-wsrep-5.7                    5.7.17~1debian8          amd64        Metapackage that installs mysql-wsrep client and server packages.
ii  mysql-wsrep-client-5.7             5.7.17~1debian8          amd64        MySQL Client
ii  mysql-wsrep-common-5.6             5.6.35-25.19-1jessie     all          MySQL 5.6 specific common files, e.g. /etc/mysql/conf.d/my-5.6.cnf
ii  mysql-wsrep-common-5.7             5.7.17~1debian8          amd64        MySQL Common
ii  mysql-wsrep-libmysqlclient18:amd64 5.6.35-25.19-1jessie     amd64        MySQL database client library
ii  mysql-wsrep-server-5.7             5.7.17~1debian8          amd64        MySQL Server

I have a running instance with 'mysql-wsrep-5.6' and xtrabackup with this installed packages:

ii  libdbd-mysql-perl                    4.028-2+deb8u2              amd64        Perl5 database interface to the MySQL database
ii  libmysqlclient18:amd64               5.5.54-0+deb8u1             amd64        MySQL database client library
ii  mysql-common                         5.5.54-0+deb8u1             all          MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-wsrep-5.6                      5.6.35-25.19-1jessie        amd64        Metapackage that installs mysql-wsrep client and server packages.
ii  mysql-wsrep-client-5.6               5.6.35-25.19-1jessie        amd64        MySQL database client binaries
ii  mysql-wsrep-common-5.6               5.6.35-25.19-1jessie        all          MySQL 5.6 specific common files, e.g. /etc/mysql/conf.d/my-5.6.cnf
ii  mysql-wsrep-libmysqlclient18:amd64   5.6.35-25.19-1jessie        amd64        MySQL database client library
ii  mysql-wsrep-server-5.6               5.6.35-25.19-1jessie        amd64        MySQL database wsrep server binaries and system database setup
ii  percona-xtrabackup-22                2.2.13-1.jessie             amd64        Open source backup tool for InnoDB and XtraDB

Thanks :)
@ofigueroa ofigueroa changed the title Debian Jessie 8.7 unmet dependecies installing percona-xtrabackup with mysql-wsrep-mysql-5.7 Debian Jessie 8.7 unmet dependecies installing percona-xtrabackup with mysql-wsrep-5.7 Mar 9, 2017
@aglarendil
Copy link
Contributor

@ofigueroa This issue looks like an issue with repositories pinning. Would you please post apt-cache policy output, as well as apt-cache show libmysqlclient18?

@ofigueroa
Copy link
Author

ofigueroa commented Mar 9, 2017 •
edited
Loading

@aglarendil i did in a clean Debian Jessie installation. Here is.

Thanks a lot :)

root@galera-57:~# apt-cache policy
Package files:
 100 /var/lib/dpkg/status
     release a=now
 500 http://repo.percona.com/apt/ jessie/main amd64 Packages
     release v=1.0,o=Percona Development Team,n=jessie,l=percona,c=main
     origin repo.percona.com
 500 http://releases.galeracluster.com/debian/ jessie/main amd64 Packages
     release o=Galera Cluster,n=jessie,l=Galera Cluster,c=main
     origin releases.galeracluster.com
 500 http://ftp.es.debian.org/debian/ jessie-updates/main Translation-en
 500 http://ftp.es.debian.org/debian/ jessie-updates/main amd64 Packages
     release o=Debian,a=stable-updates,n=jessie-updates,l=Debian,c=main
     origin ftp.es.debian.org
 500 http://security.debian.org/ jessie/updates/main Translation-en
 500 http://security.debian.org/ jessie/updates/main amd64 Packages
     release v=8,o=Debian,a=stable,n=jessie,l=Debian-Security,c=main
     origin security.debian.org
 500 http://ftp.es.debian.org/debian/ jessie/main Translation-en
 500 http://ftp.es.debian.org/debian/ jessie/main amd64 Packages
     release v=8.7,o=Debian,a=stable,n=jessie,l=Debian,c=main
     origin ftp.es.debian.org
Pinned packages:


root@galera-57:~# apt-cache show libmysqlclient18
Package: libmysqlclient18
Source: mysql-5.5
Version: 5.5.54-0+deb8u1
Installed-Size: 3421
Maintainer: Debian MySQL Maintainers <[email protected]>
Architecture: amd64
Depends: mysql-common (>= 5.5.54-0+deb8u1), libc6 (>= 2.17), libgcc1 (>= 1:4.1.1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.1.4)
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.
Description-md5: 49de807663510f5f2afd3e71efe199f1
Homepage: http://dev.mysql.com/
Multi-Arch: same
Pre-Depends: multiarch-support
Section: libs
Priority: optional
Filename: pool/updates/main/m/mysql-5.5/libmysqlclient18_5.5.54-0+deb8u1_amd64.deb
Size: 673378
MD5sum: f876ab42dd0d92979df6dce7a4619210
SHA1: be8e5b0b74d03c929da0ab507dac7d049c8c96f2
SHA256: bacc8e176188bcdd3645268fb49ad5b50b4b19ff9dcd2e1c1baa26472967d7f7

Package: libmysqlclient18
Source: mysql-5.5
Version: 5.5.53-0+deb8u1
Installed-Size: 3415
Maintainer: Debian MySQL Maintainers <[email protected]>
Architecture: amd64
Depends: mysql-common (>= 5.5.53-0+deb8u1), libc6 (>= 2.17), libgcc1 (>= 1:4.1.1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.1.4)
Pre-Depends: multiarch-support
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.
Description-md5: 49de807663510f5f2afd3e71efe199f1
Multi-Arch: same
Homepage: http://dev.mysql.com/
Tag: role::shared-lib
Section: libs
Priority: optional
Filename: pool/main/m/mysql-5.5/libmysqlclient18_5.5.53-0+deb8u1_amd64.deb
Size: 668440
MD5sum: 9899fb21c9fe3b94bded83fbf892786f
SHA1: dcfd3b65ac692fdcd188e79051d3efe4507ba79e
SHA256: 053f840d060c46107347364bada55dd82475d38476b16acf0b4466ec712436d3

And the reverse

root@galera-57:~# apt-cache showpkg libmysqlclient18
Package: libmysqlclient18
Versions:
5.5.54-0+deb8u1 (/var/lib/apt/lists/security.debian.org_dists_jessie_updates_main_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages
                  MD5: 49de807663510f5f2afd3e71efe199f1
 Description Language: en
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_i18n_Translation-en
                  MD5: 49de807663510f5f2afd3e71efe199f1

5.5.53-0+deb8u1 (/var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages
                  MD5: 49de807663510f5f2afd3e71efe199f1
 Description Language: en
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_i18n_Translation-en
                  MD5: 49de807663510f5f2afd3e71efe199f1


Reverse Depends:
  sysbench,libmysqlclient18 5.5.24+dfsg-1
  mysql-wsrep-libmysqlclient18.0,libmysqlclient18
  mysql-wsrep-libmysqlclient18,libmysqlclient18
  zabbix-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  zabbix-proxy-mysql,libmysqlclient18 5.5.24+dfsg-1
  php5-mysql,libmysqlclient18 5.5.24+dfsg-1
  pdns-backend-mysql,libmysqlclient18 5.5.24+dfsg-1
  pdns-backend-mydns,libmysqlclient18 5.5.24+dfsg-1
  libmysqlclient-dev,libmysqlclient18 5.5.54-0+deb8u1
  kamailio-mysql-modules,libmysqlclient18 5.5.24+dfsg-1
  exim4-daemon-heavy,libmysqlclient18 5.5.24+dfsg-1
  asterisk-mysql,libmysqlclient18 5.5.24+dfsg-1
  zabbix-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  zabbix-proxy-mysql,libmysqlclient18 5.5.24+dfsg-1
  xbmc-pvr-mythtv-cmyth,libmysqlclient18 5.5.24+dfsg-1
  xbmc-bin,libmysqlclient18 5.5.24+dfsg-1
  libwtdbomysql38,libmysqlclient18 5.5.24+dfsg-1
  libvtk6.1,libmysqlclient18 5.5.24+dfsg-1
  libvtk5.8,libmysqlclient18 5.5.24+dfsg-1
  voms-mysql-plugin,libmysqlclient18 5.5.24+dfsg-1
  ulogd2-mysql,libmysqlclient18 5.5.24+dfsg-1
  tntdb-mysql4,libmysqlclient18 5.5.24+dfsg-1
  tcl8.6-tdbc-mysql,libmysqlclient18
  tarantool-mysql-plugin,libmysqlclient18 5.5.24+dfsg-1
  tango-db,libmysqlclient18 5.5.24+dfsg-1
  tango-accesscontrol,libmysqlclient18 5.5.24+dfsg-1
  sysbench,libmysqlclient18 5.5.24+dfsg-1
  stardict-tools,libmysqlclient18 5.5.24+dfsg-1
  spl-mysql,libmysqlclient18 5.5.24+dfsg-1
  libsope1,libmysqlclient18 5.5.24+dfsg-1
  slurm-wlm-basic-plugins,libmysqlclient18 5.5.24+dfsg-1
  ruby-mysql2,libmysqlclient18 5.5.24+dfsg-1
  ruby-mysql,libmysqlclient18 5.5.24+dfsg-1
  ruby-dataobjects-mysql,libmysqlclient18 5.5.24+dfsg-1
  rsyslog-mysql,libmysqlclient18 5.5.24+dfsg-1
  root-plugin-sql-mysql,libmysqlclient18 5.5.24+dfsg-1
  r-cran-rmysql,libmysqlclient18 5.5.24+dfsg-1
  rfc5766-turn-server,libmysqlclient18 5.5.24+dfsg-1
  repro,libmysqlclient18 5.5.24+dfsg-1
  librdf-storage-mysql,libmysqlclient18 5.5.24+dfsg-1
  ratbox-services-mysql,libmysqlclient18 5.5.24+dfsg-1
  libquickfix14,libmysqlclient18 5.5.24+dfsg-1
  libqt5sql5-mysql,libmysqlclient18 5.5.24+dfsg-1
  libqt4-sql-mysql,libmysqlclient18 5.5.24+dfsg-1
  qsf,libmysqlclient18 5.5.24+dfsg-1
  python-mysqldb-dbg,libmysqlclient18 5.5.24+dfsg-1
  python-mysqldb,libmysqlclient18 5.5.24+dfsg-1
  pure-ftpd-mysql,libmysqlclient18 5.5.24+dfsg-1
  proftpd-mod-mysql,libmysqlclient18 5.5.24+dfsg-1
  postfix-gld,libmysqlclient18 5.5.24+dfsg-1
  postfix-mysql,libmysqlclient18 5.5.24+dfsg-1
  libpocomysql9-dbg,libmysqlclient18 5.5.24+dfsg-1
  libpocomysql9,libmysqlclient18 5.5.24+dfsg-1
  pmacct,libmysqlclient18 5.5.24+dfsg-1
  pike7.8-mysql,libmysqlclient18 5.5.24+dfsg-1
  php5-mysql,libmysqlclient18 5.5.24+dfsg-1
  perdition-mysql,libmysqlclient18 5.5.24+dfsg-1
  pennmush-mysql,libmysqlclient18 5.5.24+dfsg-1
  pdns-backend-mysql,libmysqlclient18 5.5.24+dfsg-1
  pdns-backend-mydns,libmysqlclient18 5.5.24+dfsg-1
  libpam-mysql,libmysqlclient18 5.5.24+dfsg-1
  opendnssec-enforcer-mysql,libmysqlclient18 5.5.24+dfsg-1
  libmapistore0,libmysqlclient18 5.5.24+dfsg-1
  libmapiproxy0,libmysqlclient18 5.5.24+dfsg-1
  nuauth-log-mysql,libmysqlclient18 5.5.24+dfsg-1
  nuauth-extra,libmysqlclient18 5.5.24+dfsg-1
  netmrg,libmysqlclient18 5.5.24+dfsg-1
  snmptrapd,libmysqlclient18 5.5.24+dfsg-1
  neko,libmysqlclient18 5.5.24+dfsg-1
  ndoutils-nagios3-mysql,libmysqlclient18 5.5.24+dfsg-1
  mysqmail-pure-ftpd-logger,libmysqlclient18 5.5.24+dfsg-1
  mysqmail-postfix-logger,libmysqlclient18 5.5.24+dfsg-1
  mysqmail-dovecot-logger,libmysqlclient18 5.5.24+dfsg-1
  mysqmail-courier-logger,libmysqlclient18 5.5.24+dfsg-1
  mysqltcl,libmysqlclient18 5.5.24+dfsg-1
  mysql-workbench,libmysqlclient18 5.5.24+dfsg-1
  libmysql-ocaml,libmysqlclient18 5.5.24+dfsg-1
  libmysqlcppconn7,libmysqlclient18 5.5.24+dfsg-1
  libmysqlclient-dev,libmysqlclient18 5.5.53-0+deb8u1
  libmysql++3,libmysqlclient18 5.5.24+dfsg-1
  libmyodbc,libmysqlclient18 5.5.24+dfsg-1
  mydumper,libmysqlclient18 5.5.13-1
  muddleftpd,libmysqlclient18 5.5.24+dfsg-1
  motion,libmysqlclient18 5.5.24+dfsg-1
  monitoring-plugins-standard,libmysqlclient18 5.5.24+dfsg-1
  libmailutils4,libmysqlclient18 5.5.24+dfsg-1
  lua-sql-mysql,libmysqlclient18 5.5.24+dfsg-1
  lua-dbi-mysql,libmysqlclient18 5.5.24+dfsg-1
  lighttpd-mod-mysql-vhost,libmysqlclient18 5.5.24+dfsg-1
  libzdb9,libmysqlclient18 5.5.24+dfsg-1
  libpreludedb0,libmysqlclient18 5.5.24+dfsg-1
  libopendbx1-mysql,libmysqlclient18 5.5.24+dfsg-1
  libgda-5.0-mysql,libmysqlclient18 5.5.24+dfsg-1
  libdbd-mysql,libmysqlclient18 5.5.24+dfsg-1
  libdbd-mysql-perl,libmysqlclient18 5.5.24+dfsg-1
  libapache2-mod-musicindex,libmysqlclient18 5.5.24+dfsg-1
  libapache2-mod-log-sql-mysql,libmysqlclient18 5.5.24+dfsg-1
  lfc-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  dpm-srm-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  dpm-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  dpm-name-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  dpm-copy-server-mysql,libmysqlclient18 5.5.24+dfsg-1
  lcd4linux,libmysqlclient18 5.5.24+dfsg-1
  kannel-sqlbox,libmysqlclient18 5.5.24+dfsg-1
  kannel-extras,libmysqlclient18 5.5.24+dfsg-1
  kannel,libmysqlclient18 5.5.24+dfsg-1
  kamailio-mysql-modules,libmysqlclient18 5.5.24+dfsg-1
  inspircd,libmysqlclient18 5.5.24+dfsg-1
  icinga2-ido-mysql,libmysqlclient18 5.5.24+dfsg-1
  hydra,libmysqlclient18 5.5.24+dfsg-1
  htcheck,libmysqlclient18 5.5.24+dfsg-1
  libghc-hsql-mysql-dev,libmysqlclient18 5.5.24+dfsg-1
  grass-core,libmysqlclient18 5.5.24+dfsg-1
  libsqlclient1.7,libmysqlclient18 5.5.24+dfsg-1
  gnunet,libmysqlclient18 5.5.24+dfsg-1
  gnuais,libmysqlclient18 5.5.24+dfsg-1
  gnokii-smsd-mysql,libmysqlclient18 5.5.24+dfsg-1
  gmysqlcc,libmysqlclient18 5.5.24+dfsg-1
  gentle,libmysqlclient18 5.5.24+dfsg-1
  gearman-job-server,libmysqlclient18 5.5.24+dfsg-1
  libgdal1h,libmysqlclient18 5.5.24+dfsg-1
  libgdal-perl,libmysqlclient18 5.5.24+dfsg-1
  python-gammu-dbg,libmysqlclient18 5.5.24+dfsg-1
  python-gammu,libmysqlclient18 5.5.24+dfsg-1
  libgsmsd7,libmysqlclient18 5.5.24+dfsg-1
  gambas3-gb-db-mysql,libmysqlclient18 5.5.24+dfsg-1
  freeradius-mysql,libmysqlclient18 5.5.24+dfsg-1
  flow-tools,libmysqlclient18 5.5.24+dfsg-1
  falconpl-dbi-mysql,libmysqlclient18 5.5.24+dfsg-1
  exim4-daemon-heavy,libmysqlclient18 5.5.24+dfsg-1
  emboss-lib,libmysqlclient18 5.5.24+dfsg-1
  emboss,libmysqlclient18 5.5.24+dfsg-1
  dsyslog-module-mysql,libmysqlclient18 5.5.24+dfsg-1
  dovecot-mysql,libmysqlclient18 5.5.24+dfsg-1
  dbf2mysql,libmysqlclient18 5.5.24+dfsg-1
  libsasl2-modules-sql,libmysqlclient18 5.5.24+dfsg-1
  cvm-mysql,libmysqlclient18 5.5.24+dfsg-1
  ctn,libmysqlclient18 5.5.24+dfsg-1
  libcppdb-mysql0,libmysqlclient18 5.5.24+dfsg-1
  courier-authlib-mysql,libmysqlclient18 5.5.24+dfsg-1
  coturn,libmysqlclient18 5.5.24+dfsg-1
  conquest-mysql,libmysqlclient18 5.5.24+dfsg-1
  collectd-core,libmysqlclient18 5.5.24+dfsg-1
  collectd,libmysqlclient18 5.5.24+dfsg-1
  cl-sql-mysql,libmysqlclient18 5.5.24+dfsg-1
  cfengine3,libmysqlclient18 5.5.24+dfsg-1
  kexi-mysql-driver,libmysqlclient18 5.5.24+dfsg-1
  cacti-spine,libmysqlclient18 5.5.24+dfsg-1
  bareos-database-mysql,libmysqlclient18 5.5.24+dfsg-1
  bacula-common-mysql,libmysqlclient18 5.5.24+dfsg-1
  asterisk-mysql,libmysqlclient18 5.5.24+dfsg-1
  libaprutil1-dbd-mysql,libmysqlclient18 5.5.24+dfsg-1
  libapophenia0,libmysqlclient18 5.5.24+dfsg-1
  aolserver4-nsmysql,libmysqlclient18 5.5.24+dfsg-1
  amarok,libmysqlclient18 5.5.24+dfsg-1
Dependencies:
5.5.54-0+deb8u1 - mysql-common (2 5.5.54-0+deb8u1) libc6 (2 2.17) libgcc1 (2 1:4.1.1) libstdc++6 (2 4.1.1) zlib1g (2 1:1.1.4) multiarch-support (0 (null))
5.5.53-0+deb8u1 - mysql-common (2 5.5.53-0+deb8u1) libc6 (2 2.17) libgcc1 (2 1:4.1.1) libstdc++6 (2 4.1.1) zlib1g (2 1:1.1.4) multiarch-support (0 (null))
Provides:
5.5.54-0+deb8u1 -
5.5.53-0+deb8u1 -
Reverse Provides:
mysql-wsrep-libmysqlclient18.0 5.5.54-25.20-1jessie
mysql-wsrep-libmysqlclient18 5.6.35-25.19-1jessie

Package mysq-common

root@galera-57:~# apt-cache show  mysql-common
Package: mysql-common
Source: mysql-5.5
Version: 5.5.54-0+deb8u1
Installed-Size: 139
Maintainer: Debian MySQL Maintainers <[email protected]>
Architecture: all
Breaks: amarok (<< 2.5.0-2), mysql-client-5.1 (<< 5.5), mysql-server-5.1 (<< 5.5), mysql-server-core-5.1 (<< 5.5)
Description-en: MySQL database common files, e.g. /etc/mysql/my.cnf
 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 files needed by all versions of the client library,
 e.g. /etc/mysql/my.cnf.
Description-md5: 562d254c602f89e4390e28f6362283c8
Homepage: http://dev.mysql.com/
Multi-Arch: foreign
Section: database
Priority: optional
Filename: pool/updates/main/m/mysql-5.5/mysql-common_5.5.54-0+deb8u1_all.deb
Size: 81150
MD5sum: 3ae5e9f5982430d13628526a617a384c
SHA1: ccffe39684c6478524a8412bdc384f1da74a2737
SHA256: 82378b931ed58d7d377af3f9c289e32dba386dc94e8881a63a76694a07a92cd1

Package: mysql-common
Source: mysql-5.5
Version: 5.5.53-0+deb8u1
Installed-Size: 133
Maintainer: Debian MySQL Maintainers <[email protected]>
Architecture: all
Breaks: amarok (<< 2.5.0-2), mysql-client-5.1 (<< 5.5), mysql-server-5.1 (<< 5.5), mysql-server-core-5.1 (<< 5.5)
Description-en: MySQL database common files, e.g. /etc/mysql/my.cnf
 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 files needed by all versions of the client library,
 e.g. /etc/mysql/my.cnf.
Description-md5: 562d254c602f89e4390e28f6362283c8
Multi-Arch: foreign
Homepage: http://dev.mysql.com/
Tag: devel::lang:sql, implemented-in::c, implemented-in::c++, role::app-data,
 works-with::db
Section: database
Priority: optional
Filename: pool/main/m/mysql-5.5/mysql-common_5.5.53-0+deb8u1_all.deb
Size: 75532
MD5sum: 6e10d88d0488198a7c9bb8fd3521f24e
SHA1: baea185e7c3e93e3085054e7889947fc17abe189
SHA256: 327fc2bcbf53fed05bff4a496c7cf89558bb4ab74a4303c1b03acf9ebd4be78e

Reverse package

root@galera-57:~# apt-cache showpkg mysql-common
Package: mysql-common
Versions:
5.5.54-0+deb8u1 (/var/lib/apt/lists/security.debian.org_dists_jessie_updates_main_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages
                  MD5: 562d254c602f89e4390e28f6362283c8
 Description Language: en
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_i18n_Translation-en
                  MD5: 562d254c602f89e4390e28f6362283c8

5.5.53-0+deb8u1 (/var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages)
 Description Language:
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_binary-amd64_Packages
                  MD5: 562d254c602f89e4390e28f6362283c8
 Description Language: en
                 File: /var/lib/apt/lists/ftp.es.debian.org_debian_dists_jessie_main_i18n_Translation-en
                  MD5: 562d254c602f89e4390e28f6362283c8


Reverse Depends:
  percona-xtradb-cluster-common-5.7,mysql-common
  mysql-wsrep-server-5.7,mysql-common 5.7.17
  mysql-wsrep-server-5.7,mysql-common 5.7.17
  mysql-wsrep-common-5.7,mysql-common 5.7.17
  mysql-wsrep-common-5.7,mysql-common 5.7.17
  mysql-wsrep-common-5.6,mysql-common
  mysql-wsrep-common-5.5,mysql-common
  mysql-wsrep-client-5.7,mysql-common 5.7.17
  mysql-wsrep-client-5.7,mysql-common 5.7.17
  mysql-server-5.5,mysql-common 5.5.54-0+deb8u1
  mysql-client-5.5,mysql-common 5.5.54-0+deb8u1
  libmysqlclient18,mysql-common 5.5.54-0+deb8u1
  mariadb-common,mysql-common
  mysql-server-5.5,mysql-common 5.5.53-0+deb8u1
  mysql-client-5.5,mysql-common 5.5.53-0+deb8u1
  libmysqlclient18,mysql-common 5.5.53-0+deb8u1
  mariadb-common,mysql-common
Dependencies:
5.5.54-0+deb8u1 - amarok (3 2.5.0-2) mysql-client-5.1 (3 5.5) mysql-server-5.1 (3 5.5) mysql-server-core-5.1 (3 5.5)
5.5.53-0+deb8u1 - amarok (3 2.5.0-2) mysql-client-5.1 (3 5.5) mysql-server-5.1 (3 5.5) mysql-server-core-5.1 (3 5.5)
Provides:
5.5.54-0+deb8u1 -
5.5.53-0+deb8u1 -
Reverse Provides:
percona-xtradb-cluster-common-5.6 5.6.34-26.19-1.jessie
mysql-wsrep-common-5.7 5.7.17~1debian8
mysql-wsrep-common-5.6 5.6.35-25.19-1jessie
mysql-wsrep-common-5.5 5.5.54-25.20-1jessie

@ofigueroa
Copy link
Author

@aglarendil 👍 I found the issue in the Debian Policy Manual.

The reason is that libdbd-mysql-perl requires a especific version of libmysqlclient18:

Depends: perl (>= 5.20.2-3+deb8u6), perl-dbdabi-94, perlapi-5.20.2, libc6 (>= 2.4), libmysqlclient18 (>= 5.5.24+dfsg-1), zlib1g (>= 1:1.1.4), libdbi-perl

The exact version:
libmysqlclient18 (>= 5.5.24+dfsg-1)

And as we can se in the documentation:
https://www.debian.org/doc/debian-policy/ch-relationships.html#s-virtual

If a relationship field has a version number attached, only real packages will be considered to see whether the relationship is satisfied (or the prohibition violated, for a conflict or breakage). In other words, if a version number is specified, this is a request to ignore all Provides for that package name and consider only real packages. The package manager will assume that a package providing that virtual package is not of the "right" version.

So 'dpkg' and 'apt' ignore the 'Provides' field of debian control file in 'mysql-wsrep-foo-bar' packages.

[email protected]:~# apt-cache show mysql-wsrep-client-5.7 | grep Provide
Provides: virtual-mysql-client, virtual-mysql-client-core

[email protected]:~# apt-cache show mysql-wsrep-server-5.7 | grep Provide
Provides: virtual-mysql-server, virtual-mysql-server-core

[email protected]:~# apt-cache show mysql-wsrep-common-5.7 | grep Provide
Provides: mysql-common

[email protected]:~# apt-cache show mysql-wsrep-libmysqlclient18 | grep Provide
Provides: libmysqlclient18

To resolve the conflict, i'll create a local package from 'libdbd-mysql-perl' source code, modifying the libmysqlclient18 dedependences, removing the version required and providing 'libdbd-mysql-perl' package.

As 'percona-xtrabackup' not need a version of 'libdbd-mysql-perl', my package will act as it.

I've installed all together removing mysql-common version from libmysqlclient18 package, but i think the option above is cleaner.

Original:

Depends: mysql-common (>= 5.5.53-0+deb8u1), libc6 (>= 2.17), libgcc1 (>= 1:4.1.1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.1.4)
Modified:

Depends: mysql-common, libc6 (>= 2.17), libgcc1 (>= 1:4.1.1), libstdc++6 (>= 4.1.1), zlib1g (>= 1:1.1.4)

Result of installed packages:

[email protected]:~# dpkg -l | grep -e "mysql" -e "xtrabackup"
ii  libdbd-mysql-perl              4.028-2+deb8u2            amd64        Perl5 database interface to the MySQL database
ii  libmysqlclient18:amd64         5.5.54-0+deb8u1           amd64        MySQL database client library
ii  mysql-wsrep-5.7                5.7.17~1debian8           amd64        Metapackage that installs mysql-wsrep client and server packages.
ii  mysql-wsrep-client-5.7         5.7.17~1debian8           amd64        MySQL Client
ii  mysql-wsrep-common-5.7         5.7.17~1debian8           amd64        MySQL Common
ii  mysql-wsrep-server-5.7         5.7.17~1debian8           amd64        MySQL Server
ii  percona-xtrabackup-24          2.4.6-2.jessie            amd64        Open source backup tool for InnoDB and XtraDB

Any suggestions are welcome :)

@philip-galera
Copy link
Contributor

This commit may be related:

commit 26f323b810cf60859096d646c721d2d919d6dfe0
Author: Otto Kekäläinen <[email protected]>
Date:   Sun Mar 20 23:19:06 2016 +0200

    Remove dependency on libdbd-mysql-perl in Debian packaging

    As libdbd-mysql-perl in Debian/Ubuntu repositories itself has a circular
    dependency on mysql-common and libmysqlclient18, we don't want to install
    it to aboid pulling in those extra (and potentially conflicting) packages.

diff --git a/debian/control b/debian/control
index 0a533cd..c064095 100644
--- a/debian/control
+++ b/debian/control
@@ -87,7 +87,6 @@ Description: MySQL database common files, e.g. /etc/mysql/my.cnf
 Package: mysql-wsrep-client-5.7
 Architecture: any
 Depends: debianutils (>=1.6),
-         libdbd-mysql-perl (>= 1.2202),
          libdbi-perl,
          libterm-readkey-perl,
          mysql-wsrep-common-5.7 (>= ${binary:Version}),

@ofigueroa
Copy link
Author

@philip-galera That means Galera 5.7 can't be installed with percona-xtrabackup in Debian 8 which depends of libdbd-mysql-perl.

@ofigueroa
Copy link
Author

I think there is another misconfiguration in dependencies, libmysqlclient-dev breaks or replaces mysql-wsrep-5.7, so is not possible package or compile anything that require the libmysqlclient libraries.

root@galera-57:/# apt-get install -V --no-install-recommends libmysqlclient-dev                        
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
   libaio1 (0.3.110-1)
   libmecab2 (0.996-1.1)
   libnuma1 (2.0.10-1)
   libwrap0 (7.6.q-25)
   rsync (3.1.1-3)
   socat (1.7.2.4-2)
Use 'apt-get autoremove' to remove them.
The following packages will be REMOVED:
   mysql-wsrep-5.7 (5.7.17~1debian8)
   mysql-wsrep-client-5.7 (5.7.17~1debian8)
   mysql-wsrep-server-5.7 (5.7.17~1debian8)
The following NEW packages will be installed:
   libmysqlclient-dev (5.7.17~1debian8)
0 upgraded, 1 newly installed, 3 to remove and 0 not upgraded.
Need to get 3264 kB of archives.
After this operation, 460 MB disk space will be freed.
Do you want to continue? [Y/n] n
Abort.

root@galera-57:/# apt-cache show libmysqlclient-dev
Package: libmysqlclient-dev
Source: mysql-wsrep-5.7
Version: 5.7.17~1debian8
Architecture: amd64
Maintainer: Codership Oy <[email protected]>
Installed-Size: 21797
Depends: libmysqlclient20 (= 5.7.17~1debian8)
Replaces: mysql-client-5.6, mysql-client-5.7, mysql-client-core-5.6, mysql-client-core-5.7
Homepage: http://galeracluster.com/
Priority: optional
Section: libdevel
Filename: pool/main/m/mysql-wsrep-5.7/libmysqlclient-dev_5.7.17~1debian8_amd64.deb
Size: 3264228
SHA256: e3fa11bdfc6696b2bf531e9fdb32aab6691ce6a26a0b235aa96f8861f7260b9e
SHA1: 66a3dee357b4a2e22714db17416dfe81b2b9adb0
MD5sum: cb5ca7435b742fdde56d337cc4917373
Description: MySQL development headers
 The MySQL(TM) software delivers a very fast, multi-threaded, multi-user,
 and robust SQL (Structured Query Language) database server. MySQL Server
 is intended for mission-critical, heavy-load production systems as well
 as for embedding into mass-deployed software. MySQL is a trademark of
 Oracle. This package contains the development header files necessary
 to develop MySQL client applications.
Description-md5: 7a00a6b5ee5f172b3ed35c524faa9bd4

Package: libmysqlclient-dev
Source: mysql-5.5
Version: 5.5.53-0+deb8u1
Installed-Size: 5523
Maintainer: Debian MySQL Maintainers <[email protected]>
Architecture: amd64
Replaces: libmysqlclient15-dev
Provides: libmysqlclient15-dev
Depends: libmysqlclient18 (= 5.5.53-0+deb8u1), zlib1g-dev
Conflicts: libmysqlclient10-dev, libmysqlclient12-dev, libmysqlclient14-dev, libmysqlclient15-dev
Description-en: MySQL database development files
 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 development libraries and header files.
Description-md5: 716f7a81dc4e3e8899c7eaa66b24736d
Homepage: http://dev.mysql.com/
Tag: devel::library, role::devel-lib
Section: libdevel
Priority: optional
Filename: pool/main/m/mysql-5.5/libmysqlclient-dev_5.5.53-0+deb8u1_amd64.deb
Size: 948364
MD5sum: e62251cf1690b35944eef16397e23d8c
SHA1: 5d500d644abcba187f51516de3830cb6c46c1d18
SHA256: 0472b9900924aaa4aaaa1b3f294c40febce70a852f3430cdef291acdbbf06177


root@galera-57:/# dpkg -l | grep mysql         
ii  libmysqlclient20:amd64         5.7.17~1debian8          amd64        MySQL shared client libraries
ii  mysql-wsrep-5.7                5.7.17~1debian8          amd64        Metapackage that installs mysql-wsrep client and server packages.
ii  mysql-wsrep-client-5.7         5.7.17~1debian8          amd64        MySQL Client
ii  mysql-wsrep-common-5.7         5.7.17~1debian8          amd64        MySQL Common
ii  mysql-wsrep-server-5.7         5.7.17~1debian8          amd64        MySQL Server

@aglarendil
Copy link
Contributor

@ofigueroa Oscar, sorry for the delay - but I have figured out some time to work on the issue. So, I would like to check 2 things:

  1. are things installable if we install percona-xtrabackup in advance before installing wsrep+galera ?
  2. I think that the latter issue is related to the fact that somehow libmysqlclient-dev replaces mysql-client-* packages while in fact it does not provide corresponding libraries - thus this configuration is actually incorrect.

@ofigueroa
Copy link
Author

ofigueroa commented Apr 19, 2017 •
edited
Loading

Hi @aglarendil, thanks for answer.

1.- If you install percona-xtrabackup first, it breaks dependencies anyway, because the real problem is the libdbd-mysql-perl, which depends of 'libmysqlclient18' and when you try to install mysql-wsrep-5.7 after, removes libmysqlclient18.

I got installed Codership Galera 5.7 with percona-xtrabackup after build a local package 'libdbd-mysql-wsrep-perl', forked from original debian jessie source code with a customized 'debian/control' in which added 'Provides: libdbd-mysql-perl' and a little patch to fix a mysql bug prior to 5.7.9 version ( https://bugs.mysql.com/bug.php?id=78926 ).

root@galera-57:~# dpkg -l | grep -e mysql -e percona
ii  libdbd-mysql-wsrep-perl        4.028-2                     amd64        Perl5 database interface to the MySQL database
ii  libmysqlclient20:amd64         5.7.17~1debian8             amd64        MySQL shared client libraries
ii  mysql-wsrep-client-5.7         5.7.17~1debian8             amd64        MySQL Client
ii  mysql-wsrep-common-5.7         5.7.17~1debian8             amd64        MySQL Common
ii  mysql-wsrep-server-5.7         5.7.17~1debian8             amd64        MySQL Server
ii  percona-release                0.1-4.jessie                all          Package to install Percona gpg key and APT repo
ii  percona-xtrabackup-24          2.4.6-2.jessie              amd64        Open source backup tool for InnoDB and XtraDB

Regards Vladimir :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@aglarendil aglarendil

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@aglarendil @ofigueroa @philip-galera