Changed innodb_log_file_size = 512M to loose-innodb_log_file_size = 512M
sudo innobackupex /tmp
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
120926 17:45:33 innobackupex: Starting mysql with options: --unbuffered --
120926 17:45:33 innobackupex: Connected to database with mysql child process (pid=3355)
120926 17:45:39 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /tmp/2012-09-26_17-45-39
120926 17:45:39 innobackupex: Starting mysql with options: --unbuffered --
120926 17:45:39 innobackupex: Connected to database with mysql child process (pid=3382)
120926 17:45:41 innobackupex: Connection to database server closed
120926 17:45:41 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2012-09-26_17-45-39
innobackupex: Waiting for ibbackup (pid=3389) to suspend
innobackupex: Suspend file '/tmp/2012-09-26_17-45-39/xtrabackup_suspended'
xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
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 = 5242880
120926 17:45:41 InnoDB: Using Linux native AIO
120926 17:45:41 InnoDB: Warning: allocated tablespace 10, old maximum was 9
InnoDB: Error: log file ./ib_logfile0 is of different size 0 536870912 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 374.
======================================================================================
Reverted that change back and now it worked
raghu archie:~ [92:2]% sudo innobackupex /tmp
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
120926 17:47:03 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:03 innobackupex: Connected to database with mysql child process (pid=3406)
120926 17:47:09 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /tmp/2012-09-26_17-47-09
120926 17:47:09 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:09 innobackupex: Connected to database with mysql child process (pid=3432)
120926 17:47:11 innobackupex: Connection to database server closed
120926 17:47:11 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2012-09-26_17-47-09
innobackupex: Waiting for ibbackup (pid=3439) to suspend
innobackupex: Suspend file '/tmp/2012-09-26_17-47-09/xtrabackup_suspended'
xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
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 = 536870912
120926 17:47:11 InnoDB: Using Linux native AIO
120926 17:47:11 InnoDB: Warning: allocated tablespace 10, old maximum was 9
>> log scanned up to (1602118)
[01] Copying ./ibdata1 to /tmp/2012-09-26_17-47-09/ibdata1
[01] ...done
[01] Copying ./test/t1.ibd to /tmp/2012-09-26_17-47-09/./test/t1.ibd
[01] ...done
120926 17:47:15 innobackupex: Continuing after ibbackup has suspended
120926 17:47:15 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:15 innobackupex: Connected to database with mysql child process (pid=3453)
>> log scanned up to (1602118)
120926 17:47:17 innobackupex: Starting to lock all tables...
>> log scanned up to (1602118)
>> log scanned up to (1602118)
120926 17:47:27 innobackupex: All tables locked and flushed to disk
120926 17:47:27 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up file '/var/lib/mysql/sbtest/db.opt'
innobackupex: Backing up file '/var/lib/mysql/test/t.MYD'
innobackupex: Backing up file '/var/lib/mysql/test/t1.frm'
innobackupex: Backing up file '/var/lib/mysql/test/t.frm'
innobackupex: Backing up file '/var/lib/mysql/test/t.MYI'
innobackupex: Backing up files '/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files)
innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files)
120926 17:47:28 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
innobackupex: Resuming ibbackup
xtrabackup: The latest check point (for incremental): '1602118'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1602118)
xtrabackup: Transaction log of lsn (1602118) to (1602118) was copied.
120926 17:47:30 innobackupex: All tables unlocked
120926 17:47:30 innobackupex: Connection to database server closed
innobackupex: Backup created in directory '/tmp/2012-09-26_17-47-09'
innobackupex: MySQL binlog position: filename 'mysql-bin.000004', position 107
120926 17:47:30 innobackupex: completed OK!
Changed innodb_ log_file_ size = 512M to loose-innodb_ log_file_ size = 512M
sudo innobackupex /tmp
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
120926 17:45:33 innobackupex: Starting mysql with options: --unbuffered --
120926 17:45:33 innobackupex: Connected to database with mysql child process (pid=3355)
120926 17:45:39 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /tmp/2012- 09-26_17- 45-39
120926 17:45:39 innobackupex: Starting mysql with options: --unbuffered --
120926 17:45:39 innobackupex: Connected to database with mysql child process (pid=3382)
120926 17:45:41 innobackupex: Connection to database server closed
120926 17:45:41 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/tmp/ 2012-09- 26_17-45- 39 09-26_17- 45-39/xtrabacku p_suspended'
innobackupex: Waiting for ibbackup (pid=3389) to suspend
innobackupex: Suspend file '/tmp/2012-
xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461) data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 5242880 innobackupex line 374.
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
120926 17:45:41 InnoDB: Using Linux native AIO
120926 17:45:41 InnoDB: Warning: allocated tablespace 10, old maximum was 9
InnoDB: Error: log file ./ib_logfile0 is of different size 0 536870912 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
innobackupex: Error: ibbackup child process has died at /usr/bin/
======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ======= ==
Reverted that change back and now it worked
raghu archie:~ [92:2]% sudo innobackupex /tmp
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
120926 17:47:03 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:03 innobackupex: Connected to database with mysql child process (pid=3406)
120926 17:47:09 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".
innobackupex: Using mysql Ver 14.14 Distrib 5.5.27, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /tmp/2012- 09-26_17- 47-09
120926 17:47:09 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:09 innobackupex: Connected to database with mysql child process (pid=3432)
120926 17:47:11 innobackupex: Connection to database server closed
120926 17:47:11 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/tmp/ 2012-09- 26_17-47- 09 09-26_17- 47-09/xtrabacku p_suspended'
innobackupex: Waiting for ibbackup (pid=3439) to suspend
innobackupex: Suspend file '/tmp/2012-
xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461) data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 536870912 09-26_17- 47-09/ibdata1 09-26_17- 47-09/. /test/t1. ibd
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
120926 17:47:11 InnoDB: Using Linux native AIO
120926 17:47:11 InnoDB: Warning: allocated tablespace 10, old maximum was 9
>> log scanned up to (1602118)
[01] Copying ./ibdata1 to /tmp/2012-
[01] ...done
[01] Copying ./test/t1.ibd to /tmp/2012-
[01] ...done
120926 17:47:15 innobackupex: Continuing after ibbackup has suspended
120926 17:47:15 innobackupex: Starting mysql with options: --unbuffered --
120926 17:47:15 innobackupex: Connected to database with mysql child process (pid=3453)
>> log scanned up to (1602118)
120926 17:47:17 innobackupex: Starting to lock all tables...
>> log scanned up to (1602118)
>> log scanned up to (1602118)
120926 17:47:27 innobackupex: All tables locked and flushed to disk
120926 17:47:27 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI, mysql/sbtest/ db.opt' mysql/test/ t.MYD' mysql/test/ t1.frm' mysql/test/ t.frm' mysql/test/ t.MYI' mysql/performan ce_schema/ *.{frm, MYD,MYI, MRG,TRG, TRN,ARM, ARZ,CSM, CSV,opt, par}' (18 files) mysql/mysql/ *.{frm, MYD,MYI, MRG,TRG, TRN,ARM, ARZ,CSM, CSV,opt, par}' (72 files)
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up file '/var/lib/
innobackupex: Backing up files '/var/lib/
innobackupex: Backing up files '/var/lib/
120926 17:47:28 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files
innobackupex: Resuming ibbackup
xtrabackup: The latest check point (for incremental): '1602118'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1602118)
xtrabackup: Transaction log of lsn (1602118) to (1602118) was copied.
120926 17:47:30 innobackupex: All tables unlocked
120926 17:47:30 innobackupex: Connection to database server closed
innobackupex: Backup created in directory '/tmp/2012- 09-26_17- 47-09'
innobackupex: MySQL binlog position: filename 'mysql-bin.000004', position 107
120926 17:47:30 innobackupex: completed OK!