Description:
Below is the error summary from the error window presented:
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.?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.WorkbenchMenuManager.menuItem_Click(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)
How to repeat:
Open a new SQL editor window, go to file, open SQL script. Choose the file then click open.
It has to be a large file, about 800.000 records.
Suggested fix:
Maybe look into memory problems to load large files. I work on standalone machine with 4Gb RAM. It wasn't suppose get errors, at least not memory issues.
