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

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.