Hello,
we are running PXC 5.5 on Ubuntu 12.04 LTS since January this year. Some weeks ago (I don’t know the exact date) our backups stopped working. This is the error message I get from running xtrabackup:
# /usr/bin/xtrabackup --backup --target-dir=/data/mysql-backup/data/work
/usr/bin/xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/mysql
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
InnoDB: than specified in the .cnf file 50331648 bytes!
As I realised today it seems that this is because the package “percona-xtrabackup” was updated to version 2.2.3 while the PXC stayed at version 5.5. This page tells me that I need xtrabackup_55: [URL]http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/choosing_binary.html[/URL]
Unfortunately this package only contains one xtrabackup-binary:
# dpkg --contents /var/cache/apt/archives/percona-xtrabackup_2.2.3-4982-1.precise_amd64.deb
[...]
-rwxr-xr-x root/root 10699016 2014-06-12 10:09 ./usr/bin/xtrabackup
[...]
However the package “percona-xtrabackup-21” contains both binarys:
# dpkg --contents percona-xtrabackup-21_2.1.9-746-1.precise_amd64.deb
[...]
-rwxr-xr-x root/root 4640184 2014-06-13 09:48 ./usr/bin/xtrabackup_55
-rwxr-xr-x root/root 11756040 2014-06-13 09:48 ./usr/bin/xtrabackup_56
[...]
I removed the package “percona-xtrabackup” in order to downgrade to the package “percona-xtrabackup-21”:
# dpkg -P --force-depends percona-xtrabackup
dpkg: percona-xtrabackup: dependency problems, but removing anyway as you requested:
percona-xtradb-cluster-server-5.5 depends on percona-xtrabackup (>= 2.1.6); however:
Package percona-xtrabackup is to be removed.
(Reading database ... 37322 files and directories currently installed.)
Removing percona-xtrabackup ...
But now I’m stuck at installing the 2.1-package:
# apt-get install percona-xtrabackup-21
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
percona-xtradb-cluster-server-5.5 : Depends: percona-xtrabackup (>= 2.1.6) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
Trying to fix these errors it get’s even worse as apt-get wants to remove the whole server:
# apt-get -f install -s
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages will be REMOVED:
percona-xtradb-cluster-server-5.5
The following held packages will be changed:
percona-xtradb-cluster-server-5.5
0 upgraded, 0 newly installed, 1 to remove and 18 not upgraded.
Remv percona-xtradb-cluster-server-5.5 [5.5.37-25.10-756.precise]
I’m totally stuck and would be glad for any piece of advice someone can give.
Thank you very much in advance!
Sven
