MySQL Bugs: #39541: CHECK TABLE on information_schema myisam tables produces error

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:	Sergei Glukhov	CPU Architecture:	Any
Tags:	CHECK TABLE, myisam, regression, Table upgrade required

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).

Thank you for the report.

Verified as described.

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

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

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)

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)

Pushed into 5.0.74  (revid:sergey.glukhov@sun.com-20081113130648-5w0jwoiz08xoxdsq) (version source revid:sergey.glukhov@sun.com-20081113130648-5w0jwoiz08xoxdsq) (pib:5)

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.

Pushed into 5.1.31  (revid:sergey.glukhov@sun.com-20081113130922-47bd756xfkkq0p8h) (version source revid:azundris@mysql.com-20081114081134-pswy3m5go7r64m1p) (pib:5)

Pushed into 6.0.9-alpha  (revid:sergey.glukhov@sun.com-20081113131327-l4qrmn52nurgsggz) (version source revid:ingo.struewing@sun.com-20081121151447-dtf2ofz2ys0zqed1) (pib:5)

Noted in 5.1.31, 6.0.9 changelogs.

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)

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)

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)