MySQL Bugs: #52961: MySQL Workbench hangs while navigating the diagram

Bug #52961	MySQL Workbench hangs while navigating the diagram
Submitted:	20 Apr 2010 3:01	Modified:	8 Feb 2013 15:11
Reporter:	Aaron Morand	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.1.18a, 5.2.19, 5.2.20, 5.2.22	OS:	Linux (XUbuntu 9.10 (32bit) XUbuntu 10.04 (32bit))
Assigned to:		CPU Architecture:	Any
Tags:	diagram, hangs, linux, model, ubuntu, workbench

Description:
1) I imported an SQL create script containing 2 databases, the first containing 169 tables, the other 9 tables.  I also selected to display them on a diagram.  Note: There is one table in each database with the same name.
2) I selected "Arrange->Autolayout" to make the diagram readable.
3) I selected "Model->Diagram Properties and Size..." to resize the diagram to something that would fit.
4) I resized the diagram to 4 columns by 2 rows by entering the numbers manually into the "Diagram Properties" window.

At this point, if I select an area on the minimap to navigate there, Workbench hangs.  Workbench maxes out CPU cycles for one CPU, but memory usage remains unchanged.  I let it sit like this for up to 10 minutes hoping it would come back, but it has not.

I have retried this with different diagram sizes, including 7 & 8 rows with 3 columns so that all tables are displayed in the minimap before I select an place in the minimap I wish to navigate to.  The results are the same.

After the above failures, I tried the first 4 steps again, then manually started moving tables on the diagram.  This worked fine until I selected a group of about 30 and dragged them to the far right of the diagram, when Workbench then hung again.

How to repeat:
Repeating what I described above repeats the issue every time.

Could you please try version 5.2.19 and comment the results here. Thanks in advance.

I installed 5.2.19 and the minimap doesn't always seem to register my clicking on it, but it's not hanging.

I'm liking the combined toolset in 5.2.19.  Keep up the great work!

I spoke too soon, I just had Workbench (5.2.19 beta) crash while trying to adjust the zoom on the minimap.  I haven't been able to repeat the crash, but I was able to make it hang again trying to repeat the crash.

I can repeat the hanging, by adjusting making the height of the minimap panel be bigger, then navigating and adjusting the zoom level.

I've been able to repeat this several times pretty easily, but did have one occurrence where the hang didn't happen until I went fullscreen.  Where the action of going fullscreen caused it to hang.

I hope this helps.

From my usage through the day today, I've had it hang a few more times during tasks I've listed previously as well as dragging items in the diagram and mousing outside of the edge of the diagram.

Seems to me the issue is in whatever is controlling the diagram display as moving/resizing that is what is common in every hanging scenario I've encountered.

Thank you for the feedback.

Could you please attach diagram problem is repeatable with>

How much RAM do you have?

Can you still connect from remote to the machine?

Please past output from HELP->System Info here.

It is only Workbench that hangs, the rest of my system is still functional.  One CPU is 100% used up by Workbench, so the rest of the system functions normally on the other.  I monitor RAM usage at all times and it has never appeared to be an issue.

Here is the information you requested :
MySQL Workbench OSS for Linux/Unix version 5.2.19
Cairo Version: 1.8.8
Rendering Mode: OpenGL is not available on this system, INTERNAL ERROR, contact the authors.
OpenGL Driver Version: Not Detected
OS: Linux 2.6.31-20-generic
CPU: 2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz 1000.000 MHz, 2.0 GB RAM

Here is mine:

MySQL Workbench OSS for Linux/Unix version 5.2.20
Cairo Version: 1.8.8
Rendering Mode: OpenGL is not available on this system, so Native is used for rendering.
OS: Linux 2.6.31-20-generic
CPU: 2x Intel(R) Core(TM)2 CPU         T7200  @ 2.00GHz 1000.000 MHz, 2,0 GB RAM

This really looks identical to yours.

Besides the rendering mode.

We fixed lots of opengl issues in Workbench 5.2.20.

Can you give it a try and test if your problem is gone in Workbench 5.2.20.

Many thanks in advance.

The problem still happens in 5.2.20.

All I did to replicate the issue, inside of 1 minute was :
1. Start MySQL Workbench 5.2.20 - my project auto loads.
2. Click around the mini-map (which is at 50% zoom)
3. Adjust the zoom on the mini-map to 75%
4. Set the window to fullscreen
5. Click in the mini-map

My second try didn't hang repeating the exact procedure as described above, but will just by clicking around the mini-map and adjusting the zoom of the mini-map.

I just downloaded the Mac version and had a similar crash.

I imported from an existing database, did some rearranging, saved and was then working on adding foreign key relationships to the diagram.

I had just readjusted the zoom level and then clicked on another table to add another foreign key. The program hung and then crashed.

Here is my system info.

MySQL Workbench OSS for Mac OS X version 5.2.20
Cairo Version: 1.9.1
Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 2.0
OS: Darwin 10.3.0
CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8800  @ 2.66GHz, 4.0 GB RAM

Here are some lines from the system.log file:

May  5 11:39:42 sls-mbp MySQLWorkbench[601]: NSExceptionHandler has recorded the following exception:\nNSUncaughtSystemExceptionException -- Uncaught system exception: signal 11\nStack trace:  0x968c6378  0x9597342b  0xffffffff  0xb4e205  0x1bcbe  0x1b631  0x1bd03  0x1b631  0x1a5dc  0x1a696  0xf3d3  0x10988  0xad0d8c  0x96c90d58  0x969e42e2  0x969a0a1d  0x969a00f4  0x9699ff21  0x9561c0fc  0x9561beb1  0x9561bd36  0x94d29135  0x94d28976  0x94ceabef  0x94ce2c85  0xbc56  0x2
May  5 11:39:49 sls-mbp com.apple.launchd.peruser.501[116] ([0x0-0x38038].com.sun.MySQLWorkbench[601]): Job appears to have crashed: Segmentation fault
May  5 11:39:50 sls-mbp ReportCrash[632]: Saved crash report for MySQLWorkbench[601] version ??? (5.2.20) to /Users/sls/Library/Logs/DiagnosticReports/MySQLWorkbench_2010-05-05-113950_sls-mbp.crash

I am able to repeat this.

$ mysql < create_table.sql

Open Workbench
CREATE ERR Model from Existing Database
Shoes tb1
and click through it ...
it won't create a diagram.

After finished got to tab tb1
Model -> Create diagram from catalog
Arrange -> Autolayout
Zoom 50
Delete a FK line
Zoom 75
Scroll a little bit
Zoom 200
Create a new FK
Zoom 75

and it hangs and crash.

@Steven Snelgrove

Please upload the crashlog that the error message you got mentions (/Users/sls/Library/Logs/DiagnosticReports/MySQLWorkbench_2010-05-05-113950_sls-mbp.crash
 )

I am having similar issues with a similar system:
--------------------------------------------------
MySQL Workbench OSS for Linux/Unix version 5.2.20
Cairo Version: 1.8.10
Rendering Mode: OpenGL is not available on this system, INTERNAL ERROR, contact the authors.
OpenGL Driver Version: Not Detected
OS: Linux 2.6.32-22-generic
CPU: 2x Intel(R) Core(TM)2 Duo CPU     E6850  @ 3.00GHz 2999.932 MHz, 3.9 GB RAM
-------------------------------------------------

I get much slowness (and the CPU cores ramp up a bit) when doing anything "graphical" such as moving tables/regions, moving the entire map, playing with the mini-map, etc.

BTW, I'm not using any compositing or anything, since I have a triple monitor setup (w/ two nVidia GeForce 250 GTS's), and can't do anything like that...

Would love to get the CPU issues fixed!  (that's part of why I tried 5.2.20)..

THANKS guys!

Michael Bahnmiller

I just confirmed this is still present under XUbuntu 10.04 (32bit) with MySQL Workbench 5.2.22.

As far as the crash/exception is concerned, this is a duplicate of bug #55390. The CPU usage/slowness is a separate issue it seems.

I have a similar hang.. a fairly large model with several diagrams (~80 tables).
Only one diagram seems to cause this hang (the one with the most), it is 3 pages wide by 2 pages tall.
Does not matter if I use the "Navigator preview box" or use the scroll bars, or if there are other diagrams open, but when I get close to the lower-right, it hangs.  OS is Ubuntu 9.10.
It happened in 5.2.25 and I just upgrade to 5.2.26 and still see this hang.

** If you can ensure that this schema will be kept secure, I am willing to share the file if it will help resolve this.

Update: I think this is related to the "Zoom" % in the navigator..
It was 68% during all the above tests.  I opened the diagram again, set the zoom to 100% and... TA-DA, no hang! I set the zoom to 90% and moved to the lower-right, and it hung.
Hope this helps!

No reproducible in the latest WB Version
Verified in:
Ubuntu 12.04x64
Windows7x64
WB 5.2.46 rev.10385