Home / server / Questions / 73249
Accepted
HeavyWave
Asked: 2009-10-11 06:32:57 +0800 CST

MySQL InnoDB unrecoverable crash

  • 772

Whenever I start MySQL server 5.1.33 or 5.1.40 (developers build) and try to read from one table the server crashes with this message in log files:

InnoDB: Error: (1500) Couldn't read the MAX(userFK) autoinc value from the index (PRIMARY).

I've upgraded to 5.1.40 per http://bugs.mysql.com/bug.php?id=44030 but I still can't read from the table, so I cannot recover it. I've started the server with innodb_force_recovery=1 but that didn't help either, REPAIR, CHECK or SELECT or any other command just crashes the server.

How can I repair the table so that it is readable again?

mysql

4 Answers

  1. Best Answer

    I think you either need to restore from a backup or pay Oracle lots of money. Sorry.

    • 1

  2. take a look at innodb-tools. maybe you'll have some luck with your data.

    • 0

  3. This looks like you need to restore from your latest backup.

    • 0

  4. Depending on how the data is corrupted you may be able to select around it with a where clause. You'll likely never recover all the data from the corrupted table but you may be able to back it up row by row.

    • 0