在前几天的一次常规备份恢复过程中,出现了不能恢复的情况
数据库版本:5.7.11
xtrabackup版本:2.4.1
报错情况:
InnoDB: Ignoring data file './wangwangwang/miaomiao.ibd' with space ID 1871, since the redo log references ./wangwangwang/miaomiao.ibd with space ID 1868. InnoDB: Ignoring data file './wangwangwang/miaomiao.ibd' with space ID 1869. Another data file called ./wangwangwang/#sql-ib7386-389430697.ibd exists with the same space ID. InnoDB: Cannot rename './wangwangwang/#sql-ib7386-389430697.ibd' to './wangwangwang/miaomiao.ibd' for space ID 1869 because the target file exists. Remove the target file and try again. InnoDB: Cannot replay file rename. Remove either file and try again. InnoDB: Plugin initialization aborted with error Generic error xtrabackup: innodb_init(): Error occured.
查看报错及事后询问程序员得知,当时应该是在进行表的rename操作
解决:
按照提示,删除
./wangwangwang/miaomiao.ibd
文件后,备份恢复仍失败,未找到解决办法,
最后还是重新备份了一份,没有问题
备份时还有哪些操作会造成备份不能恢复的情况呢?
转载于:https://blog.51cto.com/amnesiasun/1866778