MySQL Bugs: #87014: Query runnning and fetching forever then workbench "Not responding" and crashing

Bug #87014	Query runnning and fetching forever then workbench "Not responding" and crashing
Submitted:	11 Jul 2017 13:48	Modified:	6 Sep 2017 10:06
Reporter:	Rachel Hooper	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	6.3.9	OS:	Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\rhooper\AppData\Roaming\MySQL\Workbench\log\wb.log]

I dont think this log has the failure shown because the entire program crashed and restarted.

09:43:05 [ERR][      Workbench]: Console redirection failed.
09:43:05 [INF][      Workbench]: Starting up Workbench
09:43:05 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 859908
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 36081664
09:43:05 [INF][      Workbench]: Environment variables:
	SystemDrive = C:
	ProgramFiles(x86) = C:\Program Files (x86)
	USERDNSDOMAIN = NAMERICA.IDEXXI.COM
	ProgramW6432 = C:\Program Files
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 78 Stepping 3, GenuineIntel
	TMP = C:\Users\rhooper\AppData\Local\Temp
	PROCESSOR_ARCHITECTURE = AMD64
	ComSpec = C:\WINDOWS\system32\cmd.exe
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	PROCESSOR_REVISION = 4e03
	TEMP = C:\Users\rhooper\AppData\Local\Temp
	USERPROFILE = C:\Users\rhooper
	LOGONSERVER = \\WME-NADC2
	USERNAME = rhooper
	SystemRoot = C:\WINDOWS
	__COMPAT_LAYER = DisableUserCallbackException
	SNOW_INVENTORY_HOME = C:\Program Files\INVENTORYCLIENT\
	FP_NO_HOST_CHECK = NO
	CommonProgramFiles = C:\Program Files\Common Files
	UATDATA = C:\WINDOWS\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
	ProgramData = C:\ProgramData
	windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
	HOMEPATH = \Users\rhooper
	COMPUTERNAME = IDME-C4WQGC2
	ALLUSERSPROFILE = C:\ProgramData
	CommonProgramW6432 = C:\Program Files\Common Files
	windows_tracing_flags = 3
	SNC_LIB = C:\WINDOWS\SysWOW64\cgsskrb5.dll
	SESSIONNAME = Console
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	HOMEDRIVE = C:
	windir = C:\WINDOWS
	NUMBER_OF_PROCESSORS = 4
	OS = Windows_NT
	ProgramFiles = C:\Program Files
	ANT_WEAVER_HOME = C:\Workspace\ant-weaver\src
	JAVA_HOME = C:\Program Files\Java\jdk1.8.0_101
	PSModulePath = C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\;c:\Program Files\Microsoft Security Client\MpProvider\
	APPDATA = C:\Users\rhooper\AppData\Roaming
	USERDOMAIN = WESTBROOK
	PROCESSOR_LEVEL = 6
	ANT_HOME = C:\Tools\apache-ant-1.9.7
	LOCALAPPDATA = C:\Users\rhooper\AppData\Local
	ANT_OPTS = -Xmx256M
	Path = C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Tools\apache-ant-1.9.7\bin;C:\Program Files\Java\jdk1.8.0_101\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files\IDM Computer Solutions\UltraEdit;C:\Program Files\IDM Computer Solutions\UltraCompare;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\rhooper\AppData\Local\atom\bin
	PUBLIC = C:\Users\Public
09:43:05 [INF][      Workbench]: Current version given by meta info is: 6.3.9
09:43:05 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\Tools\apache-ant-1.9.7\bin;C:\Program Files\Java\jdk1.8.0_101\bin;C:\ProgramData\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files\IDM Computer Solutions\UltraEdit;C:\Program Files\IDM Computer Solutions\UltraCompare;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Users\rhooper\AppData\Local\atom\bin
09:43:05 [INF][ mforms managed]: Initializing mforms wrapper
09:43:05 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	user data dir: C:\Users\rhooper\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
09:43:05 [INF][      WBContext]: WbContext::init
09:43:06 [INF][            WBA]: Looking for extension modules for WBA...
09:43:06 [INF][            WBA]: 0 extension modules found
09:43:06 [WRN][            grt]: C:\Users\rhooper\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{8D422132-CB59-44A1-8687-10B63C9734F6}' <object GrtObject> key=owner could not be resolved
09:43:06 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.9 CE build 10690321 (64 bit)
	Configuration Directory: C:\Users\rhooper\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 7 Enterprise Service Pack 1
	CPU: 4x Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz, 11.8 GiB RAM
	Active video adapter Intel(R) HD Graphics 520
	Installed video RAM: 1024 MB
	Current video mode: 1280 x 1024 x 4294967296 colors
	Used bit depth: 32
	Driver version: 21.20.16.4627
	Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igdumdim32,igd10iumd32,igd10iumd32
	Current user language: English (United States)

09:43:06 [INF][    WQE backend]: Found auto-save workspace C:\Users\rhooper\AppData\Roaming\MySQL\Workbench\sql_workspaces\NeoSS-1.autosave
09:43:06 [INF][      Workbench]: UI is up
09:43:06 [INF][      Workbench]: Running the application
09:43:47 [INF][      WBContext]: Connection to NeoSS cancelled by user: canceled
09:43:49 [INF][SQL Editor Form]: Opened connection 'NeoSS' to MySQL Community Server (GPL) version 5.6.34-log
09:43:49 [ERR][SQL Editor Form]: Error: DBMS connection is not available
09:43:54 [INF][SQL Editor Form]: Opened connection 'NeoSS' to MySQL Community Server (GPL) version 5.6.34-log
09:43:56 [INF][        WQE.net]: Launching SQL IDE
09:43:57 [INF][        WQE.net]: SQL IDE UI is ready

How to repeat:
I am executing a simple query but finding the query runs/says fetching, and around 10 minutes after running the program says "not responding" and i am forced to shut it down via task manager

Maybe Windows 7 specific ( I couldn't repeat on Windows 10 ).

Hello Rachel,

Thank you for the bug report.
This reminds me of Bug #79840, could you please confirm if you are affected by Bug #79840 i.e using SSH tunneling?  If it is not  the case then may I request you to please provide complete repeatable test case (How you are connecting, screenshot etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.

Yes I am connected with SSH Tunneling

Hello   Rachel,

Thank you for the feedback.
This is most likely duplicate of Bug #79840, please see Bug #79840

Thanks,
Chiranjeevi.