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
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)
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
Revision history for this message
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.

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.