Bug #64186 loading a 177Meg sql file resulted in crash
Submitted: 31 Jan 2012 19:48 Modified: 20 Jul 2012 7:31
Reporter: Bill Turner Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.34, 5.2.37 OS:Windows (7 64bit OS)
Assigned to: CPU Architecture:Any

[31 Jan 2012 19:48] Bill Turner
Description:
"Run SQL File"  loading a 177Meg sql file resulted in crash.

create table with extended inserts for loading maybe a million rows....

How to repeat:
create table with extended inserts for loading maybe a million rows....
[1 Feb 2012 5:15] Valeriy Kravchuk
Please, check if this crash still happens with a newer version, 5.2.37.
[6 Feb 2012 20:08] Bill Turner
This also happens on the current 5.2.37 CE, although the message is a bit different: 

Exception of type 'System.OutofMemoryException' was thrown
[7 Feb 2012 14:38] MySQL Verification Team
Please provide the output of Help->System Info. It was using the Manage Import/Export or SQL Editor tab?. Thanks.
[7 Feb 2012 19:42] Bill Turner
"Please provide the output of Help->System Info. It was using the Manage Import/Export or SQL Editor tab?. Thanks. "

5.2.34 using the File -> Execute SQL Script
5.2.37 using the File -> Open SQL Script

Help -> System Info is here:
MySQL Workbench CE for Windows version 5.2.37  revision 8576
Configuration Directory: C:\Users\wturner\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 available on this system, so OpenGL is used for rendering.
OpenGL Driver Version: 3.3.0
OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM) i5 CPU       M 540  @ 2.53GHz, 7.9 GiB RAM
Active video adapter (0): NVIDIA NVS 3100M  
Installed video RAM: 256 MB
Current video mode: 1920 x 1200 x 4294967296 colors
Used bit depth: 32
Driver version: 8.17.12.6721
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)

Also perhaps interesting, 5.2.34 produced the following windows event messages:
Faulting application name: MySQLWorkbench.exe, version: 5.2.34.7780, time stamp: 0x4ddbbfe9
Faulting module name: wbprivate.be.dll, version: 0.0.0.0, time stamp: 0x4ddbbeb7
Exception code: 0xc0000005
Fault offset: 0x0026c113
Faulting process id: 0x1b04
Faulting application start time: 0x01cce52b0cdb2209
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\wbprivate.be.dll
Report Id: 5d12a724-511e-11e1-bc8d-005056c00008

and

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>.mforms.MenuItem.callback(mforms.MenuItem*)
   at MySQL.Forms.MenuItemImpl.menuItemClick(System.Object, System.EventArgs)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(System.Object, System.EventArgs)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(System.EventArgs)
   at System.Windows.Forms.ToolStripItem.HandleClick(System.EventArgs)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)
   at System.Windows.Forms.ToolStripItem.FireEvent(System.EventArgs, System.Windows.Forms.ToolStripItemEventType)
   at System.Windows.Forms.ToolStrip.OnMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(System.Windows.Forms.MouseEventArgs)
   at System.Windows.Forms.Control.WmMouseUp(System.Windows.Forms.Message ByRef, System.Windows.Forms.MouseButtons, Int32)
   at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.ScrollableControl.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.ToolStrip.WndProc(System.Windows.Forms.Message ByRef)
   at System.Windows.Forms.ToolStripDropDown.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[])
[13 Feb 2012 22:41] MySQL Verification Team
Thank you for the bug report.

Exception = System.OutOfMemoryException
Message = Exception of type 'System.OutOfMemoryException' was thrown.
FullText = System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.String.CreateStringFromEncoding(Byte* bytes, Int32 byteLength, Encoding encoding)
   at System.Text.UTF8Encoding.GetString(Byte[] bytes, Int32 index, Int32 count)
   at System.Text.Encoding.GetString(Byte[] bytes)
   at System.String.CreateString(SByte* value, Int32 startIndex, Int32 length, Encoding enc)
   at System.String..ctor(SByte* value, Int32 startIndex, Int32 length, Encoding enc)
   at MySQL.?A0x985759bc.CppStringToNativeRaw(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* str)
   at MySQL.Grt.Db.Sql.SqlEditorWrapper.sql()
   at MySQL.GUI.Workbench.DbSqlEditor.OnPartialRefresh(Int32 what)
   at MySQL.Grt.RunWrappedDelegate1<void\,void\,int\,int\,MySQL::Grt::DelegateSlot1<void\,void\,int\,int>::ManagedDelegate>.native_callback(Int32* a1)
   at boost.detail.function.void_function_invoker1<void (__cdecl*)(int const &),void,int const &>.invoke(function_buffer* function_ptr, Int32* a0)
   at boost.function1<void,int const &>.()(function1<void\,int const \&>* , Int32* a0)
   at boost.detail.function.void_function_obj_invoker1<boost::function<void __cdecl(int const &)>,void,int>.invoke(function_buffer* function_obj_ptr, Int32 a0)
   at mforms.MenuItem.callback(MenuItem* )
   at MySQL.Forms.MenuItemImpl.menuItemClick(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)
[4 Jun 2012 23:46] Alfredo Kojima
Bug #65514 is a duplicate
[20 Jul 2012 7:31] Philip Olson
This has been fixed as of the soon-to-be-released Workbench 5.2.41, and the documentation for this bug report was combined with bug #55312 (Oracle bug #11762687)