Bug #47499 Reverse engineering is not working

• Submitted: 21 Sep 2009 23:37
• Modified: 22 Sep 2009 17:56
• Reporter: Juan Soto
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 5.1.18
• OS: Any
• CPU Architecture: Any

[21 Sep 2009 23:37] Juan Soto

Description:
Reverse engineering is not working.
Start a never ending process.

How to repeat:
Try with the dump atached to this report.

[22 Sep 2009 6:19] Valeriy Kravchuk

I've created tables from your dump in (empty) test database and then was able to reverse engineer it with WB 5.1.18 OSS on Windows XP. It took some time (many seconds), but otherwise I had not noted any problems. What I did wrong? Should I try to reverse engineer from script directly?

[22 Sep 2009 8:29] Sergei Tkachenko

It took nearly 10 seconds to reverse-engineer directly from provided SQL dump script.
The actual problem could be with optional placing objects on diagram as part of reverse-engineering process. Try to clear `Place imported objects on diagram` check box in `Select Objects` wizard page. You can place them on diagram later using menu item `Model->Create Diagram from Catalog Objects`.

[22 Sep 2009 13:20] Juan Soto

Thanks, the reverse-engineer process works great. I can confirm that the problem is with the `Place imported objects on diagram` option in `Select Objects` wizard page. It seems that for some reason starts an infinite loop.

[22 Sep 2009 14:04] Valeriy Kravchuk

I do NOT see "a never ending process". I see a long process, with successful result. How much RAM do you have on that box?

[22 Sep 2009 14:19] Juan Soto

I have 4GB of RAM, a Core 2 Duo 2.4 Ghz and I waited for more than 60 mins before stop the process.

Tranks in advance.

[22 Sep 2009 17:55] MySQL Verification Team

result

Attachment: reverse_eng.png (image/png, text), 43.91 KiB.

[22 Sep 2009 17:56] MySQL Verification Team

I couldn't repeat this issue on Windows Vista Home Premium 4 GB RAM (see prior attached picture).