Bug #36417 mysql_upgrade doesn't upgrade mysql.events table.
Submitted: 29 Apr 2008 23:57 Modified: 30 Apr 2008 6:21
Reporter: Sergey Petrunya Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any

[29 Apr 2008 23:57] Sergey Petrunya
Description:
I was upgrading from 5.1.25-bk to 6.0.6-bk and observed the following:

After the upgrade mysqld during startup would print a number of messages like the following: 

080429 16:42:04 [ERROR] Incorrect definition of table mysql.db: expected the type of column 'Event_priv' at position 20 to have character set 'utf8' but found character set 'utf8mb3'.

The messages were about various columns in mysql.db and mysql.event tables.

I ran mysql_upgrade script, it successfully finished, and the messages about mysql.db went away. The messages about mysql.event remained though, I still get this: 

080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'db' at position 0 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'definer' at position 3 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Incorrect definition of table mysql.event: expected the type of column 'comment' at position 15 to have character set 'utf8' but found character set 'utf8mb3'.
080429 16:42:26 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

How to repeat:
install 5.1
install 6.0
start the server, note the error messages
run mysql_upgrade script
start the server, note the error messages

Suggested fix:
make mysql_upgrade handle mysql.event table also.
[30 Apr 2008 6:21] Valeriy Kravchuk
Duplicate of Bug #33053.