xtrabackup: taking backup while tables are droped and created breaks backup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Critical
|
Alexey Kopytov | ||
1.6 |
Fix Released
|
Critical
|
Alexey Kopytov | ||
Trunk |
Fix Released
|
Critical
|
Alexey Kopytov |
Bug Description
Hi,
taking a backup with innobackup/
with:
InnoDB: Error: tablespace id is 849127 in the data dictionary
InnoDB: but in file ./magento/
110221 12:17:52 InnoDB: Assertion failure in thread 140051784468208 in file fil/fil0fil.c line 726
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
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://
InnoDB: about forcing recovery.
innobackupex-1.5.1: Error: ibbackup child process has died at ./innobackupex-
The table catalog_
So innodbacup/
Regards
Erkan
Using latest stable 1.4 even if verson reports:
./innobackupex-
Version string '' contains invalid data; ignoring: '' at ./innobackupex-
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy.
All Rights Reserved.
Related branches
- Stewart Smith (community): Approve
-
Diff: 49 lines (+22/-0)1 file modifiedxtrabackup.c (+22/-0)
- Stewart Smith (community): Approve
-
Diff: 2266 lines (+476/-254)17 files modifiedpatches/innodb51.patch (+42/-41)
patches/innodb51_builtin.patch (+113/-37)
patches/innodb55.patch (+39/-35)
patches/xtradb51.patch (+38/-36)
patches/xtradb55.patch (+38/-36)
test/inc/common.sh (+9/-0)
test/t/bug722638.sh (+119/-0)
test/t/bug723097.sh (+2/-2)
test/t/bug810269.sh (+2/-4)
test/t/ib_csm_csv.sh (+4/-4)
test/t/ib_incremental.sh (+2/-2)
test/t/xb_export.sh (+3/-3)
test/t/xb_incremental.sh (+2/-2)
test/t/xb_incremental_compressed.sh (+2/-4)
test/t/xb_part_range.sh (+2/-2)
test/t/xb_partial.sh (+2/-2)
xtrabackup.c (+57/-44)
Changed in percona-xtrabackup: | |
assignee: | nobody → Valentine Gostev (core-longbow) |
Changed in percona-xtrabackup: | |
importance: | Undecided → High |
Changed in percona-xtrabackup: | |
status: | New → Confirmed |
Changed in percona-xtrabackup: | |
importance: | High → Critical |
status: | Confirmed → Triaged |
assignee: | Valentine Gostev (longbow) → nobody |
Changed in percona-xtrabackup: | |
milestone: | none → 1.7 |
Changed in percona-xtrabackup: | |
assignee: | nobody → Alexey Kopytov (akopytov) |
status: | Triaged → In Progress |
Changed in percona-xtrabackup: | |
status: | In Progress → Fix Committed |
Changed in percona-xtrabackup: | |
status: | Fix Committed → Fix Released |
We're getting hit by this one too. 5.1.47 with XtraBackup 1.4 rev 193