xb 2.2 single binary fails against ps 5.1and 5.5 if innodb_log_file_size is not specified in server my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
XtraBackup 2.2 (revno 4909) single binary will fail to backup Percona Server 5.1 (revno 600) and Percona Server 5.5 (revno 599) if the server does not have innodb_
innobackupex stderr:
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
131203 19:14:44 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:
131203 19:14:44 innobackupex: Connected to MySQL server
131203 19:14:44 innobackupex: Executing a version check against the server...
131203 19:14:44 innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql server version 5.1.72
innobackupex: Created backup directory /mnt/xb-
131203 19:14:44 innobackupex: Starting ibbackup with command: xtrabackup --defaults-
innobackupex: Waiting for ibbackup (pid=11150) to suspend
innobackupex: Suspend file '/mnt/xb-
xtrabackup version 2.2.0 based on MySQL server 5.6.14 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mnt/xb-
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
InnoDB: than specified in the .cnf file 50331648 bytes!
innobackupex: Error: The xtrabackup child process has died at /mnt/xb-
my.cnf:
[client]
port=10000
socket=
[mysqld]
basedir=
datadir=
tmpdir=
port=10000
socket=
pid-file=
console
user=root
server-id=1
general-
innodb_
Explicitly adding innodb_
summary: |
- xb 2.2 single binary fails against ps 5.1 if innodb_log_file_size is not - specified in server my.cnf + xb 2.2 single binary fails against ps 5.1and 5.5 if innodb_log_file_size + is not specified in server my.cnf |
description: | updated |
This is similar to other hard-coded defaults in the server, though this one is specific to single binary implementation. For example, if there's no explicit datadir in my.cnf, the server will use a default value that depends on whether it was installed from .tar.gz, or Debian package, or RPM. XtraBackup has no way to guess this default, so it will fail.
It is the same case here: innodb_ log_file_ size is an essential part of InnoDB configuration for XtraBackup, but if it's not specifiied explicitly, there's no reliable way to guess the default value used by the server. This can be implemented in a reliable way when we merged innobackupex and xtrabackup.
For now, we should document it as a known limitation. Added a note to https:/ /blueprints. launchpad. net/percona- xtrabackup/ +spec/document- single- binary