Comment 1 for bug 402884

Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

This behavior is related to the bugs of MySQL which are still not fixed....

e.g.
http://bugs.mysql.com/bug.php?id=41609
http://bugs.mysql.com/bug.php?id=45638
http://bugs.mysql.com/bug.php?id=45976

Basically, innodb temporary table and recovery may be not so compatible for now.
XtraBackup is depend on recovery function of built-in InnoDB and the bugs affect also to XtraBackup....

I think InnoDB should not log operation about temporary tables....
And should remove all temporary tables when recovery....
So, it may be from fundamental bug of InnoDB.....

Anyway, xtrabackup must continue operation by skipping the error.
(the ibd file is for temporary table, so it is not needed to recover... Nobody can use the table...)

I will fix to skip the error for now as first-aid.