Bug #51725 Out of Memory: Tried to open .sql dump of large database
Submitted: 4 Mar 2010 15:14 Modified: 29 Mar 2010 18:50
Reporter: David Walling Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.16 OS:Windows
Assigned to: CPU Architecture:Any

[4 Mar 2010 15:14] David Walling
Description:
Exception = System.OutOfMemoryException
Message = Exception of type 'System.OutOfMemoryException' was thrown.
FullText = System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.String.Replace(String oldValue, String newValue)
   at MySQL.?A0x8e6a07a1.CppStringToNative(basic_string<char\,std::char_traits<char>\,std::allocator<char> >* str)
   at MySQL.Grt.Db.Sql.Sql_editor.sql()
   at MySQL.GUI.Workbench.DbSqlEditor.OnPartialRefresh(Int32 what)
   at MySQL.Grt.DelegateSlot1<void\,void\,int\,int>.cpp_callback(Int32* a1)
   at sigc.pointer_functor1<int const &,void>.()(pointer_functor1<int const \&\,void>* , Int32* _A_a1)
   at sigc.adaptor_functor<sigc::pointer_functor1<int const &,void> >.operator()<int const &>(adaptor_functor<sigc::pointer_functor1<int const \&\,void> >* , Int32* _A_arg1)
   at sigc.internal.slot_call1<sigc::pointer_functor1<int const &,void>,void,int>.call_it(slot_rep* rep, Int32* a_1)
   at sigc.slot1<void,int>.()(slot1<void\,int>* , Int32* _A_a1)
   at sigc.adaptor_functor<sigc::slot<void,int,sigc::nil,sigc::nil,sigc::nil,sigc::nil,sigc::nil,sigc::nil> >.operator()<int const &>(adaptor_functor<sigc::slot<void\,int\,sigc::nil\,sigc::nil\,sigc::nil\,sigc::nil\,sigc::nil\,sigc::nil> >* , Int32* _A_arg1)
   at sigc.internal.slot_call1<sigc::slot<void,int,sigc::nil,sigc::nil,sigc::nil,sigc::nil,sigc::nil,sigc::nil>,void,int const >.call_it(slot_rep* rep, Int32* a_1)
   at wb.CommandUI.activate_command(CommandUI* , basic_string<char\,std::char_traits<char>\,std::allocator<char> >* )
   at MySQL.Workbench.WbContext.activate_command(String name)
   at MySQL.GUI.Workbench.WorkbenchToolbarManager.toolbarItem_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripButton.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.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.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)

How to repeat:
Open a large .sql file (mine is 97 MB).
[10 Mar 2010 10:32] Susanne Ebrecht
Do you also get an error message when you try to load the while into the MySQL Server without using Workbench?
[10 Mar 2010 14:40] David Walling
Could you clarify the question?  It crashes trying to open temp.sql in the Workbench SQL editor.  I can open that file in MySQL Query Browser just fine.
[29 Mar 2010 18:50] MySQL Verification Team
Duplicate of bug: http://bugs.mysql.com/bug.php?id=51606.