myisam_recover fails to auto-repair all tables
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Michael Widenius |
Bug 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/
Aug 1 06:19:07 mx10 mysqld: 110801 6:19:07 [Warning] Checking table: './database/
Aug 1 06:24:22 mx10 mysqld: 110801 6:24:22 [Warning] Recovering table: './database/
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [Note] Retrying repair of: './database/
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] Couldn't repair table: mx_messages.
Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] mysqld: Table './database/
===
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.
Changed in maria: | |
assignee: | nobody → Michael Widenius (monty) |
milestone: | none → 5.2 |
Already fixed in MariaDB 5.2 some months ago