Corrupt ARCHIVE tables failing to repair
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Medium
|
Michael Widenius |
Bug Description
We regularly have corrupt ARCHIVE engine tables that fail to repair:
=======
MariaDB [(none)]> database;
Database changed
MariaDB [database]> repair table table;
+------
| Table | Op | Msg_type | Msg_text |
+------
| database.table | repair | error | Corrupt |
+------
1 row in set (3.92 sec)
MariaDB [database]>
=======
I'm unsure what causes the corruption, but a repair shouldn't be failing I presume?
I'll upload a copy of an example table to FTP.
on irc:
<dreas> Basically if you kill MariaDB whilst it's writing to an archive table, you can throw it away afterwards