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
• Status: Can't repeat
• 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

Description:
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?