Bug #69428 not all tables repaired with --myisam-recover=FORCE

• Submitted: 7 Jun 2013 17:21
• Modified: 21 Aug 2014 19:20
• Reporter: Jan F
• Status: No Feedback
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 5.5.31
• OS: Linux
• CPU Architecture: Any

[7 Jun 2013 17:21] Jan F

Description:
My server is started with --myisam-recover=FORCE

After a crash not all myisam tables are automaticly repaired. titanist_nf/cms_cmsplugin is not repaired at all. I've seen this also with other tables on other mysqld servers.
Manualy executing REPAIR TABLE titanist_nf.cms_cmsplugin fixes table and only returns repair status OK

How to repeat:
130607 18:56:22 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 18:56:24 [ERROR] mysqld: Table './krzysa_forumC49/phpbb_topics_track' is marked as crashed and should be repaired
130607 18:56:24 [Warning] Checking table:   './krzysa_forumC49/phpbb_topics_track'
130607 18:56:34 [ERROR] mysqld: Table './krzysa_forumC49/phpbb_topics_watch' is marked as crashed and should be repaired
130607 18:56:34 [Warning] Checking table:   './krzysa_forumC49/phpbb_topics_watch'
130607 18:56:45 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 18:57:31 [ERROR] mysqld: Table './gdlug_laguitarra/workshop' is marked as crashed and should be repaired
130607 18:57:31 [Warning] Checking table:   './gdlug_laguitarra/workshop'
130607 18:58:30 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:00:21 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:01:13 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:01:21 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:01:46 [ERROR] mysqld: Table './pmlocek_blog/wp_options' is marked as crashed and should be repaired
130607 19:01:46 [Warning] Checking table:   './pmlocek_blog/wp_options'
130607 19:01:47 [ERROR] mysqld: Table './pmlocek_blog/wp_comments' is marked as crashed and should be repaired
130607 19:01:47 [Warning] Checking table:   './pmlocek_blog/wp_comments'
130607 19:01:47 [ERROR] mysqld: Table './pmlocek_blog/wp_wassup' is marked as crashed and should be repaired
130607 19:01:47 [Warning] Checking table:   './pmlocek_blog/wp_wassup'
130607 19:01:47 [ERROR] mysqld: Table './pmlocek_blog/wp_wassup_tmp' is marked as crashed and should be repaired
130607 19:01:47 [Warning] Checking table:   './pmlocek_blog/wp_wassup_tmp'
130607 19:01:49 [ERROR] mysqld: Table './zeloslaw_gondor/phpbb2_search_wordlist' is marked as crashed and should be repaired
130607 19:02:26 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:02:43 [ERROR] mysqld: Table './titanist_nf/cms_cmsplugin' is marked as crashed and should be repaired
130607 19:02:51 [ERROR] mysqld: Table './tuner_foxstudio/wp_options' is marked as crashed and should be repaired
130607 19:02:51 [Warning] Checking table:   './tuner_foxstudio/wp_options'

[21 Jul 2014 19:20] Sveta Smirnova

Thank you for the report.

Please provide your full configuration file and, if possible, corrupted files of table cms_cmsplugin

[22 Aug 2014 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".