MySQL Forums
Forum List  »  Archive Storage Engine

Unable to repair/rebuild archive table with partition
Posted by: Andreas Thorstensson
Date: March 15, 2010 04:18AM

After a power failure I can't repair my archive tables.

Information below:

CREATE TABLE `archive_item` (
`ID` int(10) unsigned NOT NULL,
`url` char(40) NOT NULL default '',
`site_id` mediumint(8) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PARTITION BY HASH(site_id) PARTITIONS 64;

MariaDB [njuice]> check table archive_item;
+---------------------+-------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+-------+----------+-----------------------------+
| njuice.archive_item | check | error | Partition p0 returned error |
| njuice.archive_item | check | error | Corrupt |
+---------------------+-------+----------+-----------------------------+

MariaDB [njuice]> alter table archive_item rebuild partition p0;
ERROR 1034 (HY000): Incorrect key file for table 'archive_item'; try to repair it

MariaDB [njuice]> alter table archive_item repair partition p0;
+---------------------+--------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+-----------------------------+
| njuice.archive_item | repair | error | Partition p0 returned error |
| njuice.archive_item | repair | error | Corrupt |
+---------------------+--------+----------+-----------------------------+

MariaDB [njuice]> repair table archive_item;
+---------------------+--------+----------+-----------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+-----------------------------+
| njuice.archive_item | repair | error | Partition p0 returned error |
| njuice.archive_item | repair | error | Corrupt |
+---------------------+--------+----------+-----------------------------+

Is there any way to check the archive files on disk like with myisamchk? Any other suggestions?

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to repair/rebuild archive table with partition
8292
March 15, 2010 04:18AM


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.