Ok, I'm a little further. I get the error after this command:

"CHECK TABLE $table EXTENDED";

Where $table is a table in the information_schema. The specific error
seems to be:

"Table is already up to date"

Instead of the usual:

"OK"

Could this be related to this?

http://lists.mysql.com/internals/31016

Please, shed some light on this! The error does seem less dramatic than I
initially thought, but it still freaks me out some.

- Mark



-----Original Message-----
From: Mark [mailto:asarian@xs4all.nl]
Sent: zondag 23 december 2007 13:51
To: mysql@lists.mysql.com
Subject: information_schema errors after (minor) upgrade

Running a FreeBSD system and mysql 5.0.27 server, I recently upgraded to

5.0.51 (but kept the 5.0.27 client). Everything seemed fine, until I ran a

databse check today:



Checking information_schema:CHARACTER_SETS Checking

information_schema:COLLATIONS Checking

information_schema:COLLATION_CHARACTER_SET_APPLICA BILITY

Checking information_schema:COLUMNS

ERROR, REPAIR could not execute

Checking information_schema:COLUMN_PRIVILEGES

Checking information_schema:KEY_COLUMN_USAGE

Checking information_schema:PROFILING

Checking information_schema:ROUTINES

ERROR, REPAIR could not execute

Checking information_schema:SCHEMATA

Checking information_schema:SCHEMA_PRIVILEGES

Checking information_schema:STATISTICS

Checking information_schema:TABLES

Checking information_schema:TABLE_CONSTRAINTS

Checking information_schema:TABLE_PRIVILEGES

Checking information_schema:TRIGGERS

ERROR, REPAIR could not execute

Checking information_schema:USER_PRIVILEGES

Checking information_schema:VIEWS

ERROR, REPAIR could not execute



Oops! How can I fix these information_schema errors?? I ran a full:



/usr/local/bin/myisamchk --force --extend-check --update-state -O

key_buffer=128M -O sort_buffer=128M -O read_buffer=2M -O write_buffer=2M

/var/db/mysql/*/*.MYI



But that didn't seem to include the information_schema, though. How can I

fix these errors? So close to Xmax, I'm panicking a little.



Thanks,



- Mark