Not the answer you need?
Register and ask your own question!

percona-xtradb-cluster-server-5.5 depends on percona-xtrabackup (>= 2.1.6)

muffl0nmuffl0n EntrantInactive User Role Beginner
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: 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!


Sven

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.