| Bug #48328 | Reverse Engineer - Schema selected, contains no triggers - Hangs forever | ||
|---|---|---|---|
| Submitted: | 26 Oct 2009 20:17 | Modified: | 1 Dec 2009 0:21 |
| Reporter: | Craig Detter | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S2 (Serious) |
| Version: | 5.1.18 OSS | OS: | Windows (Hangs ) |
| Assigned to: | CPU Architecture: | Any | |
[29 Oct 2009 1:08]
MySQL Verification Team
Thank you for the bug report. Could you please provide your project model file to try on our side?. Thanks in advance.
[30 Nov 2009 0: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".
[30 Nov 2009 18:23]
Craig Detter
This is working, it was just taking incredibly long for large numbers of schemas and tables. It can be closed or reassigned as slow performance defect.
[1 Dec 2009 0:21]
MySQL Verification Team
Thank you for the feedback.
[15 Aug 2011 5:03]
Kevin Jhangiani
I found this issue via google, but I would like to add that this is definitely a bug. I am new to MySQL Workbench, and I just downloaded it to test it out. However, on our database (~200 tables), when reverse engineering, it would hang at the trigger stage. Our database has no triggers. After finding this thread, I tried another database with very few tables, but also no triggers, and it was also nonresponsive (not frozen, but not doing anything). I added a single arbitrary trigger to one of our tables in the large database, and suddenly the reverse engineer worked in seconds. It seems to me that the reverse engineer is not properly handling the situation where no triggers are found.
[21 Mar 2012 16:48]
Ventzy Kunev
I have the same issue but in Database -> Synchronize model. The database have 270 tables and no triggers. On the "Fetch Object Info" step, it hungs on "Fetching trigger list." and after ~20-30 min "Operation failed: Lost connection to MySQL server during query". Interestingly, if I hit back and then next to re-execute the same step it is ok - "Fetching trigger list." is completed in 5-10 seconds.
[21 Mar 2012 16:50]
Ventzy Kunev
I forgot to say that I am using Vista 64bit, WB 5.2.36 CE, rev. 8542
Description: Workbench hangs when no triggers in schema performing reverse engineer. How to repeat: Database -> Reverse Engineer -> Select Stored connection -> Next Select Schemata -> (select reports schema -- only one schema) (Fetch Object Info) ..... Fetching table list. 20 items from reports OK Fetching view list. 0 items from reports OK Fetching routine list. 15 items from reports OK Fetching trigger list. --------hangs forever here (never returns) ------------ Suggested fix: Make sure that the workbench handles schemas with no triggers, even when selecting just one schema from a list of 50-100.