MySQL Bugs: #52556: Connector/MXJ 5.0.11 requires table upgrades but does not include table upgrades

Bug #52556	Connector/MXJ 5.0.11 requires table upgrades but does not include table upgrades
Submitted:	2 Apr 2010 18:47	Modified:	13 Sep 2012 13:54
Reporter:	Alexander Ljungberg	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	Connector / MXJ	Severity:	S3 (Non-critical)
Version:	5.0.11	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	mysql_upgrade, UPDATE, upgrade

Description:
If MySQL Connector MXJ is upgraded from a previous version to 5.0.11, and existing database tables are kept but old runtime files are not, the following error messages appear in logs:

Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50022, now running 50140. Please use mysql_upgrade to fix this error.
mysql.user has no `Event_priv` column at position 29
Cannot open mysql.event
Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

How to repeat:
1. Deploy a database using an older version of MySQL Connector MXJ.
2. Upgrade to MySQL Connector MXJ 5.0.11.
3. Delete the previously auto deployed database runtime files. Do not delete the database data.
4. Deploy with the new MXJ version. The new database runtime will be installed.

Expected result:
The new version runs with the old database data.

Actual result:
The new version runs but generates error messages.

Suggested fix:
Include mysql_upgrade in MXJ and run it automatically as needed.

Hi Alexander and thanks for your report.

Verified as described. Alas, we never got to this problem and I can not tell when it will be fixed finally.

We do not develop/support c/MXJ any more.