MySQL Bugs: #61363: Error opening .sql

Bug #61363	Error opening .sql
Submitted:	31 May 2011 16:38	Modified:	22 Jul 2012 18:33
Reporter:	David Lopez Zajara	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.34 CE	OS:	Windows (Windows 7 x86_64)
Assigned to:		CPU Architecture:	Any

Description:
Opening a correct .sql file (created with mysqldump 10.11) but very big (~64mb) the workbench start to generate an error. The bug screen appears several times and between these screens the workbench has unusable.

How to repeat:
I think who can repeat these error opening a similar size file.

Thank you for the bug report.

Hello David,

trying to reproduce the problem with the file you stated ends up with an err message in the log-textbox, but no bug-dialog or other error messages.
the Error in the log is "no database selected" which originates in the dump file missing the "create database <databasename>;" and "use <databasename>" statements ... once i add these two lines, i can successfully import the file.

can you please recreate the problem again and if the bug-dialog appears right-click and copy stack information, then add it to this report? please also add the output of workbenchs help->system info cmd on your machine.

thanks

Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
   at new(UInt32 )
   at std._Allocate<char>(UInt32 _Count, SByte* __unnamed001)
   at std.allocator<char>.allocate(allocator<char>* , UInt32 _Count)
   at std.basic_string<char,std::char_traits<char>,std::allocator<char> >._Copy(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , UInt32 _Newsize, UInt32 _Oldlen)
   at std.basic_string<char,std::char_traits<char>,std::allocator<char> >._Grow(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , UInt32 _Newsize, Boolean _Trim)
   at std.basic_string<char,std::char_traits<char>,std::allocator<char> >.assign(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , SByte* _Ptr, UInt32 _Count)
   at std.basic_string<char,std::char_traits<char>,std::allocator<char> >.assign(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , SByte* _Ptr)
   at std.basic_string<char,std::char_traits<char>,std::allocator<char> >.{ctor}(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , SByte* _Ptr)
   at MySQL.?A0x3cf752a2.NativeToCppStringRaw(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , String str)
   at MySQL.Grt.Db.Sql.Sql_editor.sql(String sql)
   at MySQL.Grt.Db.Sql.SqlEditor.TextModified(Object sender, TextModifiedEventArgs e)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at ScintillaNet.Scintilla.OnTextInserted(TextModifiedEventArgs e)
   at ScintillaNet.Scintilla.FireModified(NativeScintillaEventArgs ea)
   at ScintillaNet.Scintilla.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)

Crash message

Attachment: crash_dialog.png (image/png, text), 237.75 KiB.

MySQL Workbench CE for Windows version 5.2.33

Configuration Directory: C:\Users\miguel\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.10600 Compatibility Profile Context

OS: Microsoft Windows Vista Ultimate Edition Service Pack 2 (build 6002), 64-bit

CPU: 4x AMD Phenom(tm) 9650 Quad-Core Processor, 8.0 GiB RAM

Active video adapter: ATI Radeon HD 4650

Installed video RAM: 1024 MB

Current video mode: 1920 x 1080 x 4294967296 colors

Used bit depth: 32

Driver version: NULL

Installed display drivers: aticfx64.dll,aticfx64.dll,aticfx32,aticfx32,atiumd64.dll,atidxx64.dll,atiumdag,atidxx32,atiumdva,atiumd6a.cap,atitmm64.dll

Current user language: Portuguese (Brazil)

Sorry prior stacktrace was 5.2.33. Below 5.2.34 backtrace:

Exception = System.InvalidOperationException
Message = Value Dispose() cannot be called while doing CreateHandle().
FullText = System.InvalidOperationException: Value Dispose() cannot be called while doing CreateHandle().
   at System.Windows.Forms.Control.Dispose(Boolean disposing)
   at Aga.Controls.Tree.TreeViewAdv.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at System.Windows.Forms.Control.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at MySQL.Forms.ObjectImpl.~ObjectImpl()
   at MySQL.Forms.ViewImpl.Dispose(Boolean )
   at MySQL.Forms.ObjectImpl.Dispose()
   at MySQL.Forms.ViewImpl.destroy(View* self)
   at MySQL.MCallback1<void\,mforms::View \*>.cpp_callback(View* arg1)
   at boost.detail.sp_counted_base.release(sp_counted_base* )
   at MySQL.GUI.Workbench.Db_sql_editor.~Db_sql_editor()
   at MySQL.GUI.Workbench.Db_sql_editor.Dispose(Boolean )
   at MySQL.Grt.UIForm.Dispose()
   at MySQL.GUI.Workbench.DbSqlEditor.Destroy()
   at MySQL.GUI.Workbench.DbSqlEditor.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at System.Windows.Forms.Form.WmClose(Message& m)
   at System.Windows.Forms.Form.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)

This has been fixed as of the soon-to-be-released Workbench 5.2.41. Related bugs include: #55312 and #64186