Announcement

Announcement Module
Collapse
No announcement yet.

InnoDB: Error: cannot reset lsn's in table

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • InnoDB: Error: cannot reset lsn's in table

    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

  • #2
    Looks like this is a duplicate post of http://forum.percona.com/index.php?t=rview&goto=8077&amp ;th=2138

    Comment

    Working...
    X