Xtrabackup 2.2.3 fails to perform a full backup on PS 5.5 if innodb_log_file_size on the [mysqld] section of my.cnf is not set

Bug #1334062 reported by Jaime Sicam on 2014-06-25
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Low
Alexey Kopytov
2.1
Won't Fix
Undecided
Unassigned
2.2
Fix Released
Low
Alexey Kopytov

Bug Description

nnobackupex --defaults-file=/home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/my.sandbox.cnf --host=127.0.0.1 --port=23590 --user=root --password=msandbox ~/backups

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.

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

140625 08:29:36 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/my.sandbox.cnf;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=23590' as 'root' (using password: YES).
140625 08:29:36 innobackupex: Connected to MySQL server
140625 08:29:36 innobackupex: Executing a version check against the server...
140625 08:29:40 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.5.35-rel33.0-log

innobackupex: Created backup directory /home/user/backups/2014-06-25_08-29-40

140625 08:29:40 innobackupex: Starting ibbackup with command: xtrabackup --defaults-file="/home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/my.sandbox.cnf" --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/home/user/backups/2014-06-25_08-29-40 --tmpdir=/home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/tmp --extra-lsndir='/home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/tmp'
innobackupex: Waiting for ibbackup (pid=3395) to suspend
innobackupex: Suspend file '/home/user/backups/2014-06-25_08-29-40/xtrabackup_suspended_2'

xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/user/sandboxes/rsandbox_Percona-Server-5_5_35/master/data
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!
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672.

Workaround:
Specify innodb_log_file_size in [mysqld] section of my.cnf

Related branches

Jaime Sicam (jssicam) on 2014-06-25
summary: - Xtrabackup 2.2.3 fails to perform a full backup PS 5.5 if
+ Xtrabackup 2.2.3 fails to perform a full backup on PS 5.5 if
innodb_log_file_size on the [mysqld] section of my.cnf is not set
Alexey Kopytov (akopytov) wrote :

This will be covered by https://blueprints.launchpad.net/percona-xtrabackup/+spec/read-server-options-with-show-variables. Keeping this bug as the BluePrint has wider in scope, and fixing this bug will be more like a side-effect.

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-917

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Duplicates of this bug

Other bug subscribers