ubuntu 12.04 LTS percona cluster 5.6 install problem

[Francois Stark]

When Installing Percona XtraDB Cluster on Ubuntu 12.04 LTS - fresh OS install - I get the following errors:

Unpacking percona-xtradb-cluster-client-5.6 (from .../percona-xtradb-cluster-client-5.6_5.6.15-25.2-645.precise_amd64.deb) ...
dpkg: error processing /var/cache/apt/archives/percona-xtradb-cluster-client-5.6_5.6.15-25.2-645.precise_amd64.deb (--unpack):
trying to overwrite '/usr/share/man/man1/mysql.1.gz', which is also in package mysql-client-core-5.5 5.5.32-0ubuntu0.12.04.1
dpkg-deb: error: subprocess paste was killed by signal (Broken pipe)

I have three identical Dell servers, and did frexh 12.04 installs on all three. Followed exactly the same install process as on
http://www.percona.com/doc/percona-x...ntu_howto.html

Two of the servers failed with the error above and the third worked!!!

I tried fixing it with apt-get install -f but keep getting the same error.

[Francois Stark (d-francois)]

mmmm then I uninstalled everything for 5.6:

apt-get remove --purge percona***** <expand to remove all percona packages >

- and tried installing 5.5. The same two systems gave problems again - could not set the root password:
Unable to set password for the Percona Server "root" user │
   │ │
   │ An error occurred while setting the password for the Percona Server administrative user. This may have happened because the account already has a password, or because of a communication problem with the Percona Server │
   │ daemon.

The third system worked fine. again.
This is from the working server:
--------------------------------------------------------------------------------------------------------------------------------------------------------
Get:1 http://repo.percona.com/apt/ precise/main percona-xtrabackup amd64 2.1.6-702-1.precise [8 499 kB]
Get:2 http://repo.percona.com/apt/ precise/main percona-xtradb-cluster-common-5.5 all 5.5.34-25.9-607.precise [2 832 B]
Get:3 http://repo.percona.com/apt/ precise/main percona-xtradb-cluster-client-5.5 amd64 5.5.34-25.9-607.precise [8 512 kB]
Get:4 http://repo.percona.com/apt/ precise/main percona-xtradb-cluster-galera-2.x amd64 163.precise [1 512 kB]
Get:5 http://repo.percona.com/apt/ precise/main percona-xtradb-cluster-server-5.5 amd64 5.5.34-25.9-607.precise [18,0 MB]
Fetched 36,5 MB in 10s (3 393 kB/s)
Preconfiguring packages ...
Selecting previously unselected package percona-xtrabackup.
(Reading database ... 76470 files and directories currently installed.)
Unpacking percona-xtrabackup (from .../percona-xtrabackup_2.1.6-702-1.precise_amd64.deb) ...
Selecting previously unselected package percona-xtradb-cluster-common-5.5.
Unpacking percona-xtradb-cluster-common-5.5 (from .../percona-xtradb-cluster-common-5.5_5.5.34-25.9-607.precise_all.deb) ...
Selecting previously unselected package percona-xtradb-cluster-client-5.5.
Unpacking percona-xtradb-cluster-client-5.5 (from .../percona-xtradb-cluster-client-5.5_5.5.34-25.9-607.precise_amd64.deb) ...
Selecting previously unselected package percona-xtradb-cluster-galera-2.x.
Unpacking percona-xtradb-cluster-galer...

[Francois Stark (d-francois)]

mmmm further inspection showed me it was the my.cnf file, containing the lines

#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M

That caused the problem. Since I wanted a fresh install, I just deleted my.cnf, removed everything and re-installed. All seems ok for now.
Question: Where did this my.cnf file come from??? Original mysql installation from LAMP?

[Raghavendra D Prabhu (raghavendra-prabhu)]

@Francois,

a) The first issue seems to have occurred because there was a
mysql package. So, the recommended install is to remove existing
mysql, percona-server packages before doing a new pxc
installation.

b) Did you remove the data directory (assuming test data) when it asks during purge? Otherwise,
you will need to run mysql_upgrade manually on 5.5 data
directory.

Also, purge doesn't remove the cnfs under /etc/mysql (these have
some debian passwords) and/or my.cnf. Also, some of the my.cnf's variables for 5.6 may not
apply to 5.5.

[Launchpad Janitor (janitor)]

[Expired for Percona XtraDB Cluster because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

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