MySQL Bugs: #62451: Double clicking a table crashes mysql workbench

Bug #62451	Double clicking a table crashes mysql workbench
Submitted:	16 Sep 2011 15:19	Modified:	8 Feb 2012 22:52
Reporter:	Brad Koch	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	5.2.34, 5.2.35	OS:	Windows (Windows 7 x64 SP 1)
Assigned to:		CPU Architecture:	Any
Tags:	crash, double click, EER model, table

Description:
Double clicking on a table while creating a EER diagram causes Workbench to crash.  This happens on both the Model Overview, and on the EER diagram.

Here's the Windows Application Log Entry, if that's good for anything.  Note that sometimes the faulting module path is unknown; I've also seen C:\Windows\SysWOW64\ntdll.dll.

Event ID: 1000, Source: Application Error
Faulting application name: MySQLWorkbench.exe, version: 5.2.35.7907, time stamp: 0x4e67c02b
Faulting module name: db.mysql.sqlparser.grt.dll, version: 0.0.0.0, time stamp: 0x4e67c04e
Exception code: 0xc0000005
Fault offset: 0x00012f63
Faulting process id: 0x1598
Faulting application start time: 0x01cc748210900478
Faulting application path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\MySQLWorkbench.exe
Faulting module path: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\db.mysql.sqlparser.grt.dll
Report Id: 53ef2540-e075-11e0-98f5-005056850008

Event ID: 1026, Source: .NET Runtime
Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0000005, exception address 09272F63
Stack:

How to repeat:
Create a new EER diagram.  Add two tables.  Double click on one, then the other.  By about the 4th time you do this, Workbench will crash.

Basic demo file; easy enough to manually recreate.

Attachment: double-click-demo.mwb (application/octet-stream, text), 4.38 KiB.

Forgot to mention I'm running 64 bit.

I couldn't repeat on Vista 64-bit.

Coworker can't reproduce on same version of Windows 7.  Problem persists for me even after an uninstall and reinstall.  Seems like all to common of a story for MySQL workbench..

Please, send the output of Help > System Info menu item.

Help > System Info:
MySQL Workbench CE for Windows version 5.2.34
Configuration Directory: C:\Users\kochb\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: Intel(R) Xeon(R) CPU           X5650  @ 2.67GHz, 2.0 GiB RAM
Active video adapter: VMware SVGA 3D (Microsoft Corporation - WDDM)
Installed video RAM: 0 MB
Current video mode: 1366 x 768 x 4294967296 colors
Used bit depth: 32
Driver version: 7.14.1.40
Installed display drivers: vm3dum64.dll,vm3dum,vm3dgl64.dll,vm3dgl
Current user language: English (United States)

See http://bugs.mysql.com/bug.php?id=62461.

I also get crashes, at least every 5:th time or so I edit a table (any table, either double-click or right-click -> "Edit table"). CE 5.2.35, Windows Server 2008 64-bit, running under VirtualBox.

Message in Windows "MySQL Workbench has stopped working" dialog:
---------------------------------------------
Description:
  Stopped working

Problem signature:
  Problem Event Name:	APPCRASH
  Application Name:	MySQLWorkbench.exe
  Application Version:	5.2.35.7915
  Application Timestamp:	4e7957cf
  Fault Module Name:	unknown
  Fault Module Version:	0.0.0.0
  Fault Module Timestamp:	00000000
  Exception Code:	c0000005
  Exception Offset:	cccccccc
  OS Version:	6.0.6002.2.2.0.274.10
  Locale ID:	1033
---------------------------------------------

Event log entry, event id 1026:
---------------------------------------------
Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0000005, exception address CCCCCCCC
Stack:
---------------------------------------------

And entry immediately below, event id 1000:
---------------------------------------------
Faulting application MySQLWorkbench.exe, version 5.2.35.7915, time stamp 0x4e7957cf, faulting module unknown, version 0.0.0.0, time stamp 0x00000000, exception code 0xc0000005, fault offset 0xcccccccc, process id 0x%9, application start time 0x%10.
---------------------------------------------

System info:
MySQL Workbench CE for Windows version 5.2.35

Configuration Directory: C:\Users\admin2\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

OS: Microsoft Windows Server 2008 Enterprise Edition Service Pack 2 (build 6002), 64-bit

CPU: AMD Phenom(tm) 8450 Triple-Core Processor, 2.0 GiB RAM

Current user language: English (United States)

Can somebody of you tell me which application have installed on yours machines from the list below?

ESET Nod32 Anitivirus
Altova XML Spy
Adobe Dreamviewer CS3
MS Visual Studio .NET 2003

Tnx!

I have none of those programs installed. This is the list of installed programs:
MySQL Server 5.5
Microsoft Network Monitor 3.4
Microsoft .NET Framework 3.5 SP1
Java(TM) 6 Update 27 (64-bit)
Java(TM) SE Development Kit 6 Update 27 (64-bit)
Microsoft Network Monitor: NetworkMonitor Parsers 3.4
Microsoft .NET Framework 4 Extended
Microsoft Visual C++ 2010  x86 Redistributable - 10.0.30319
Microsoft Silverlight
Microsoft .NET Framework 4 Client Profile
MySQL Workbench 5.2 CE

I have none of these.  Edvard, could you elaborate on the rationale for your post?  We should validate what we're doing so as to not get sidetracked.

Which Graphics adapter you have?

http://bugs.mysql.com/bug.php?id=62787

As you can see I also have the same bug, I am post a little video where you can see what happened.

Until now I spend almost a year to find the solution without success.

My bug is the same, only difference is that I double click on the procedure/function, and you on the tables. I also have the same bug on the tables but not so often like on the procedure/function.

I think that db.mysql.sqlparser.grt.dll is the reason, but nobody listen.

I have 3 workstation with the same bugs triggered.

Do you satisfied with my answer?

@Edvard
You appear to be right; db.mysql.sqlparser.grt.dll definitely seems to be source of the crash.

There's no video that I can see at the provided link.

Still don't understand how exactly you compiled that list of applications, but maybe that's explained in your video.  Regardless, we just need to make sure that it leads to a reproduceable way for the workbench team to trigger the bug so that they can identify the source of the error and fix it; otherwise it doesn't do anyone any good.

It's not that no one is listening; the workbench team is just slow in general at fixing issues.  Not sure if they just don't have the resources to fix them or what.  Some emphasis on stability would definitely be nice; issues like this are showstoppers.

Bug #62787 was marked as a duplicate of this one.

Today I have these log messages after bug:

Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.AccessViolationException
Stack:
   at <Module>.Sql_editor.check_sql(Sql_editor*, Boolean)
   at MySQL.Grt.Db.Sql.Sql_editor.check_sql(Boolean)
   at MySQL.Grt.Db.Sql.SqlEditor.CheckSql(Boolean)
   at MySQL.Grt.Db.Sql.SqlEditor.set_SqlText(System.String)
   at MySQL.GUI.Workbench.Plugins.DbMysqlRoutineEditor.RefreshFormData()
   at MySQL.GUI.Workbench.Plugins.DbMysqlRoutineEditor.ChangeGrtList(MySQL.Grt.GrtManager, MySQL.Grt.GrtValue)
   at MySQL.GUI.Workbench.MainForm.OpenPlugin(MySQL.Grt.GrtManager, MySQL.Grt.GrtModule, System.String, System.String, MySQL.Grt.GrtValue, MySQL.Forms.GUIPluginFlags)
   at MySQL.Forms.AppImpl.open_editor_wrapper(bec.GRTManager*, grt.Module*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*, grt.BaseListRef*, bec.GUIPluginFlags)
   at <Module>.boost.detail.function.function_obj_invoker6<boost::_bi::bind_t<unsigned int,unsigned int (__cdecl*)(bec::GRTManager *,grt::Module *,std::basic_string<char,std::char_traits<char>,std::allocator<char> > const &,std::basic_string<char,std::char_traits<char>,std::allocator<char> > const &,grt::BaseListRef const &,enum bec::GUIPluginFlags),boost::_bi::list6<boost::arg<1>,boost::arg<2>,boost::arg<3>,boost::arg<4>,boost::arg<5>,boost::arg<6> > >,unsigned int,bec::GRTManager *,grt::Module *,std::basic_string<char,std::char_traits<char>,std::allocator<char> >,std::basic_string<char,std::char_traits<char>,std::allocator<char> >,grt::BaseListRef,enum bec::GUIPluginFlags>.invoke(__cdecl*)(bec::GRTManager *,grt::Module *,std::basic_string<char,std::char_traits<char>,std::allocator<char> > const &,std::basic_string<char,std::char_traits<char>,std::allocator<char> > const &,grt::BaseListRef const &,enum bec::GUIPluginFlags),boost::_bi::list6<boost::arg<1>,boost::arg<2>,boost::arg<3>,boost::arg<4>,boost::arg<5>,boost::arg<6> > >,unsigned int,bec::GRTManager *,grt::Module *,std::basic_string<char,std::char_traits<char>,std::allocator<char> >,std::basic_string<char,std::char_traits<char>,std::allocator<char> >,grt::BaseListRef,enum bec::GUIPluginFlags>.invoke(boost.detail.function.function_buffer*, bec.GRTManager*, grt.Module*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*, std.basic_string<char,std::char_traits<char>,std::allocator<char> >*, grt.BaseListRef*, bec.GUIPluginFlags)
   at MySQL.Grt.ListModel.activate_node(MySQL.Grt.NodeId)
   at MySQL.GUI.Workbench.ModelOverviewForm.listViewDoubleClick(System.Object, System.EventArgs)
   at System.Windows.Forms.Control.OnDoubleClick(System.EventArgs)
   at System.Windows.Forms.ListView.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Control+ControlNativeWindow.OnMessage(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.Control+ControlNativeWindow.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr, Int32, IntPtr, IntPtr)
   at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG ByRef)
   at System.Windows.Forms.Application+ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr, Int32, Int32)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Int32, System.Windows.Forms.ApplicationContext)
   at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Int32, System.Windows.Forms.ApplicationContext)
   at System.Windows.Forms.Application.Run(System.Windows.Forms.ApplicationContext)
   at MySQL.GUI.Workbench.Program.Main(System.String[])

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Fixed as of 5.2.38:

Double-clicking on a table within the EER diagram editor would
sometimes crash Workbench.

Ah, finally!

Now I have problems with sync, will explain later.

Ok am I missing something here?  I see the problem is closed.  I see multiple reports for the same problem.  Am I looking in the wrong place?  Were do I find the fix?

Ok well downloaded a free copy of dependency walker.. depends.exe to check out the dll that kept poping up in the windows event logs under the error logs.  Came up with four dlls missing even after reinstalling the Microsoft two correct microsoft  dependencies as described under the mysql workbench dependencies and uninstalling/reinstalling the workbench.  Ran across a thread that mentioned microsot had cut lose of a patch last July and August that could prevent key miscrosoft .dlls from installing durring automatic updates.  I suspect that I may have to register the dll's if they are present or download and manually install them if they arent.  Get a copy of depends.exe its free and will answer alot of questions about what your problem is.

Hmmm well that didn't fix it either, no good roll back points for the system.  Uninstalled and reinstalled all dependencies and the work bench.  One of the other developers pointed out that his runs fine on xp 64 under his ubuntu development vm.  Two words.  Linux Ubuntu.  Configured it to tlk to my wamp server... I know youd think it would be the other way around, but it works without any trouble and a great performance and stability boost so for now the Penquin it is.