记一次使用innobackupex做全备恢复失败的经历

记一次使用innobackupex做全备恢复失败的经历

在分别使用innobackupex --apply-log和innobackupex --copy-back命令成功后，相关信息如下：

[root@node3 app]#innobackupex --apply-log /app/backup/2018-05-07_22-49-42/
180507 22:57:49 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 version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
xtrabackup: cd to /app/backup/2018-05-07_22-49-42/
xtrabackup: This target seems to be not prepared yet.
InnoDB: Number of pools: 1
xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(6986796)
xtrabackup: using the following InnoDB configuration for recovery:
…… ……
InnoDB: 5.7.13 started; log sequence number 6987285
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 6987304
180507 22:57:54 completed OK!

[root@node3 app]#innobackupex --copy-back /app/backup/2018-05-07_22-49-42/
180507 22:58:36 innobackupex: Starting the copy-back operation

IMPORTANT: Please check that the copy-back run completes successfully.
           At the end of a successful copy-back run innobackupex
           prints "completed OK!".

innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4)
180507 22:58:36 [01] Copying ib_logfile0 to /var/lib/mysql/ib_logfile0
180507 22:58:36 [01]        ...done
…… ……
180507 22:58:38 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
180507 22:58:38 [01]        ...done
180507 22:58: