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.
- 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)
- 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)]
[COLOR=#FF0000]If you use binary log and don’t use any hack of group commit,
[COLOR=#FF0000]the binary log position seems to be:
[COLOR=#FF0000]xtrabackup: ################################################## ######
[COLOR=#FF0000]xtrabackup: # !!WARNING!! #
[COLOR=#FF0000]xtrabackup: # The transaction log file is corrupted. #
[COLOR=#FF0000]xtrabackup: # The log was not applied to the intended LSN! #
[COLOR=#FF0000]xtrabackup: ################################################## ######
[COLOR=#FF0000]xtrabackup: The intended lsn is 79082747
[COLOR=#FF0000]xtrabackup: starting shutdown with innodb_fast_shutdown = 1