Bug #72507 Repeated crashing of Workbench 6.1 on two different servers
Submitted: 1 May 2014 21:14 Modified: 22 May 2014 14:48
Reporter: Martin O'Shea Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.1.4 OS:Windows (Microsoft Windows 7 Service Pack 1 build 7601, 32-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[1 May 2014 21:14] Martin O'Shea
Description:
I have installed MySQL Workbench 6.1 on two different Windows 7 64 bit servers, each with 8Gb memory and good processors. 

The usual pattern of this incident is that:

i.   I log into Workbench via a MySQL Connection. 
ii.  The schemae load but his can take several minutes because my schemae have several thousand tables, each of which may contain several hundred columns but only about 1500 records. 
iii. If I run a simple, single table query, Workbench crashes. 

This issue has never occurred in previous Workbench instances. Query Browser works fine. 

The following is an instance of a Workbench log today:

	12:33:08 [ERR][      Workbench]: Console redirection failed.
	12:33:08 [INF][      WBContext]: Parsing application arguments.
	12:33:08 [INF][      WBContext]:     C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe
	12:33:08 [INF][      Workbench]: Starting up Workbench
	12:33:08 [INF][      Workbench]: Current environment:
		Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe" 
		CurrentDirectory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
		HasShutdownStarted: False
		OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
		SystemDirectory: C:\Windows\system32
		TickCount: 1905433386
		UserInteractive: True
		Version: 4.0.30319.18444
		WorkingSet: 27435008
	12:33:08 [INF][      Workbench]: Environment variables:
		Path = C:\Perl64\site\bin;C:\Perl64\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Sun\JavaDB\bin;C:\Condor\bin\;C:\CONDOR\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Graphviz 2.28\bin
		SESSIONNAME = RDP-Tcp#0
		PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
		USERDOMAIN = nismes
		PROCESSOR_ARCHITECTURE = x86
		ProgramW6432 = C:\Program Files
		DERBY_HOME = C:\Program Files (x86)\Sun\JavaDB
		APPDATA = C:\Users\mrgraverol.nismes.000\AppData\Roaming
		windir = C:\Windows
		LOCALAPPDATA = C:\Users\mrgraverol.nismes.000\AppData\Local
		CommonProgramW6432 = C:\Program Files\Common Files
		windows_tracing_flags = 3
		windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
		TMP = C:\Users\mrgraverol~2.000\AppData\Local\Temp
		USERPROFILE = C:\Users\mrgraverol.nismes.000
		ProgramFiles = C:\Program Files (x86)
		PROCESSOR_LEVEL = 21
		FP_NO_HOST_CHECK = NO
		HOMEPATH = \Users\mrgraverol.nismes.000
		COMPUTERNAME = nismes
		PROCESSOR_ARCHITEW6432 = AMD64
		USERNAME = mrgraverol
		NUMBER_OF_PROCESSORS = 4
		PROCESSOR_IDENTIFIER = AMD64 Family 21 Model 2 Stepping 0, AuthenticAMD
		SystemRoot = C:\Windows
		ComSpec = C:\Windows\system32\cmd.exe
		LOGONSERVER = \\nismes
		TEMP = C:\Users\mrgraverol~2.000\AppData\Local\Temp
		ProgramFiles(x86) = C:\Program Files (x86)
		CommonProgramFiles = C:\Program Files (x86)\Common Files
		JAVA_HOME = C:\Program Files\Java\jdk1.6.0_26
		PUBLIC = C:\Users\Public
		PROCESSOR_REVISION = 0200
		CLIENTNAME = thebox
		CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
		ALLUSERSPROFILE = C:\ProgramData
		SystemDrive = C:
		PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\
		OS = Windows_NT
		ProgramData = C:\ProgramData
		HOMEDRIVE = C:
	12:33:08 [INF][      Workbench]: Current version given by meta info is: 6.1.4
	12:33:09 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Perl64\site\bin;C:\Perl64\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Sun\JavaDB\bin;C:\Condor\bin\;C:\CONDOR\bin;C:\Program Files (x86)\Git\cmd;C:\Program Files (x86)\Graphviz 2.28\bin
	12:33:09 [INF][ mforms managed]: Initializing mforms wrapper
	12:33:10 [INF][   WBContext UI]: Initializing workbench context UI with these values:
		base dir: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
		plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
		struct path: 
		module path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules
		library path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
		user data dir: C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench
		open at start: 
		open type: 
		run at startup: 
		run type: 
		Force SW rendering: No
		Force OpenGL: No
		quit when done: No
	12:33:10 [INF][      WBContext]: WbContext::init
	12:33:11 [INF][            grt]: Scanning module directory C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\modules.	
	12:33:11 [INF][            grt]: Scanning module directory ..	
	12:33:12 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules.	
	12:33:19 [INF][            WBA]: Looking for extension modules for WBA...
	12:33:19 [INF][            WBA]: 0 extension modules found
	12:33:19 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE.	
	12:33:20 [WRN][            grt]: C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\connections.xml:18: link '{32E6E0AB-6332-4ED3-B9CA-24F39DAEAC5E}' <object GrtObject> key=owner could not be resolved
	12:33:21 [INF][      WBContext]: System info:
		MySQL Workbench Community (GPL) for Windows version 6.1.4  revision 11773 build 1454
		Configuration Directory: C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench
		Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
		Cairo Version: 1.8.8
		OS: Microsoft Windows 7  Service Pack 1 (build 7601), 64-bit
		CPU: 4x AMD Opteron(tm) Processor 6376                 , 8.0 GiB RAM
		Active video adapter Standard VGA Graphics Adapter
		Installed video RAM: 0 MB
		Current video mode: NULL
		Used bit depth: NULL
		Driver version: 6.1.7600.16385
		Installed display drivers: NULL
		Current user language: English (United Kingdom)

	12:33:21 [INF][    WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\Local_instance_MySQL-2.autosave
	12:33:21 [INF][    WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\schemaa-1.autosave
	12:33:21 [INF][    WQE backend]: Found auto-save workspace C:\Users\mrgraverol.nismes.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\schemab-1.autosave
	12:33:21 [INF][      Workbench]: UI is up
	12:33:21 [INF][      Workbench]: Running the application
	12:34:02 [INF][     SSH tunnel]: Starting tunnel
	12:34:03 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
	12:34:04 [INF][        WQE.net]: Launching SQL IDE
	12:34:05 [INF][        WQE.net]: SQL IDE UI is ready
	12:36:03 [ERR][     AutoCCache]: Exception during update of cache for 'schemab
	_dm_18840_491500_05112013_1383674775155_keyword_frequencies': Insufficient memory: cannot create MySQL handle using mysql_init()

A second error follows:

12:40:05 [INF][      Workbench]: UI is up
12:40:06 [INF][      Workbench]: Running the application
12:42:29 [INF][     SSH tunnel]: Starting tunnel
12:42:29 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
12:42:31 [INF][        WQE.net]: Launching SQL IDE
12:42:32 [INF][        WQE.net]: SQL IDE UI is ready
12:44:51 [ERR][     AutoCCache]: Exception during update of cache for 'schemab
_dm_19115_164440_06112013_1383754574216_keyword_frequencies': Malformed packet
12:45:07 [ERR][     AutoCCache]: Exception during update of cache for 'schemab
_dm_19273_810672_07112013_1383847714168_keyword_frequencies': Malformed packet

Any information would be helpful here.

Thanks

Martin O'Shea.

How to repeat:
I am unsure what to say here because I do not know how it could be repeated without use of my database schemae. Although maybe a table of several hundred mixed text and numeric columns and about 1500 records would suffice despite queries on more conventional tables also suffering the crashing.

The log files refer to different tables in one of the schemae and apparently different causes.
[1 May 2014 21:15] Martin O'Shea
This issue has been raised in the MySQL Workbench forum at:

http://forums.mysql.com/read.php?152,613226,613226
[1 May 2014 22:28] MySQL Verification Team
Thank you for the bug report. Please elaborate in number of word 'several': have several thousand tables, each of which may contain several hundred columns. Thanks.
[1 May 2014 23:10] Martin O'Shea
Concerning my use of the term 'several', one particular schema of mine stores some 4700 tables. About 4500 of these are made up of up to 600 columns and approximately 15000 rows.

Workbench fails when this schema is queried, but this occurs only when the tables for the schema are loaded into the Navigator.
[14 May 2014 15:04] Philip Nelson
I am having the same issue. I have narrowed it down to the connection using ssl if available option in the connection. With the ssl option I get app crash consistently. Without I don't crash, but sometimes get Error Code: 2013 Lost connection to MySQL server during query. In my case it is happening querying an Amazon RDS instances. These same instances all worked with this version of workbench for the prior 2 days when I installed it. Other users with an earlier 6.1 version of workbench are fine, and users are also fine with a 6.0 version, all using ssl.
[14 May 2014 22:36] Martin O'Shea
I don't have need to use SSL normally when connecting to Workbench. I am administrator of my two servers and I also log into Workbench as 'root' anyway.

But I have just tried SSL in my connections to Workbench and my queries continue to fail, even for tables with only a few hundred records. As before, Workbench simply crashes with:

23:06:02 [INF][    WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\Local_instance_MySQL-2.autosave
23:06:02 [INF][    WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\myDataSharer-1.autosave
23:06:02 [INF][    WQE backend]: Found auto-save workspace C:\Users\madmin.rzone.000\AppData\Roaming\MySQL\Workbench\sql_workspaces\visualRSS-1.autosave
23:06:02 [INF][      Workbench]: UI is up
23:06:03 [INF][      Workbench]: Running the application
23:06:15 [INF][     SSH tunnel]: Starting tunnel
23:06:16 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
23:06:16 [INF][        WQE.net]: Launching SQL IDE
23:06:18 [INF][        WQE.net]: SQL IDE UI is ready
23:13:36 [ERR][     AutoCCache]: Exception during update of cache for 'schemaA
_dm_19284_591305_07112013_1383849338694_keyword_frequencies': Malformed packet
23:13:45 [ERR][     AutoCCache]: Exception during update of cache for 'schemaA
_dm_19366_349975_13112013_1384362718663_keyword_frequencies': Malformed packet

The data in both of the tables referred to in the messages above appears to be intact. 

So for the moment I am using Query Browser.
[22 May 2014 14:48] Marcin Szalowicz
This is a duplicate of bug #72486
[25 Jun 2014 13:02] Robert Mouat
I am seeing similar problems.  I am running 6.1.6 on windows 7 64bit with 8GB RAM.  I am connecting to MySQL 5.1.69 hosted on Amazon RDS.

I get a repeatable crash by doing the following:
* start workbench
* connect to database as root (using SSL and password)
* 'use myschema'
* 'select * from MYTABLE'

I have a workaround.  It doesn't crash if I run 'desc MYTABLE' before the select query.

In the logs I see a dozen errors of the form:

13:44:52 [ERR][     AutoCCache]: Exception during update of cache for 'myschema
MYTABLE': Insufficient memory: cannot create MySQL handle using mysql_init()
[30 Sep 2014 16:17] wes romero
I am also facing the same issue when running MySQL Workbench. I'll run a simple SELECT * FROM Table1 WHERE Column1 = 'email@email.com'; and then it will crash.

Faulting application name: MySQLWorkbench.exe, version: 6.1.6.11834, time stamp: 0x53729aea
Faulting module name: ntdll.dll, version: 6.1.7601.18247, time stamp: 0x521ea8e7
Exception code: 0xc0000005
Fault offset: 0x000337a2
Faulting process id: 0x1090
Faulting application start time: 0x01cfdcc88c67d2e9
Faulting application path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll
Report Id: d9a507ca-48bb-11e4-ac22-5c514f932154

Application: MySQLWorkbench.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: exception code c0000005, exception address 772E37A2
Stack: