MySQL Bugs: #61123: Double clicking "Tables" expander arrow in Object Browser crashes Workbench

Bug #61123	Double clicking "Tables" expander arrow in Object Browser crashes Workbench
Submitted:	11 May 2011 1:38	Modified:	28 Jun 2011 12:58
Reporter:	Jeremy Bell	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	5.2.34	OS:	Windows (7 64 bit)
Assigned to:		CPU Architecture:	Any
Tags:	crash, double click, Object Browser, schema

Description:
If you load up an editor for a database with a decent amount of tables - enough to take at least a few seconds to load when clicking the expander arrow for the *schema* - it first brings up a window "MySQL Workbench has encountered a problem", then when this window is closed, Workbench crashes.

How to repeat:
1. Load up an editor for a database with enough tables to take a few seconds to load all the tables in (it may need to be a remote database).
2. Expand the schema in the object browser, so that "Tables" is visible but not expanded.
3. Double-click (may need to tripple or even quadruple click many times in some cases) the "Tables" expander arrow to expand and collapse the table list in the object browser.
4. A "MySQL Workbench has encountered an error..." message should come up.
5. Close this window.
6. Workbench crashes.

Suggested fix:
Debug to find out what's causing the crash, and fix it. Sorry I can't be more specific here as I don't know the code.

What exact version of server, x.y.z, are you working with?

Server version is 5.5.11-log

Can you repeat the bug and when the bug dialog appears, right click in a blank area below the icon and select Copy Stacktrace, then paste it here? Thanks

When I did what you said, nothing copied to the clipboard, and an "Unhandled exception" error showed up. (I'll attach an image shortly.) The full details from this window are below. Hopefully this is what you're after.

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Threading.ThreadStateException: Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it.
   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
   at System.Windows.Forms.Clipboard.SetText(String text)
   at MySQL.GUI.Workbench.ExceptionDialog.copyStackTraceToClipboardToolStripMenuItem_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.225 (RTMGDR.030319-2200)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
MySQLWorkbench
    Assembly Version: 5.2.33.7508
    Win32 Version: 5.2.33.7508
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/MySQLWorkbench.exe
----------------------------------------
wbprivate.wr
    Assembly Version: 0.0.0.0
    Win32 Version: 
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/wbprivate.wr.DLL
----------------------------------------
wbpublic.wr
    Assembly Version: 0.0.0.0
    Win32 Version: 
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/wbpublic.wr.DLL
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
base.windows
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/base.windows.DLL
----------------------------------------
mforms.wr
    Assembly Version: 1.0.0.1
    Win32 Version: 
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/mforms.wr.DLL
----------------------------------------
MySQLCsUtilities
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/MySQLCsUtilities.DLL
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 (RTMRel.030319-0100)
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
Aga.Controls
    Assembly Version: 1.6.0.0
    Win32 Version: 1.6.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/Aga.Controls.DLL
----------------------------------------
ScintillaNet
    Assembly Version: 2.0.4093.24622
    Win32 Version: 2.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/ScintillaNet.DLL
----------------------------------------
sqlide.fe
    Assembly Version: 0.0.0.0
    Win32 Version: 0.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/sqlide.fe.DLL
----------------------------------------
WbPlugins
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/MySQL/MySQL%20Workbench%205.2%20CE/WbPlugins.DLL
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.0.30319.1 built by: RTMRel
    CodeBase: file:///C:/Windows/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Unhandled exception window.

Attachment: Capture.PNG (image/png, text), 22.90 KiB.

Please try version 5.2.34. Thanks.

Still happens. Also still fails to copy the stacktrace to the clipboard.

Wouldn't it save time for all parties if an actual fix was made before asking for an update in newer versions? I use Mac OS most of the time and it takes a while to close down and boot up in Windows. No biggie, just a thought.

Is there any other info your require at this stage?

How many objects do you have in your tree, approximately?  When the problem occurred dialog from workbench appears, can you take a screenshot and upload it here. Thanks

Strange, I can't reproduce the issue any more. No matter what I try. This definitely still happened after I upgraded to 5.2.34. The only thing that's happened since then is a full reboot of Windows.

Looks like it's fixed.

In any case, we have 1395 tables if you want to do any further testing.

Thanks for the feedback. We're cloding the bug for now - please feel free to reopen if the problem re-occurs or you find a way to repeat it again.
thanks for your help