# Xtrabackup error   when backup mysql 5.5.9  about   data dictionary

**URL:** <https://forums.percona.com/t/xtrabackup-error-when-backup-mysql-5-5-9-about-data-dictionary/2153>\
**Category:** Percona XtraBackup\
**Created:** [June 12, 2011, 10:13pm UTC](https://forums.percona.com/t/xtrabackup-error-when-backup-mysql-5-5-9-about-data-dictionary/2153 "2011-06-12T22:13:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![babyyellow](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@babyyellow](https://forums.percona.com/u/babyyellow)\
**Post date:** [June 12, 2011, 10:13pm UTC](https://forums.percona.com/t/xtrabackup-error-when-backup-mysql-5-5-9-about-data-dictionary/2153/1 "2011-06-12T22:13:17Z")

</div>

during xtrabackup ( innobackupex-1.5.1 binary , mysql 5.5.9 file-format=Barracuda)

aplications do some action like truncate table

xtrabackup export some error :

[01] Copying ./cnt\_it/cnt\_goals\_abandon\_201109.ibd  
to /usr/local/mysql/crontab/cnt\_it/backup/innodb/full/2011-06-1 3\_10-10-25/cnt\_it/cnt\_goals\_abandon\_201109.ibd  
[01] …done  
[01] Copying ./cnt\_it/cnt\_referrer\_search\_keyworInnoDB: Error: tablespace id is 46495 in the data dictionary  
InnoDB: but in file ./cnt\_it/cnt\_referrer\_summary\_work.ibd it is 46506!  
110613 10:36:28 InnoDB: Assertion failure in thread 1205774656 in file fil/fil0fil.c line 732  
InnoDB: We intentionally generate a memory trap.  
InnoDB: Submit a detailed bug report to [http://bugs.mysql.com](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: [URL=“http&#58;&#47;&#47;[dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html](http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html)”] [http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html[/URL]](http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html%5B/URL%5D)  
InnoDB: about forcing recovery.  
d\_201107.ibd  
to /usr/local/mysql/crontab/cnt\_it/backup/innodb/full/2011-06-1 3\_10-10-25/cnt\_it/cnt\_referrer\_search\_keyword\_201107.ibd  
[01] …done  
[01] Copying ./cnt\_it/cnt\_goals\_referrer\_201205.ibd  
to /usr/local/mysql/crontab/cnt\_it/backup/innodb/full/2011-06-1 3\_10-10-25/cnt\_it/cnt\_goals\_referrer\_201205.ibd  
[01] …done  
./backup.sh: line 109: 12048 give up xtrabackup --defaults-file=$CNF --backup --target-dir=$BACKUP/$ENGINE/full/$day --datadir=$DATADIR

but if we stop the aplications and buckup mysql ,it will do backup successfully

is it a bug ?

any info is great ,thank you !

---

<div class="post-metadata">

**Author:** ![babyyellow](https://avatars.discourse-cdn.com/v4/letter/b/c37758/32.png) [@babyyellow](https://forums.percona.com/u/babyyellow)\
**Post date:** [June 13, 2011, 3:18am UTC](https://forums.percona.com/t/xtrabackup-error-when-backup-mysql-5-5-9-about-data-dictionary/2153/2 "2011-06-13T03:18:22Z")

</div>

it is a bug

bug0:02.26 kblockd/0 41 root 10 -5 0 0 0 S 0.0 0.0 0:04.94 kblockd/1 42 root 14 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
