percona-xtradb-cluster-55 can not be installed with apt-get on Ubuntu 14.04

[Valerii Kravchuk]

None of the instructions from the manual (http://www.percona.com/doc/percona-xtradb-cluster/5.5/installation/apt_repo.html or http://www.percona.com/doc/percona-xtradb-cluster/5.5/installation.html#deb-based-systems) really works. Let me quote them here:

"Note

For Ubuntu 14.04 (Trusty) percona-xtradb-cluster-galera-2.x will have to be specified with the meta package so the installation command should look like:

$ sudo apt-get install percona-xtradb-cluster-55 percona-xtradb-cluster-galera-2.x"

"Instead of percona-xtradb-cluster-55 you can install percona-xtradb-cluster-full-55 meta-package which will install percona-xtradb-cluster-test-5.5, percona-xtradb-cluster-5.5-dbg, percona-xtradb-cluster-garbd-2.x, percona-xtradb-cluster-galera-2x-dbg, percona-xtradb-cluster-garbd-2.x-dbg and libmysqlclient18 packages in addition."

Now, let's check what we have in reality:

openxs@ao756:~$ cat /etc/issue
Ubuntu 14.04.1 LTS \n \l

openxs@ao756:~$ sudo apt-get update
[sudo] password for openxs:
Ign http://extras.ubuntu.com trusty InRelease
Ign http://ppa.launchpad.net trusty InRelease
Hit http://extras.ubuntu.com trusty Release.gpg
...
Ign http://ua.archive.ubuntu.com trusty/universe Translation-en_US
Fetched 729 kB in 21s (34,3 kB/s)
Reading package lists... Done
openxs@ao756:~$ sudo apt-get install percona-xtradb-cluster-full-55
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-xtradb-cluster-full-55 : Depends: percona-xtradb-cluster-galera-2 but it is not going to be installed
                                  Depends: percona-xtradb-cluster-galera2-dbg but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
openxs@ao756:~$ sudo apt-get install percona-xtradb-cluster-55
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-xtradb-cluster-55 : Depends: percona-xtradb-cluster-galera-2 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
openxs@ao756:~$ sudo apt-get install percona-xtradb-cluster-55 percona-xtradb-cluster-galera-2
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-xtradb-cluster-galera-2 : Depends: percona-xtradb-cluster-galera-2.x (= 2.11.2675.trusty) but 165-0ubuntu1 is to be installed
E: Unable to correct problems, you have held broken packages.
openxs@ao756:~$ sudo apt-get install percona-xtradb-cluster-55 percona-xtradb-cluster-galera-2.x
Reading package lists... Done
Building dependency tree
Reading state information... Done
percona-xtradb-cluster-galera-2.x is already the newest version.
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-xtradb-cluster-55 : Depends: percona-xtradb-cluster-galera-2 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

So, nothing works, neither by the manual nor as usual in other Debian-based cases.

In case you care (I've installed percona-xtradb-cluster-galera-2.x separately before in attempts to resolve this):

openxs@ao756:~$ dpkg -l | grep -i percona
ii libmysqlclient18 1:5.5.35-rel33.0-611.raring amd64 Percona Server database client library
ii libmysqlclient18-dev 1:5.5.35-rel33.0-611.raring amd64 Percona Server database development files
rc libmysqlclient18.1 1:5.6.15-rel63.0-519.raring amd64 Percona Server database client library
ii libperconaserverclient18 5.5.40-rel36.1-707.trusty amd64 Percona Server database client library
ii libperconaserverclient18.1 5.6.21-70.1-698.trusty amd64 Percona Server database client library
ii percona-server-client-5.6 5.6.21-70.1-698.trusty amd64 Percona Server database client binaries
ii percona-server-common-5.5 5.5.40-rel36.1-707.trusty amd64 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-common-5.6 5.6.21-70.1-698.trusty amd64 Percona Server database common files (e.g. /etc/mysql/my.cnf)
rc percona-server-server-5.5 5.5.37-rel35.0-657.saucy amd64 Percona Server database server binaries
ii percona-server-server-5.6 5.6.21-70.1-698.trusty amd64 Percona Server database server binaries
ii percona-toolkit 2.2.12 all Advanced MySQL and system command-line tools
ii percona-xtrabackup 2.2.7-5050-1.trusty amd64 Open source backup tool for InnoDB and XtraDB
ii percona-xtradb-cluster-galera-2.x 165-0ubuntu1 amd64 Synchronous multi-master replication plugin for transactional applications

 sudo apt-get install percona-xtradb-cluster-56 just works in this case.

[Valerii Kravchuk (valerii-kravchuk)]

Confirmed for 5.5, works for 5.6:

openxs@ao756:~$ mysql -uroot -proot test
Warning: Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.21-70.1-56 Percona XtraDB Cluster (GPL), Release rel70.1, Revision 938, WSREP version 25.8, wsrep_25.8.r4150

Copyright (c) 2009-2014 Percona LLC and/or its affiliates
Copyright (c) 2000, 2014, 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>

[Brandon (genokan)]

sudo apt-get install percona-xtradb-cluster-full-55
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-xtradb-cluster-full-55 : Depends: percona-xtradb-cluster-server-5.5 (>= 5.5.41-25.11-853.trusty) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-client-5.5 (>= 5.5.41-25.11-853.trusty) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-galera-2 but it is not going to be installed
                                  Depends: percona-xtradb-cluster-test-5.5 (>= 5.5.41-25.11-853.trusty) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-5.5-dbg (>= 5.5.41-25.11-853.trusty) but it is not going to be installed
                                  Depends: percona-xtradb-cluster-galera2-dbg but it is not going to be installed
                                  Depends: percona-xtradb-cluster-server-debug-5.5 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.

[Shahriyar Rzayev (rzayev-sehriyar)]

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