Innodb general tablespace file missing from backupdir
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB | Status tracked in 2.4 | |||||
2.4 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
Test Tree:
https:/
I have created general tablespace file in default datadir as:
mysql> CREATE TABLESPACE `sbtest2` ADD DATAFILE 'sbtest2.ibd' Engine=InnoDB;
Query OK, 0 rows affected (0,00 sec)
mysql> show create table sbtest1;
| sbtest1 | CREATE TABLE `sbtest1` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k` (`k`)
) /*!50100 TABLESPACE `innodb_
mysql> create table sbtest2 like sbtest1;
Query OK, 0 rows affected (0,01 sec)
mysql> insert into sbtest2 select * from sbtest1;
Query OK, 25661594 rows affected (7 min 52,96 sec)
Records: 25661594 Duplicates: 0 Warnings: 0
mysql> alter table sbtest2 tablespace = sbtest2;
Query OK, 0 rows affected (2 min 41,21 sec)
Records: 0 Duplicates: 0 Warnings: 0
[root@mysql-57 ~]# ls -lh /var/lib/mysql | grep sbtest2
-rw-r-----. 1 mysql mysql 6,7G янв 8 06:40 sbtest2.ibd
After taking backup:
[root@mysql-57 bin]# ./xtrabackup --defaults-
General Tablespace file 'sbtest2.ibd' is missing from backup directory:
[root@mysql-57 ~]# ls /home/backup_
backup-my.cnf bck dbtest ib_buffer_pool ibdata1 mysql performance_schema sys xtrabackup_
And the SAME thing is with outside general tablespace:
mysql> CREATE TABLESPACE `sbtest3` ADD DATAFILE '/var/lib/
Query OK, 0 rows affected (0,02 sec)
mysql> alter table sbtest2 tablespace = sbtest3;
Query OK, 0 rows affected (3 min 23,50 sec)
Records: 0 Duplicates: 0 Warnings: 0
# dropping old tablespace
mysql> drop tablespace sbtest2;
Query OK, 0 rows affected (0,13 sec)
There should be sbtest3.isl file in MySQL datadir:
[root@mysql-57 mysql]# ls | grep sbtest3.isl
sbtest3.isl
Also:
[root@mysql-57 ~]# ls -lh /var/lib/
total 6,7G
-rw-r-----. 1 mysql mysql 6,7G янв 8 07:03 sbtest3.ibd
Taking backup again and checking for those files:
[root@mysql-57 ~]# ls /home/backup_
backup-my.cnf bck dbtest ib_buffer_pool ibdata1 mysql performance_schema sys xtrabackup_
as well as sbtest3.ibd file missing too.
summary: |
- Innodb general tablespace file missing in backupdir + Innodb general tablespace file missing from backupdir |
Please test with latest branch