Xtrabackup 2.0.1 incremental backup don't drop table
Hello,
When I am doing full backup + incremental backup and restore it on another host I get orphan tables like table1 in the below log.
When I take the full backup, table1 was exist, but after a while when I took the incremental backup table1 was deleted (was dropped between the full and incremental operations). when I resorted the full + incremental on another host table1 wasn't drop properly, I expect it will be dropped after I restored the incremental and will be identical to the source DB.
note: no crash happened during the full and incremental backups.
is it a bug?
120729 23:55:42 InnoDB: Warning: trying to init to the tablespace memory cache
InnoDB: a tablespace 23837543 of name './DBname/
InnoDB: but a tablespace 23831965 of the same name
InnoDB: already exists in the tablespace memory cache!
InnoDB: We assume that InnoDB did a crash recovery, and you had
InnoDB: an .ibd file for which the table did not exist in the
InnoDB: InnoDB internal data dictionary in the ibdata files.
InnoDB: We assume that you later removed the .ibd and .frm files,
InnoDB: and are now trying to recreate the table. We now remove the
InnoDB: conflicting tablespace object from the memory cache and try
InnoDB: the init again.
Thanks,
Shay
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Shay Fox for more information if necessary.