MySQL Bugs: #61044: Workbench cannot synchronize with schema

Bug #61044	Workbench cannot synchronize with schema
Submitted:	3 May 2011 18:55	Modified:	3 May 2011 21:56
Reporter:	Chad Dunham	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S1 (Critical)
Version:		OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
I have recently upgraded from MySQL 5.1 to 5.5.11 and now I am not being able to see any of the details (tables, views, routines) of the schema when using MySQL Workbench (version 5.2.33 CE revision 7508).  When I try to do a synchronization between the model and the schema I get the following error:

Error : Cannot load from mysql.proc. The table is probably corrupted

Message log: 

Fetching table list.

    1 items from CantorETF

OK

Fetching view list.

    0 items from CantorETF

OK

Fetching routine list.

Operation failed: Cannot load from mysql.proc. The table is probably corrupted

However, if I query the table for the given schema, the table is able to be accessed with no issues.  

I am marking this as S1 because I am not able to update or change tables/views without this functionality.  Also as a note, MySQL is running on a Linux server, and the workbench is running on a Windows machine.

How to repeat:
N/A

Here is a print screen of the error

Attachment: Error.gif (image/gif, text), 37.23 KiB.

Have you applied the instructions of the Manual in the upgrade process?

http://dev.mysql.com/doc/refman/5.5/en/upgrading.html

Thanks.

Miguel -

Thanks for the link, apparently I missed something original.  After following the steps, everything is working as expected.

Thanks

Chad

Closing item