MySQL Forums
Forum List  »  Data Recovery

Table is marked as crashed and repair failed!
Posted by: Abdulrahman Masrani
Date: January 11, 2009 06:37AM

hello,

I have a problem in a table in my database, and here's its structure. it contains about 4000 records.
CREATE TABLE `t_node_revisions` (
 `nid` int(10) unsigned NOT NULL,
  `vid` int(10) unsigned NOT NULL,
  `uid` int(11) NOT NULL default '0',
  `title` varchar(128) NOT NULL default '',
  `body` longtext NOT NULL,
  `teaser` longtext NOT NULL,
  `log` longtext NOT NULL,
 `timestamp` int(11) NOT NULL default '0',
  `format` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vid`),
  KEY `nid` (`nid`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

the problem
mysql>ANALYZE TABLE `t_node_revisions`;
Quote

d60476544.t_node_revisions analyze error Table './d60476544/t_node_revisions' is marked as crashed and last (automatic?) repair failed

This table actually crashed while I was backing up the table from a ssh client.

I tried desperately to repair it, but unfortunately I failed.

here's what I tried.
mysql> REPAIR TABLE `t_node_revisions` USE_FRM;
the error msg:
Quote

d60476544.t_node_revisions repair info Wrong bytesec: 217-130-217 at 15946488; Skipped
d60476544.t_node_revisions repair info Found block that points outside data file at 15946604
d60476544.t_node_revisions repair error Not enough memory for blob at 15946608 (need 182026713)
d60476544.t_node_revisions repair info Wrong bytesec: 217-130-217 at 15946488; Skipped
d60476544.t_node_revisions repair info Found block that points outside data file at 15946604
d60476544.t_node_revisions repair error Not enough memory for blob at 15946608 (need 182026713)
d60476544.t_node_revisions repair status Operation failed

I tried mysqlchk in the ssh client to repair the table.
mysqlcheck -r -u username -ppassword d60476544 t_node_revisions
the error msg:
Quote

d60476544.t_node_revisions
info : Wrong bytesec: 217-130-217 at 15946488; Skipped
info : Wrong bytesec: 217-130-217 at 15946488; Skipped
info : Found block that points outside data file at 15946604
error : Not enough memory for blob at 15946608 (need 182026713)
status : Operation failed

I can't use myisamchk cause it's not allowed by the server.

I can't truncate or drop the table cause it contains almost everything in my site.

I am using drupal as CMS.


I really appreciate any suggestion. Thanks for your help.

Options: ReplyQuote


Subject
Views
Written By
Posted
Table is marked as crashed and repair failed!
73520
January 11, 2009 06:37AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.