Bug #29591 myisam_recover from my.cnf doesn't work anymore
Submitted: 6 Jul 2007 7:03 Modified: 19 Jul 2007 8:25
Reporter: Nicolae Namolovan Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:5.1.17, 5.1. BK OS:Any
Assigned to: Ramil Kalimullin CPU Architecture:Any
Tags: myisam, recover

[6 Jul 2007 7:03] Nicolae Namolovan
In 5.1 on any myisam table crash, mysql don't even try to repair the table.

Have myisam_recover=BACKUP,FORCE in my.cnf.

Here what I got into application sql errors when some table crash:

) 145: Table './db/table#P#p1' is marked as crashed and should be repaired

It don't even try to repair it..

How to repeat:
Crash somehow some table, remember to have myisam_recover=BACKUP,FORCE in my.cnf, start the mysqld.
[6 Jul 2007 7:33] Sveta Smirnova
Thank you for the report.

Verified as described.
[19 Jul 2007 8:25] Sveta Smirnova
I can not repeat described behaviour with current development sources. There is record in the error log:

Version: '5.1.21-beta-debug'  socket: '/tmp/mysql_ssmirnova51.sock'  port: 33051  Source distribution
070719 10:22:04 [ERROR] /users/ssmirnova/build/mysql-5.1/libexec/mysqld: Table './test/bug29591' is marked as crashed and last (automatic?) repair failed
[19 Jul 2007 8:30] Ramil Kalimullin
Hi Nicolae!

Could you please check that the table is marked as crashed
*before* launching the server?