Bug #39541 CHECK TABLE on information_schema myisam tables produces error
Submitted: 19 Sep 2008 16:39 Modified: 8 Dec 2008 17:05
Reporter: Cary Petterborg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.0.67, 5.0 bzr OS:Any
Assigned to: Sergey Glukhov CPU Architecture:Any
Tags: CHECK TABLE, myisam, regression, Table upgrade required
Triage: Triaged: D3 (Medium)

[19 Sep 2008 16:39] Cary Petterborg
Description:
If CHECK TABLE is run on any of the MyISAM tables in the information_schema database, it produces an error and the msg_text says "Table upgrade required". There is nothing that can be done to fix this error, and it produces the error even when the server has been freshly installed on a freshly installed OS. I have not tried it on 5.0.51, but it doesn't appear on 5.0.45.

There don't seem to be any issues otherwise, just that this reports an error. We have been using a script (taken originally from the CHECK TABLE syntax manual page comments) that checks all databases. When we upgraded a test and a stage box to 5.0.67 they started to produce this error on the daily check being run. We have changed our script to exclude information_schema from the list of databases being checked, but it seems that it should not be getting this type of error.

How to repeat:
use information_schema;
check table routines;

Suggested fix:
Perhaps the database is slightly different than before, and so the check is failing. Either the check should be fixed to accommodate the difference, the database format should be fixed to be in line with the check, or if the check is really irrelevant, maybe it should just not report an error or report that it is not necessary to do a check table on the information_schema tables (making that a warning, not an error).
[19 Sep 2008 18:54] Sveta Smirnova
Thank you for the report.

Verified as described.
[29 Oct 2008 12:46] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/57305

2714 Sergey Glukhov	2008-10-29
      Bug#39541 CHECK TABLE on information_schema myisam tables produces error
      issue 'The storage engine for the table doesn't support check' note for I_S tables
[13 Nov 2008 13:14] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/58636

2712 Sergey Glukhov	2008-11-13
      Bug#39541 CHECK TABLE on information_schema myisam tables produces error
      issue 'The storage engine for the table doesn't support check' note for I_S tables
[13 Nov 2008 13:17] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/58638

2710 Sergey Glukhov	2008-11-13 [merge]
      5.0-bugteam->5.1-bugteam automerge(bug#39541)
[13 Nov 2008 13:21] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/58639

2926 Sergey Glukhov	2008-11-13 [merge]
      5.1-bugteam->6.0-bugteam automerge(bug#39541)
[2 Dec 2008 13:00] Bugs System
Pushed into 5.0.74  (revid:sergey.glukhov@sun.com-20081113130648-5w0jwoiz08xoxdsq) (version source revid:sergey.glukhov@sun.com-20081113130648-5w0jwoiz08xoxdsq) (pib:5)
[3 Dec 2008 2:37] Paul Dubois
Noted in 5.0.74 changelog.

CHECK TABLE failed for MyISAM INFORMATION_SCHEMA tables.

Resetting report to NDI pending push into 5.1.x, 6.0.x.
[8 Dec 2008 10:20] Bugs System
Pushed into 5.1.31  (revid:sergey.glukhov@sun.com-20081113130922-47bd756xfkkq0p8h) (version source revid:azundris@mysql.com-20081114081134-pswy3m5go7r64m1p) (pib:5)
[8 Dec 2008 11:31] Bugs System
Pushed into 6.0.9-alpha  (revid:sergey.glukhov@sun.com-20081113131327-l4qrmn52nurgsggz) (version source revid:ingo.struewing@sun.com-20081121151447-dtf2ofz2ys0zqed1) (pib:5)
[8 Dec 2008 17:05] Paul Dubois
Noted in 5.1.31, 6.0.9 changelogs.
[19 Jan 2009 11:27] Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090108105244-8opp3i85jw0uj5ib) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:05] Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:10] Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)