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

[3 May 2011 18:55] Chad Dunham
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
[3 May 2011 18:58] Chad Dunham
Here is a print screen of the error

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

[3 May 2011 19:46] Miguel Solorzano
Have you applied the instructions of the Manual in the upgrade process?

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

Thanks.
[3 May 2011 21:55] Chad Dunham
Miguel -

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

Thanks

Chad
[3 May 2011 21:56] Chad Dunham
Closing item