Bug #63031 Unable to do anything after Workbench crash.
Submitted: 31 Oct 2011 10:19 Modified: 1 Nov 2011 8:31
Reporter: Bengt Walther Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.3.35.7915 OS:Any
Assigned to: CPU Architecture:Any

[31 Oct 2011 10:19] Bengt Walther
Description:
Workbench crashed spontaneously without warning, after restarting its no longer possible to do start any of the instances in the server administration section. 

An error message turn up when I double click or in any other way try to start any of the instances. 

Error Starting Workbench Administrator
QueryError: Error executing ‘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 ‘plugins’ at line 1′
show plugins.
SQL Error: 1064

Remote management turned of, everything in the settings looks fine, connecting through HeidiSQL works perfectly. 

This is the error message in "system info" section.
##############################################
ctrl_be: Query Error Error executing '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 'plugins' at line 1'

show plugins.

SQL Error: 1064

Traceback (most recent call last):

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 125, in do_open_administrator

    adminTab = AdministratorTab(server_instance)

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_grt.py", line 65, in __init__

    self.ctrl_be.init()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 363, in init

    self.connect_sql()

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 588, in connect_sql

    result = self.exec_query("show plugins")

  File "C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_control.py", line 653, in exec_query

    raise e

QueryError: Error executing '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 'plugins' at line 1'

show plugins.

SQL Error: 1064

##############################################

This is the actual system info. 

MySQL Workbench CE for Windows version 5.2.35

Configuration Directory: C:\Users\<removed>\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files (x86)\MySQL\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 Service Pack 1 (build 7601), 64-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8800  @ 2.66GHz, 4.0 GiB RAM

Active video adapter: NVIDIA GeForce GTX 260M

Installed video RAM: 1024 MB

Current video mode: 1920 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 8.17.12.6089

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

Current user language: Svenska (Sverige)
##############################################

How to repeat:
Invoke a spontaneous crash without error message (!?!?) Restart MySQL Workbench
[31 Oct 2011 10:21] Bengt Walther
upgraded to S2, since it is Serious...
[31 Oct 2011 13:02] Valeriy Kravchuk
This is probably a duplicate of bug #62549 (if your instances are 5.0.x). Please, check.
[1 Nov 2011 8:31] Bengt Walther
yep, it´s a duplicate of bug #62549. Closing.