Bug #71871 MySQL Workbench Bugs
Submitted: 27 Feb 2014 21:52 Modified: 5 Mar 2014 17:29
Reporter: Roland S Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.0 OS:Windows (Windows 7)
Assigned to: CPU Architecture:Any
Tags: bug, crash

[27 Feb 2014 21:52] Roland S 
Description:
MySQL Workbench consistently bugs out for no apparent reason. I have an average of 4 query tabs and at most 2 connections open, and it seems that every other day Workbench craps out on me for unknown reasons. No error or anything, just a "report this bug" dialogue and a BIG RED "X". Also, the database migration tool doesn't work through SSH tunneling in Workbench, which makes no sense whatsoever. I used to love MySQL and I appreciate that Workbench is a free, not-quite-open-source db management tool, but the bugs on top of Oracle as a company have chased me away from Workbench and MySQL. Will most likely be using Navicat with MariaDB for all future projects. So long and thanks for all the fish.

How to repeat:
Use MySQL workbench for a few days

Suggested fix:
Buy Navicat
[27 Feb 2014 21:59] Roland S 
The standard "MySQL Workbench Broke" error message

Attachment: MySQL Workbench.png (image/png, text), 478.22 KiB.
[27 Feb 2014 22:00] Roland S 
MySQL Workbench Error Message

Attachment: MySQL Workbench.png (image/png, text), 355.38 KiB.
[27 Feb 2014 22:22] Roland S 
I will say that the Autosave feature in Workbench is nice. Without this I would lose my mind.
[28 Feb 2014 16:32] MySQL Verification Team 
Sorry to hear you had problems, we'd be happy to engage you further to
identify and fix them. Please provide the exactly Workbench version 6.0.X
and the MySQL Server version. Thanks.
[28 Feb 2014 16:42] Roland S 
Hi, 

I am running Workbench on a Windows 7 workstation, MySQL DB is located on an Ubuntu 12.04 server.

MySQL Workbench version 6.0.8.11354 build 833
MySQL Version 5.5.34-0ubuntu0.12.04.1-log
[3 Mar 2014 20:06] Alfredo Kojima 
Can you send the wb.log file generated by WB when a crash like that happens?
[5 Mar 2014 14:28] MySQL Verification Team 
Thank you for the feedback. Are you able to provide what Alfredo requested?. Thanks.
[5 Mar 2014 17:29] Roland S 
Hi, 

I was just irked because WB kept crashing, it is in fact a great product, among the best freeware of its kind. 
This is most likely a bug on our end (probably with our indexing), as we are dealing with an inherited mess of databases. Relevant portion of wb.log is pasted below, but I am closing this out as I don't think it is an issue with the software and don't wish to waste any more of your time.

Thank you!

10:37:14 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group REGEXP 'Intelligent Hearing Systems' , Group, '') AS Group , IF(Group_ID R' at line 1Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Exception = System.ArgumentOutOfRangeException
Message = Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
FullText = System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at MySQL.Controls.FlatTabControl.SetBusy(Int32 index, Boolean busy)
   at MySQL.GUI.Workbench.SqlIdeForm.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.ToolBarItem.callback(ToolBarItem* )
   at MySQL.Forms.ToolBarItemImpl.OnItemActivation(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)
13:41:28 [ERR][      Workbench]: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
Exception = System.ArgumentOutOfRangeException
Message = Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
FullText = System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.ThrowHelper.ThrowArgumentOutOfRangeException()
   at MySQL.Controls.FlatTabControl.SetBusy(Int32 index, Boolean busy)
   at MySQL.GUI.Workbench.SqlIdeForm.AfterExecSql()
   at MySQL.Grt.RunWrappedDelegate0<int\,int\,MySQL::Grt::DelegateSlot0<int\,int>::ManagedDelegate>.native_callback()
   at boost.detail.function.function_invoker0<int (__cdecl*)(void),int>.invoke(function_buffer* function_ptr)
   at wb.WBContext.flush_idle_tasks(WBContext* )
   at MySQL.Workbench.WbContext.flush_idle_tasks()
   at MySQL.GUI.Workbench.Program.timer_Tick(Object sender, EventArgs e)
13:56:53 [INF][        WQE.net]: Shutting down SQL editor (Viper)
13:56:53 [ERR][      Workbench]: Object reference not set to an instance of an object.
Exception = System.NullReferenceException
Message = Object reference not set to an instance of an object.
FullText = System.NullReferenceException: Object reference not set to an instance of an object.
   at MySQL.GUI.Workbench.SqlIdeForm.closeEditorTab(TabPage page)
   at MySQL.GUI.Workbench.SqlIdeForm.Destroy()
   at MySQL.GUI.Workbench.SqlIdeForm.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)
13:57:36 [INF][        WQE.net]: Shutting down SQL editor (Viper)
13:57:36 [ERR][      Workbench]: Object reference not set to an instance of an object.
Exception = System.NullReferenceException
Message = Object reference not set to an instance of an object.
FullText = System.NullReferenceException: Object reference not set to an instance of an object.
   at boost.shared_ptr<Sql_editor>.{ctor}(shared_ptr<Sql_editor>* , shared_ptr<Sql_editor>* )
   at MySQL.GUI.Workbench.SqlEditorFormWrapper.sql_editor_index(SqlEditorWrapper editor)
   at MySQL.GUI.Workbench.SqlIdeForm.EditorIndexFromTabPage(TabPage page)
   at MySQL.GUI.Workbench.SqlIdeForm.Destroy()
   at MySQL.GUI.Workbench.SqlIdeForm.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at System.Windows.Forms.Control.Dispose(Boolean disposing)
   at System.ComponentModel.Component.Dispose()
   at MySQL.Controls.FlatTabControl.CloseTabPage(TabPage page)
   at MySQL.Controls.FlatTabControl.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.TabControl.WndProc(Message& m)
   at MySQL.Controls.FlatTabControl.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)