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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.067 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.