List:General Discussion« Previous MessageNext Message »
From:Rick James Date:February 1 2013 7:17pm
Subject:RE: Can't drop table after crash
View as plain text  
Percona or SkySQL may be able to step in and repair it (for $$$).

For the future, switching to XtraDB (as a plugin or as included in MariaDB) may give you more resilience to such crashes.

> -----Original Message-----
> From: Larry Martell [mailto:larry.martell@stripped]
> Sent: Friday, February 01, 2013 10:49 AM
> To: mysql mailing list
> Subject: Can't drop table after crash
> 
> We had a power hit and when the server came back we had InnoDB
> corruption. (I can't get out to the internet from the system with the
> db so can I can't paste the exact text in here). The message was about
> log sequences numbers being in the future. We were able to dump the
> affected tables, but when we tried to restore them we were not able to
> drop the old tables. When we tried the server crashed with:
> 
> InnoDB: Failing assertion not_full_n_used >= descr_n_used
> 
> We did try booting with innodb_force_recovery at all levels from 1 to
> 6 with the same results.
> 
> Anyone have any ideas on what we can do to recover?
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql

Thread
Can't drop table after crashLarry Martell1 Feb
  • RE: Can't drop table after crashRick James1 Feb