Percona XtraBackup moved to https://jira.percona.com/projects/PXB

Missing space_id from *.ibd.meta Leads to Assertion

Bug #1112224 reported by Jervin R on 2013-02-01

This bug affects 2 people

	Status	Importance	Assigned to	Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB	Fix Released	Low	Sergei Glushchenko	Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.1-pre-initial-release
2.0	Fix Released	Low	Sergei Glushchenko	Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.0.7
2.1	Fix Released	Low	Sergei Glushchenko	Percona XtraBackup moved to https://jira.percona.com/projects/PXB 2.1-pre-initial-release

Bug Description

The backup set was taken with 2.0.1 and using 2.0.5 to prepare.

xtrabackup: page size for /data2/MBS_BACKUPS/Restore/20130130/xxx_xxx_xxx/xxxxxx_xxx_xxx.ibd.delta is 16384 bytes
130131 22:29:43 InnoDB: Assertion failure in thread 140558481557248 in file xtrabackup.c line 5981
InnoDB: Failing assertion: space_id != ULINT_UNDEFINED
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/innobackupex line 381.

# ~ > cat /data2/MBS_BACKUPS/Restore/failed/20130130/xxx_xxx_xxx/xxxxxx_xxx_xxx.ibd.meta
page_size = 16384

Related branches

lp:~sergei.glushchenko/percona-xtrabackup/xb21-bug1112224

Merged into lp:percona-xtrabackup/2.1 at revision 521

Alexey Kopytov (community): Approve on 2013-03-18

George Ormond Lorch III (community): Approve (g2) on 2013-02-25

lp:~sergei.glushchenko/percona-xtrabackup/xb20-bug1112224

Merged into lp:percona-xtrabackup/2.0 at revision 520

Alexey Kopytov (community): Approve on 2013-03-18

George Ormond Lorch III: Pending (g2) requested 2013-03-18

Superseded for merging into lp:percona-xtrabackup/2.1

Alexey Kopytov (community): Needs Fixing on 2013-03-18

George Ormond Lorch III (community): Approve (g2) on 2013-02-25

Revision history for this message

Jervin R (revin) wrote on 2013-02-01:

I suppose this is to be invalid since some other metadata has been introduced > 2.0.1 where on 2.0.1 there was only page_size. So the workaround is to restore with the same version.

Revision history for this message

Sergei Glushchenko (sergei.glushchenko) wrote on 2013-02-01:

More likely RENAME TABLE has been performed between full and incremental backups. The only improvement we can do in this case is to print more descriptive error message before exit.