MySQL Bugs: #60949: Cannot run query against remote MySQL database

Bug #60949	Cannot run query against remote MySQL database
Submitted:	21 Apr 2011 18:06	Modified:	21 Apr 2011 20:50
Reporter:	John Pozzoli	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.33 CE r7508	OS:	Windows (Win7, SP1 64-bit)
Assigned to:		CPU Architecture:	Any

Description:
I have a MySQL server (5.1.49-3-log (Debian)) running on Debian inside VMware Workstation on my local machine. When I run MySQL Workbench, I can contact the server, work with schemas, create and drop tables, etc. However, whenever I try to execute a query - any query - I get the error pop-up. "MySQL Workbench has encountered a problem - External component has thrown an exception"

How to repeat:
Trying to submit a query.

I am having the same problem with remote connections. No problem with local database connections. I've tried running query when connected to;
Mysql 5.0.32 running on Debian etch,
Mysql 5.0.45 running on Windows 2008 server.

Help->system_info output;
-------------------------

MySQL Workbench CE for Windows version 5.2.33

Configuration Directory: C:\Users\Cem\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files\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.0

OS: Microsoft Windows 7 Ultimate Edition (build 7600), 32-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8400  @ 2.26GHz, 3.0 GiB RAM

Active video adapter: NVIDIA GeForce 9200M GS    

Installed video RAM: 256 MB

Current video mode: 1280 x 800 x 4294967296 colors

Used bit depth: 32

Driver version: 8.17.12.6099

Installed display drivers: nvd3dum.dll,nvwgf2um.dll,nvwgf2um.dll

Current user language: Turkish (Turkey)

MySQL Workbench CE for Windows version 5.2.33

Configuration Directory: C:\Users\Cem\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files\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.0

OS: Microsoft Windows 7 Ultimate Edition (build 7600), 32-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8400  @ 2.26GHz, 3.0 GiB RAM

Active video adapter: NVIDIA GeForce 9200M GS    

Installed video RAM: 256 MB

Current video mode: 1280 x 800 x 4294967296 colors

Used bit depth: 32

Driver version: 8.17.12.6099

Installed display drivers: nvd3dum.dll,nvwgf2um.dll,nvwgf2um.dll

Current user language: Turkish (Turkey)

Stack_trace output;
-------------------

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 Db_sql_editor.exec_sql(Db_sql_editor* , basic_string<char\,std::char_traits<char>\,std::allocator<char> >* , shared_ptr<Sql_editor>* , Boolean , Boolean , Boolean )
   at MySQL.GUI.Workbench.Db_sql_editor.exec_sql(String sql, Boolean active_editor, Boolean wrap_with_non_std_delimiter)
   at MySQL.GUI.Workbench.DbSqlEditor.DoExecuteSqlScript(Boolean currentStatementOnly)
   at MySQL.GUI.Workbench.DbSqlEditor.ExecuteSqlScript()
   at MySQL.Grt.RunWrappedDelegate0<void\,void\,MySQL::Grt::DelegateSlot0<void\,void>::ManagedDelegate>.native_callback()
   at sigc.pointer_functor0<void>.()(pointer_functor0<void>* )
   at sigc.adaptor_functor<sigc::pointer_functor0<void> >.()(adaptor_functor<sigc::pointer_functor0<void> >* )
   at sigc.internal.slot_call0<sigc::pointer_functor0<void>,void>.call_it(slot_rep* rep)
   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)

What are the names of the connections that cause trouble?

Do you mean name of the connections by this?

connection names; xx.xx.xx.xx/dbname

removing ip from connection name fixes the problem

Changed my connection to the server name/schema: WEBDEV-01/RightSite

Still get the failure when trying to run a query. I also have standard/TCP/IP and no other options selected (all default).

The problem is the slash. Any character in the connection name that cannot be used in a filename will cause the error to appear. Dots and spaces are ok, / and : are not (among others)

This is a duplicate of bug #60700

Excellent. Removing the slash in the connection name fixed the issue.