Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
We're running MariaDB with in my.cnf "myisam_recover = BACKUP_ALL,FORCE". We regularly have a crashed table on servers that fail to auto-repair:
===
Aug 1 06:19:07 mx10 mysqld: 110801 6:19:07 [ERROR] mysqld: Table './database/test@002dtable' is marked as crashed and should be repaired
Aug 1 06:19:07 mx10 mysqld: 110801 6:19:07 [Warning] Checking table: './database/test@002dtable'
Aug 1 06:24:22 mx10 mysqld: 110801 6:24:22 [Warning] Recovering table: './database/test@002dtable'
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [Note] Retrying repair of: './database/test@002dtable' with keycache
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] Couldn't repair table: mx_messages.test-table
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] mysqld: Table './database/test@002dtable' is marked as crashed and last (automatic?) repair failed
===
We have no problems manually repairing the table with "REPAIR tablename". Log collection/a copy of such broken table has been reported some weeks ago already via the MariaDB FTP server and was picked up by Monty. Just never created an official ticket for it.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 819348
Re: myisam_recover fails to auto-repair all tables
Already fixed in MariaDB 5.2 some months ago