XtraBackup 2.4.7 not backing up remote file per table tablespaces

[Nathan Huff]

When a table is created with the DATA DIRECTORY option xtrabackup backs up the frm and isl files, but not the ibd file. Because it didn't back it up it also can't restore it. I have attached the output of a session showing the steps to reproduce.

[Jericho Rivera (jericho-rivera)]

Thank you for the bug report.

The .ibd file was never copied during the --backup phase
170630 22:41:29 [01] Copying ./xtra/db.opt to /root/backup/xtra/db.opt
170630 22:41:29 [01] ...done
170630 22:41:29 [01] Copying ./xtra/tx.frm to /root/backup/xtra/tx.frm
170630 22:41:29 [01] ...done
170630 22:41:29 [01] Copying ./xtra/tx.isl to /root/backup/xtra/tx.isl
170630 22:41:29 [01] ...done

As expected on those files were also moved during --copy-back
170630 23:08:39 [01] Copying ./xtra/db.opt to /srv/mysqldata/data/xtra/db.opt
170630 23:08:39 [01] ...done
170630 23:08:39 [01] Copying ./xtra/tx.frm to /srv/mysqldata/data/xtra/tx.frm
170630 23:08:39 [01] ...done
170630 23:08:39 [01] Copying ./xtra/tx.isl to /srv/mysqldata/data/xtra/tx.isl
170630 23:08:39 [01] ...done

[Jericho Rivera (jericho-rivera)]

In version 2.3.8 it copies and restore the ibd file correctly so marking as invalid for 2.3 series.

170705 03:47:56 [01] Copying /data/tmp/test/txr.ibd to /root/backup/test/txr.ibd
170705 03:47:56 [01] ...done

170705 03:49:34 [01] Copying ./test/txr.ibd to /data/tmp/test/txr.ibd
170705 03:49:34 [01] ...done

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-xtrabackup/pull/388

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-504