xtrabackup prints warnings for tables, not included into partial backup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Wishlist
|
Sergei Glushchenko | ||
2.2 |
Fix Released
|
Wishlist
|
Sergei Glushchenko | ||
2.3 |
Fix Released
|
Wishlist
|
Sergei Glushchenko |
Bug Description
When preparing partial backup xtrabackup prints warnings for tables, not including into it:
InnoDB: Table db2/t1 in the InnoDB data dictionary has tablespace id 8, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
How to repeat.
1. Start MTR as:
./mtr --start innodb --mysqld=
2. Connect to it and create few tables and databases:
use test;
create table t1(f1 int)engine=innodb;
insert into t1 values(1);
create database db1;
use db1;
create table t1(f1 int)engine=innodb;
insert into t1 values(1);
create database db2;
use db2;
create table t1(f1 int)engine=innodb;
insert into t1 values(1);
3. Make partial backup:
~/build/
4. Prepare it, observe extra warnings:
sveta@linux-
/home/sveta/
xtrabackup: auto-enabling --innodb-
xtrabackup: cd to /home/sveta/
xtrabackup: This target seems to be not prepared yet.
xtrabackup: xtrabackup_logfile detected: size=2097152, start_lsn=(1646642)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
InnoDB: Using atomics to ref count buffer pool pages
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Memory barrier is not used
InnoDB: Compressed tables use zlib 1.2.8
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, size = 100.0M
InnoDB: Completed initialization of buffer pool
InnoDB: Highest supported file format is Barracuda.
InnoDB: The log sequence numbers 1625977 and 1625977 in ibdata files do not match the log sequence number 1646642 in the ib_logfiles!
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages
InnoDB: from the doublewrite buffer...
InnoDB: Table db2/t1 in the InnoDB data dictionary has tablespace id 8, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table mysql/innodb_
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table mysql/innodb_
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table mysql/slave_
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table mysql/slave_
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table mysql/slave_
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: Table test/t1 in the InnoDB data dictionary has tablespace id 6, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files? This may also be a table created with CREATE TEMPORARY TABLE whose .ibd and .frm files MySQL automatically removed, but the table still exists in the InnoDB internal data dictionary.
InnoDB: It will be removed from the data dictionary.
InnoDB: Please refer to
InnoDB: http://
InnoDB: for how to resolve the issue.
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.22 started; log sequence number 1646642
xtrabackup: export option is specified.
xtrabackup: export metadata of table 'db1/t1' to file `./db1/t1.exp` (1 indexes)
xtrabackup: name=GEN_
[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
xtrabackup: starting shutdown with innodb_
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 1655621
Suggested fix: suppress these extra warnings.
tags: | added: contribution |
The filter options (like, --databases=db1) could be used to filter out messages to unrelated tables.