Bug #72643 Sometime Connection lost while executing query.
Submitted: 14 May 2014 7:55 Modified: 10 Oct 2014 4:14
Reporter: Vimal Bera Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.1.4 OS:Windows (Microsoft build 9200, 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[14 May 2014 7:55] Vimal Bera 
Description:
12:44:07 [ERR][      Workbench]: Console redirection failed.
12:44:07 [INF][      WBContext]: Parsing application arguments.
12:44:07 [INF][      WBContext]:     C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe
12:44:07 [INF][      Workbench]: Starting up Workbench
12:44:07 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE\MySQLWorkbench.exe"
	CurrentDirectory: C:\Users\vimal.bera\Downloads
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: -1793504359
	UserInteractive: True
	Version: 4.0.30319.18010
	WorkingSet: 27566080
12:44:07 [INF][      Workbench]: Environment variables:
	Path = C:\Program Files (x86)\Common Files\NetSarang;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Perforce;C:\Program Files\Java\jdk1.7.0\/bin;C:\Program Files\Java\jdk1.7.0\/jre;E:\Program Files\apache-maven-2.2.1\bin;
	SESSIONNAME = Console
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	COMPUTERNAME = RSPLWS214
	PROCESSOR_ARCHITECTURE = x86
	ProgramW6432 = C:\Program Files
	PUBLIC = C:\Users\Public
	APPDATA = C:\Users\vimal.bera\AppData\Roaming
	windir = C:\Windows
	LOCALAPPDATA = C:\Users\vimal.bera\AppData\Local
	CommonProgramW6432 = C:\Program Files\Common Files
	USERDNSDOMAIN = RISHABH.COM
	AXIS2_HOME = C:\usr\local\axis2-1.4.1
	USERPROFILE = C:\Users\vimal.bera
	ProgramFiles = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	FP_NO_HOST_CHECK = NO
	HOMEPATH = \Users\vimal.bera
	DellClientSystemUpdatePath = C:\Program Files (x86)\Dell\ClientSystemUpdate\
	PROCESSOR_ARCHITEW6432 = AMD64
	USERNAME = Vimal.Bera
	NUMBER_OF_PROCESSORS = 4
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
	TMP = C:\Users\VIMAL~1.BER\AppData\Local\Temp
	ERLANG_HOME = C:\Program Files\erl5.10.4
	ComSpec = C:\Windows\system32\cmd.exe
	LOGONSERVER = \\RSDC003
	TEMP = C:\Users\VIMAL~1.BER\AppData\Local\Temp
	ProgramFiles(x86) = C:\Program Files (x86)
	USERDOMAIN = RISHABH
	CommonProgramFiles = C:\Program Files (x86)\Common Files
	JAVA_HOME = C:\Program Files\Java\jdk1.7.0\
	USERDOMAIN_ROAMINGPROFILE = RISHABH
	PROCESSOR_REVISION = 3c03
	SystemRoot = C:\Windows
	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:44:07 [INF][      Workbench]: Current version given by meta info is: 6.1.4
12:44:07 [INF][      Workbench]: This is the first start of a new version. Doing some clean up.
12:44:07 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files (x86)\Common Files\NetSarang;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Perforce;C:\Program Files\Java\jdk1.7.0\/bin;C:\Program Files\Java\jdk1.7.0\/jre;E:\Program Files\apache-maven-2.2.1\bin;
12:44:07 [INF][ mforms managed]: Initializing mforms wrapper
12:44:07 [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\vimal.bera\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:44:07 [INF][      WBContext]: WbContext::init
12:44:08 [INF][            grt]: Scanning module directory C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench\modules.	
12:44:08 [INF][            grt]: Scanning module directory ..	
12:44:08 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE/modules.	
12:44:09 [INF][            WBA]: Looking for extension modules for WBA...
12:44:09 [INF][            WBA]: 0 extension modules found
12:44:09 [WRN][            grt]: C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench\starters_settings.xml:10: link 'com.mysql.wb.starter.forums' <object > key= could not be resolved
12:44:09 [WRN][            grt]: C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench\starters_settings.xml: skipping element 'link' in unserialized document, line 10Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE.	
12:44:09 [WRN][            grt]: C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench\connections.xml:24: link '{2EA33392-F361-407B-B32E-479B23FECC1E}' <object GrtObject> key=owner could not be resolved
12:44:09 [WRN][            grt]: C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench\server_instances.xml:33: link '{606DB5BA-4B14-4A2C-8AC0-E830FA80F99A}' <object GrtObject> key=owner could not be resolved
12:44:09 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.1.4  revision 11773 build 1454
	Configuration Directory: C:\Users\vimal.bera\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.1 CE
	Cairo Version: 1.8.8
	OS: Microsoft  (build 9200), 64-bit
	CPU: 4x Intel(R) Core(TM) i5-4570 CPU @ 3.20GHz, 15.9 GiB RAM
	Active video adapter Intel(R) HD Graphics 4600
	Installed video RAM: -2016 MB
	Current video mode: 1440 x 900 x 4294967296 colors
	Used bit depth: 32
	Driver version: 9.18.10.3220
	Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igdumdim32,igd10iumd32,igd10iumd32
	Current user language: English (United States)

12:44:09 [INF][      Workbench]: UI is up
12:44:09 [INF][      Workbench]: Running the application
12:44:18 [INF][     SSH tunnel]: Starting tunnel
12:44:18 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: NO)
12:44:19 [INF][        WQE.net]: Launching SQL IDE
12:44:21 [INF][        WQE.net]: SQL IDE UI is ready
12:45:10 [INF][      WBContext]: Loaded 1/0 new non-MySQL connections
13:08:49 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'reader'@'192.168.15.214' (using password: NO)
13:08:54 [INF][          Admin]: Auto-created dummy instance profile for remote connection Stagging
13:08:54 [INF][        WQE.net]: Launching SQL IDE
13:08:55 [INF][        WQE.net]: SQL IDE UI is ready
13:09:26 [ERR][     AutoCCache]: Exception caught while updating column name cache for ice_cathkidston.edition_pages: SQL logic error or missing database
13:16:55 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'reader'@'192.168.15.214' (using password: NO)
13:17:04 [INF][          Admin]: Auto-created dummy instance profile for remote connection DB2Stage
13:17:04 [INF][        WQE.net]: Launching SQL IDE
13:17:04 [INF][        WQE.net]: SQL IDE UI is ready

How to repeat:
Connect to the remote sql server using workbench.
Query any table with where condition. ( where condition should be on non-indexed column.)
Execute the query. Displayed connection lost.
[14 May 2014 20:21] MySQL Verification Team 
Please check with mysql.exe client if you get timeout issue. Thanks.
[15 May 2014 3:32] Vimal Bera 
Sure. I will check today. It works sometimes when I execute the same query for 2-3 times.
[15 May 2014 12:55] Chuck Bell 
Not a utilities bug.
[11 Jun 2014 12:31] Paul Curwin 
I'm also having this odd issue.  I'll query a random tables in my remote database, and it'll say it "Lost connection to MySql Server", but then I query another table, and come back to the first query and it runs fine.  Very inconsistent.  I've reverted back to using Workbench 5.2 until this is resolved.  (I had upgraded to 6.1 for the extra featured, and hoping 6.1 wouldn't lock up on me, but I'd rather have it lock on me than tell me the connection isn't there when it is.)
[10 Sep 2014 4:14] Alfredo Kojima 
Please try the latest 6.2.2 version. Also, if it still occurs, see if the server is not killing connections for whatever reason (look at the error log in the server).
[11 Oct 2014 1: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".