GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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:
    Code:
    # /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-x...ng_binary.html
    Unfortunately this package only contains one xtrabackup-binary:
    Code:
    # 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:
    Code:
    # 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":
    Code:
    # 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:
    Code:
    # 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:
    Code:
    # 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

  • #2
    I was completely on the wrong track.

    Maybe I should have paid more attention to the error message of xtrabackup:
    Code:
    [...]
    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!
    The odd thing is, I did not have a value for "innodb_log_file_size" in my config. I never had since I set up the cluster. After adding this setting everything went back to normal
    Code:
    innodb_log_file_size=5M
    Maybe the default value for this variable changed in one of the last releases?


    PS: The value was changed in MySQL 5.6.8: http://dev.mysql.com/doc/refman/5.6/..._log_file_size
    Maybe this was backported to PXC 5.5 in some way?
    Last edited by muffl0n; 08-28-2014, 04:31 AM.

    Comment


    • #3
      Besides that, the manual seems outdated. If I can safely backup my PXC 5.5-Server with the binary "xtrabackup" and there aren't even other binarys this page is misleading: ​http://www.percona.com/doc/percona-x...ng_binary.html

      Comment


      • #4
        Hi,

        Glad to know that your issue resolved. Actually, it is a bug, and you have used workaround. It's with low priority but very soon it will be resolved.
        https://bugs.launchpad.net/percona-x...p/+bug/1334062

        Also thanks for pointing out that doc page. actually, it should be removed from manual. We have also created bug for that
        https://bugs.launchpad.net/percona-x...p/+bug/1364273

        Comment

        Working...
        X