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: http://www.percona.com/doc/percona-xtrabackup/2.1/xtrabackup_bin/choosing_binary.html
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!