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

InnoDB: Error: cannot reset lsn's in table

viswajviswaj EntrantCurrent User Role Beginner
Getting the following error, while importing the innodb table data

InnoDB: of table `test`.`test_table`.
120313 7:59:04 InnoDB: Error: you are trying to IMPORT a tablespace
InnoDB: `test`.`test_table`, though you have not called DISCARD on it yet
InnoDB: during the lifetime of the mysqld process!
120313 7:59:50 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
120313 7:59:50 InnoDB: Error: trying to open a table, but could not
InnoDB: open the tablespace file './test/test_table.ibd'!
120313 7:59:50 InnoDB: Error: cannot reset lsn's in table `test`.`test_table`
InnoDB: in ALTER TABLE ... IMPORT TABLESPACE

Regards,
Viswa.J

Comments

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.