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: Miguel Solorzano CPU Architecture:Any

[15 Sep 2006 17:28] Ariel Glenn
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.
[18 Sep 2006 14:21] Miguel Solorzano
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.
[14 Oct 2006 17:29] fx pottier
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
[14 Oct 2006 17:32] fx pottier
sorry i forgot to mention the package :
mysql-workbench-5.0r4-1fc5
[18 Oct 2006 23:00] Bugs System
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".
[3 Feb 2007 10:09] Alec de Zegher
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)
[3 Feb 2007 10:30] Alec de Zegher
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