Bug #60411 cannot run any sql on MySQL Workbench 5.2 CE
Submitted: 10 Mar 2011 7:35 Modified: 13 Jun 2011 16:30
Reporter: Dennis Cheung Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:5.2.32, 5.2.33b OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[10 Mar 2011 7:35] Dennis Cheung
Description:
Keep showing a message of "External component has thrown an exception."

Cannot execute any SQL.

----

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 bec.GRTManager.flush_timers(GRTManager* )
   at MySQL.Workbench.WbContext.flush_timers()
   at MySQL.GUI.Workbench.MainForm.timer_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
open the tool, open a ssh tunneled mysql connection, run any sql
[14 Mar 2011 17:52] Rafael Antonio Bedoy Torres
Please, send the results of Help > System Info menu item. What version of server are you working with?
[18 Mar 2011 2:47] Dennis Cheung
MySQL Workbench CE for Windows version 5.2.32

Configuration Directory: C:\Documents and Settings\Dennis Cheung\Application Data\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is not available on this system, so GDI is used for rendering.

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 2x Intel(R) Core(TM)2 Duo CPU     E6550  @ 2.33GHz, 1.0 GiB RAM

Active video adapter: NVIDIA GeForce 6200 TurboCache(TM)

Installed video RAM: 32 MB

Current video mode: 1280 x 1024 x 4294967296 colors

Used bit depth: 32

Driver version: 6.14.10.9381

Installed display drivers: igxprd32.dll

Current user language: English (United States)

---------
working with server 5.5.4-m3
[22 Mar 2011 18:27] Valeriy Kravchuk
Please, check if the same problem happens with a newer version, 5.2.33b.
[5 Apr 2011 20:27] Alfredo Kojima
Please also tell whether your connection name has any non-alphanumeric/space characters.
[6 Apr 2011 1:35] Dennis Cheung
The problem preside in version 5.2.33b.
The connection name does contain non-alphanumeric/space characters.

The default schema might left unset to reproduce the problem.
If I specify a database name in the connection manager, can work in some cases.
[19 Apr 2011 16:44] Steve Rutkowski
I'm having the same problem.  Everytime I try to do a query I get an error window that pops up and says, "External component has thrown an exception".  I'm running  MySQL Workbench 5.2 CE.

Is there a fix for his issue?

Thanks
[12 May 2011 12:55] Alfredo Kojima
Can you try a 5.2.34-pre1 TEST binary from ftp://ftp.mysql.com/pub/mysql/download/gui-tools/snapshot/  and report if that problem is solved?
[12 May 2011 13:19] Dennis Cheung
@Alfredo Kojima

I cannot try. Because I cannot download

Command:	PASV
Response:	500 OOPS: vsf_sysutil_bind
Command:	PORT 0,0,0,0,17,208
Error:	Could not write to socket: ECONNRESET - Connection reset by peer
Error:	Disconnected from server
Error:	Failed to retrieve directory listing
[12 May 2011 13:23] Alfredo Kojima
What about ftp://ftp.mysql.com/pub/mysql/download/gui-tools/snapshot/mysql-workbench-gpl-5.2.34-pre1-...
[13 Jun 2011 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".