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
Category:	Server: I_S	Severity:	S3 (Non-critical)
Version:	5.0.67, 5.0 bzr	OS:	Any
Assigned to:	Sergey Gluhov	Target Version:	5.0.74
Tags:	CHECK TABLE, myisam, Table upgrade required, regression
Triage:	Triaged: D3 (Medium)

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)