MySQL Bugs: #81201: MySQL Workbench

Bug #81201	MySQL Workbench
Submitted:	26 Apr 2016 13:33	Modified:	18 May 2016 20:46
Reporter:	Costis Aivalis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	6.3.6	OS:	Windows (Microsoft Windows 10 Pro)
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\costis\AppData\Roaming\MySQL\Workbench\log\wb.log]

16:18:23 [ERR][      Workbench]: Console redirection failed.
16:18:23 [INF][      WBContext]: Parsing application arguments.
16:18:23 [INF][      WBContext]:     C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
16:18:23 [INF][      Workbench]: Starting up Workbench
16:18:23 [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.2.9200.0
	SystemDirectory: C:\Windows\system32
	TickCount: 2156765
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 32514048
16:18:23 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = GLORY
	USERPROFILE = C:\Users\costis
	HOMEPATH = \Users\costis
	LOCALAPPDATA = C:\Users\costis\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;C:\Program Files\MATLAB\R2013a\runtime\win64;C:\TDM-GCC-64\bin;C:\Program Files (x86)\sbt\\bin
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\GLORY
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\Windows
	USERNAME = costis
	TMP = C:\Users\costis\AppData\Local\Temp
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	PUBLIC = C:\Users\Public
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	APPDATA = C:\Users\costis\AppData\Roaming
	PROCESSOR_REVISION = 1706
	SBT_HOME = C:\Program Files (x86)\sbt\
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\costis\AppData\Local\Temp
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = GLORY
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 23 Stepping 6, GenuineIntel
	ComSpec = C:\Windows\system32\cmd.exe
	SystemDrive = C:
	JDKHOME = C:\Program Files\Java\jdk1.8.0_77
	ProgramFiles = C:\Program Files
	MOZ_PLUGIN_PATH = C:\Program Files (x86)\Foxit Software\Foxit Reader\plugins\
	NUMBER_OF_PROCESSORS = 2
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\Windows
	USERDOMAIN = GLORY
16:18:23 [INF][      Workbench]: Current version given by meta info is: 6.3.6
16:18:23 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5 & MySQL Utilities 1.5\Doctrine extensions for PHP\;C:\Program Files\MATLAB\R2013a\runtime\win64;C:\TDM-GCC-64\bin;C:\Program Files (x86)\sbt\\bin
16:18:23 [INF][ mforms managed]: Initializing mforms wrapper
16:18:23 [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\costis\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
16:18:23 [INF][      WBContext]: WbContext::init
16:18:23 [INF][            grt]: Scanning module directory C:\Users\costis\AppData\Roaming\MySQL\Workbench\modules.	
16:18:23 [INF][            grt]: Scanning module directory ..	
16:18:23 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.	
16:18:23 [INF][            WBA]: Looking for extension modules for WBA...
16:18:23 [INF][            WBA]: 0 extension modules found
16:18:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:23 [WRN][            grt]: C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
16:18:23 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.	
16:18:24 [WRN][            grt]: C:\Users\costis\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{E6ACFE8C-04AF-4902-B4CE-9FDFE96A0BC7}' <object GrtObject> key=owner could not be resolved
16:18:24 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.6 CE build 511 (64 bit)
	Configuration Directory: C:\Users\costis\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro
	CPU: 2x Intel(R) Core(TM)2 Duo CPU     E8200  @ 2.66GHz, 8.0 GiB RAM
	Active video adapter NVIDIA GeForce GT 220 
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1080 x 4294967296 colors
	Used bit depth: 32
	Driver version: 9.18.13.4195
	Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
	Current user language: English (United States)

16:18:24 [INF][      Workbench]: UI is up
16:18:24 [INF][      Workbench]: Running the application

How to repeat:
Every time i try to start wb and try to access my local Instance MySQL the system hangs.

Thank you for the bug report. I couldn't repeat on Windows 10 Pro, an uninstall an re-install fix the issue?. Thanks.

I tried every possible uninstall an re-install in order to fix the issue. I tried 32bit and 64bit. Also previous versions of Workbench.

After a number of tries, involving re-installations of mysql and workbench both 32 and 64 bit i still could not start workbench in windows 10. Every time i select "Local instance MySQL57", WB hangs. I solved the issue by creating a new Local instance. Still the old Local instance hangs. Where are the scripts stored. so i can find out why this happens? 
WB works well again, but only with the new Local instance.

Thank you for the feedback. I couldn't repeat the issue reported, my guess is the file on C:\Users\user_name\AppData\Roaming\MySQL\Workbench which are saved the connection got corrupted with unknowing way, try to delete the connection and create it again and check if the issue goes away. Thanks.

Thank you for your time. This error happened only in Windows 10 and after I restored a backup of my tables. I managed to get MySQL-Workbench to work again  after i deleted everything from C:\ProgramData\MySQL. Reinstall alone would not help. 

I should have updated this ticket. Consider it closed.