Percona XtraBackup moved to https://jira.percona.com/projects/PXB

Bug #664128
Comment #5

Comment 5 for bug 664128

Revision history for this message

Raghavendra D Prabhu (raghavendra-prabhu) wrote on 2012-09-26:

Changed innodb_log_file_size = 512M to loose-innodb_log_file_size = 512M

sudo innobackupex /tmp

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

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: 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

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

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!