Not the answer you need?
Register and ask your own question!

Error on restoring specific table

omrinomrin EntrantInactive User Role Beginner
Hi,

I've have a problem when restoring specific table, and i'm not sure what's wrong because I've managed to do specific restores in the past
After the restore process:
1. Discard Tablespace
2. cp exp & ibd files
3. Import Tablespace

any query run against this table response with "Lost connection to mysql during query"

in the error log i see
"InnoDB: Error: tablespace id is 10 in the data dictionary
InnoDB: but in file ./db/table.ibd it is 968465!
160118 14:34:57 InnoDB: Assertion failure in thread 140720242185984 in file fil0fil.c line 778
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"


I'm using Percona-xtrabackup-2.1.8-733
The Source server is Percona - 5.5.29
The Destination server is Percona - 5.5.38

Thanks in advance
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.