Not the answer you need?
Register and ask your own question!

Xtrabackup prepare warning

jmhongjmhong EntrantCurrent User Role Beginner
Hi,
I tried to compressed backup & recovery test.
The backup compression was successfully finished. But, When I execute "prepare" the backup-set, it was failed.
(It could not found binary log file and position. )

- MySQL version is 5.6.10
- xtrabackup-2.0.6

I hope someone who know about this warning, help me.


1. When I tried backup, I executed this command.

./percona-xtrabackup-2.0.6/bin/xtrabackup_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress_Back --backup --compress

./xtrabackup_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data1/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir =
xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
xtrabackup: innodb_log_group_home_dir = /data1/mysqllog
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 225443840
2013-05-13 10:49:19 2ab938f72f90 InnoDB: Using Linux native AIO
>> log scanned up to (79082747)
[01] Compressing /data1/ibdata1 to /backup1/Compress_Back/ibdata1.qp
>> log scanned up to (79082747)
>> log scanned up to (79082747)
>> log scanned up to (79082747)
>> log scanned up to (79082747)
>> log scanned up to (79082747)
>> log scanned up to (79082747)
[01] ...done
[01] Compressing ./hong/ttt.ibd to /backup1/Compress_Back/./hong/ttt.ibd.qp
>> log scanned up to (79082747)
[01] ...done
[01] Compressing ./hong/xxx.ibd to /backup1/Compress_Back/./hong/xxx.ibd.qp
[01] ...done
[01] Compressing ./mysql/slave_worker_info.ibd to /backup1/Compress_Back/./mysql/slave_worker_info.ibd.qp
[01] ...done
[01] Compressing ./mysql/slave_master_info.ibd to /backup1/Compress_Back/./mysql/slave_master_info.ibd.qp
[01] ...done
[01] Compressing ./mysql/slave_relay_log_info.ibd to /backup1/Compress_Back/./mysql/slave_relay_log_info.ibd.qp
[01] ...done
[01] Compressing ./mysql/innodb_index_stats.ibd to /backup1/Compress_Back/./mysql/innodb_index_stats.ibd.qp
[01] ...done
[01] Compressing ./mysql/innodb_table_stats.ibd to /backup1/Compress_Back/./mysql/innodb_table_stats.ibd.qp
[01] ...done
xtrabackup: The latest check point (for incremental): '79082747'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (79082747)


2. execute prepare command, it was failed.

./percona-xtrabackup-2.0.6/bin/xtrabackup_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress_Back --prepare
./xtrabackup_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86_64) (revision id: undefined)
xtrabackup: cd to /backup1/Compress_Back
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 225443840
2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 3
xtrabackup: innodb_log_file_size = 225443840
2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Progress in MB: 100 200
InnoDB: Progress in MB: 100 200
InnoDB: Progress in MB: 100 200

[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:

xtrabackup: ################################################## ######
xtrabackup: # !!WARNING!! #
xtrabackup: # The transaction log file is corrupted. #
xtrabackup: # The log was not applied to the intended LSN! #
xtrabackup: ################################################## ######
xtrabackup: The intended lsn is 79082747
xtrabackup: starting shutdown with innodb_fast_shutdown = 1

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.