[root@mysql-bcc01 sql]# innobackupex --apply-log --export 2016-10-08_17-53-09
161008 17:53:50 innobackupex: Starting the apply-log operation
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex
prints"completed OK!".
innobackupex version2.4.4 based on MySQL server 5.7.13 Linux (x86_64) (revision id: df58cf2)
xtrabackup: auto-enabling --innodb-file-per-table due to the --export option
xtrabackup: cd to/data0/sql/2016-10-08_17-53-09xtrabackup: This target seems to be not prepared yet.
InnoDB: Number of pools:1xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(802528374)
xtrabackup: using the following InnoDB configurationforrecovery:
xtrabackup: innodb_data_home_dir=.
xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend
xtrabackup: innodb_log_group_home_dir=.
xtrabackup: innodb_log_files_in_group= 1xtrabackup: innodb_log_file_size= 8388608xtrabackup: using the following InnoDB configurationforrecovery:
xtrabackup: innodb_data_home_dir=.
xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend
xtrabackup: innodb_log_group_home_dir=.
xtrabackup: innodb_log_files_in_group= 1xtrabackup: innodb_log_file_size= 8388608xtrabackup: Starting InnoDB instanceforrecovery.
xtrabackup: Using104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: PUNCH HOLE support not available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __sync_synchronize() is usedformemory barrier
InnoDB: Compressed tables use zlib1.2.3InnoDB: Number of pools:1InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size= 100M, instances = 1, chunk size =100M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority:-20InnoDB: Highest supportedfileformat is Barracuda.
InnoDB: The log sequence number2342986 in the system tablespace does not match the log sequence number 802528374 in the ib_logfiles!InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.
InnoDB: Doing recovery: scanned up to log sequence number802528374 (0%)
InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003InnoDB: Creating shared tablespacefortemporary tables
InnoDB: Settingfile './ibtmp1' size to 12 MB. Physically writing the file full; Please wait...
InnoDB: File'./ibtmp1' size is now 12MB.
InnoDB:96 redo rollback segment(s) found. 1redo rollback segment(s) are active.
InnoDB:32 non-redo rollback segment(s) are active.
InnoDB:5.7.13 started; log sequence number 802528374xtrabackup: export option is specified.
xtrabackup: export metadata of table'test/t1' to file `./test/t1.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=32, page=3xtrabackup: export metadata of table'mysql/slave_relay_log_info' to file `./mysql/slave_relay_log_info.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=19, page=3xtrabackup: export metadata of table'mysql/innodb_index_stats' to file `./mysql/innodb_index_stats.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=18, page=3xtrabackup: export metadata of table'mysql/slave_worker_info' to file `./mysql/slave_worker_info.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=21, page=3xtrabackup: export metadata of table'mysql/innodb_table_stats' to file `./mysql/innodb_table_stats.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=17, page=3xtrabackup: export metadata of table'mysql/slave_master_info' to file `./mysql/slave_master_info.exp` (1indexes)
xtrabackup: name=PRIMARY, id.low=20, page=3InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003xtrabackup: starting shutdown with innodb_fast_shutdown= 0InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Failed tofind tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number2 in a fileoperation.
InnoDB: The error means the system cannotfindthe path specified.
InnoDB: Cannot open datafilefor read-only: './test/t2.ibd' OS error: 71InnoDB: Operating system error number2 in a fileoperation.
InnoDB: The error means the system cannotfindthe path specified.
InnoDB: Could notfind a valid tablespace file for `test/t2`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
InnoDB: Shutdown completed; log sequence number 802528393InnoDB: Number of pools:1xtrabackup: using the following InnoDB configurationforrecovery:
xtrabackup: innodb_data_home_dir=.
xtrabackup: innodb_data_file_path=ibdata1:512M:autoextend
xtrabackup: innodb_log_group_home_dir=.
xtrabackup: innodb_log_files_in_group= 3xtrabackup: innodb_log_file_size= 104857600InnoDB: PUNCH HOLE support not available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __sync_synchronize() is usedformemory barrier
InnoDB: Compressed tables use zlib1.2.3InnoDB: Number of pools:1InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size= 100M, instances = 1, chunk size =100M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority:-20InnoDB: Setting logfile ./ib_logfile101 size to 100MB
InnoDB: ProgressinMB:100InnoDB: Setting logfile ./ib_logfile1 size to 100MB
InnoDB: ProgressinMB:100InnoDB: Setting logfile ./ib_logfile2 size to 100MB
InnoDB: ProgressinMB:100InnoDB: Renaming logfile ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=802528393InnoDB: Highest supportedfileformat is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn802528780InnoDB: Doing recovery: scanned up to log sequence number802528789 (0%)
InnoDB: Doing recovery: scanned up to log sequence number802528789 (0%)
InnoDB: Database was not shutdown normally!InnoDB: Starting crash recovery.
InnoDB: xtrabackup: Last MySQL binlogfile position 2987, file name mysql-bin.000003InnoDB: Removed temporary tablespace datafile: "ibtmp1"InnoDB: Creating shared tablespacefortemporary tables
InnoDB: Settingfile './ibtmp1' size to 12 MB. Physically writing the file full; Please wait...
InnoDB: File'./ibtmp1' size is now 12MB.
InnoDB:96 redo rollback segment(s) found. 1redo rollback segment(s) are active.
InnoDB:32 non-redo rollback segment(s) are active.
InnoDB:5.7.13 started; log sequence number 802528789InnoDB: Failed tofind tablespace for table `test`.`t2` in the cache. Attempting to load the tablespace with space id 113InnoDB: Operating system error number2 in a fileoperation.
InnoDB: The error means the system cannotfindthe path specified.
InnoDB: Cannot open datafilefor read-only: './test/t2.ibd' OS error: 71InnoDB: Operating system error number2 in a fileoperation.
InnoDB: The error means the system cannotfindthe path specified.
InnoDB: Could notfind a valid tablespace file for `test/t2`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
xtrabackup: starting shutdown with innodb_fast_shutdown = 0InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number802528808
161008 17:53:57 completed OK!