MySQL Bugs: #22399: fails to reverse engineer schema

Bug #22399	fails to reverse engineer schema
Submitted:	15 Sep 2006 17:28	Modified:	18 Oct 2006 14:21
Reporter:	Ariel Glenn	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	5.0r3	OS:	Linux (Fedora Core 5)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
Using mysql-workbench-5.0r3-1fc5.i386.rpm, I get the following errors when I try to reverse engineer the schema for a database: 

...

** Message: Calling builtin function WorkbenchController._valueToGrt
** Message: Calling builtin function WorkbenchController._valueToGrt
** Message: Calling builtin function WorkbenchController.unselectObject
** Message: Calling builtin function WorkbenchController._updateToGrt
** Message: Fetching schemata...

** Message: Calling builtin function ReverseEngineeringMysql.getSchemata
** Message: Schemata fetched.

** Message: Reverse engineering schema...
** Message: Calling builtin function ReverseEngineeringMysql.reverseEngineer
** Message: Error calling ReverseEngineeringMysql.reverseEngineer: Could not get routines.
** Message: The schema(ta) could not be reverse engineered (error: 0)

No matter what schema I select, and no matter what (valid) user/password I use.

I have installed also mysql-administrator-5.0r3-1fc5.i386.rpm

The output above was taken from running DEBUG=X GRT_VERBOSE=X mysql-workbench
Do you need the complete output? 

How to repeat:
Database -> Reverse Engineer

in the connection dialog, 
new connection: localhost, valid username and password

in schema selection window, select the right one

in the reverse engineering window, the error shows up in the log.

Thank you for the bug report. I was unable to repeat on Suse 10.0/Fedora Core 5.
Could you please provide a dump sample of the schema you tried?

Thanks in advance.

Hi there,
same for me :
Error calling ReverseEngineeringMysql.reverseEngineer: Could not get routines
when i try to reverse a schema (i did try different ones => same result).
My system : Fedora Core 5

sorry i forgot to mention the package :
mysql-workbench-5.0r4-1fc5

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Hi, I have exact the same problem on MacOSX 10.4 (Tiger) and Workbench 1.29a.

1) Connection: 10.0.0.2 with correct username and password
2) Selecting a database
3 Error

Error log:
Fetching schemata...
Schemata fetched.
Reverse engineering schema...Error calling ReverseEngineeringMysql.reverseEngineer: Could not get routines.The schema(ta) could not be reverse engineered (error: 0)
Could not get routines. (SHOW PROCEDURE STATUS;

MySQL Error 1146: Table 'mysql.proc' doesn't exist)

I found the error: I did a bad upgrade from 4.1 to 5.0 (mysql.proc is apperently a new file created in MySQL 5.0)

This post helped me: http://bugs.mysql.com/bug.php?id=24271