MySQL Bugs: #80596: Not able to access mysql server through workbench

Bug #80596	Not able to access mysql server through workbench
Submitted:	3 Mar 2016 6:19	Modified:	3 Mar 2016 8:30
Reporter:	Sathish K	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S5 (Performance)
Version:	6.3.5	OS:	Windows (Microsoft Windows 7 Enterprise)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:

11:42:18 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\ProgramData\Oracle\Java\javapath;C:\app\MAA-SGH202PQHD$\product\11.2.0\client_1\bin;C:\app\ksathis\product\11.2.0\client_1;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files (x86)\Quarantine\;C:\Program Files (x86)\QuickTime\QTSystem\
11:42:18 [INF][ mforms managed]: Initializing mforms wrapper
11:42:20 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	struct path: 
	module path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/modules
	library path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	user data dir: C:\Users\ksathis\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
11:42:20 [INF][      WBContext]: WbContext::init
11:42:21 [INF][            grt]: Scanning module directory C:\Users\ksathis\AppData\Roaming\MySQL\Workbench\modules.	
11:42:21 [INF][            grt]: Scanning module directory ..	
11:42:22 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/modules.	
11:42:27 [INF][            WBA]: Looking for extension modules for WBA...
11:42:27 [INF][            WBA]: 0 extension modules found
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE.	
11:42:28 [WRN][            grt]: C:\Users\ksathis\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{9DA817E6-6EE5-49CB-ABEF-EAF2441D32E0}' <object GrtObject> key=owner could not be resolved
11:42:28 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (32 bit)
	Configuration Directory: C:\Users\ksathis\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 7 Enterprise
	CPU: 6x Intel(R) Xeon(R) CPU           W3670  @ 3.20GHz, 16.0 GiB RAM
	Active video adapter NVIDIA Quadro 600 
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1200 x 4294967296 colors
	Used bit depth: 32
	Driver version: 8.17.12.7589
	Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
	Current user language: English (United States)

11:42:28 [INF][      Workbench]: UI is up
11:42:29 [INF][      Workbench]: Running the application
11:42:55 [INF][      SqlEditor]: Opened connection 'Studio LSA' to MySQL Community Server (GPL) version 5.6.19-log
11:42:58 [INF][     AutoCCache]: Initializing autocompletion cache for Studio_LSA
11:42:58 [INF][        WQE.net]: Launching SQL IDE
11:43:00 [ERR][      Workbench]: External component has thrown an exception.
Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
   at MySQL.Workbench.WbContext.toolbar_for_form(UIForm form)
   at MySQL.GUI.Workbench.MainForm.SetupDockLayout(ITabDocument document, UIForm backend, Boolean withPadding)
   at MySQL.GUI.Workbench.MainForm.DockDocument(ITabDocument document, Boolean main, Boolean activate)
   at MySQL.GUI.Workbench.MainForm.CreateMainFormView(String ViewName, UIForm viewBE)
11:43:06 [ERR][ mforms backend]: Code Editor Config: cannot load configuration file "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/data/code_editor.xml":
	Failed to open file (row: 0, column: 0)
11:43:06 [ERR][ mforms backend]: Code Editor Config: cannot load configuration file "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/data/code_editor.xml":
	Failed to open file (row: 0, column: 0)
11:43:06 [ERR][Code Completion]: Token file not found (C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\data/MySQL.tokens)
11:43:06 [ERR][Code Completion]: Grammar file not found
11:43:06 [ERR][   WBContext UI]: Exception caught while processing action from home screen: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\data/main_menu.xml

How to repeat:
11:42:17 [ERR][      Workbench]: Console redirection failed.
11:42:17 [INF][      WBContext]: Parsing application arguments.
11:42:17 [INF][      WBContext]:     C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
11:42:17 [INF][      Workbench]: Starting up Workbench
11:42:17 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Windows\Installer\MSI9767.tmp-
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.1.7601 Service Pack 1
	SystemDirectory: C:\Windows\system32
	TickCount: 68619410
	UserInteractive: True
	Version: 4.0.30319.18063
	WorkingSet: 44191744
11:42:17 [INF][      Workbench]: Environment variables:
	PROCESSOR_ARCHITEW6432 = AMD64
	COMPUTERNAME = MAA-SGH202PQHD
	UATDATA = C:\Windows\SysWOW64\CCM\UATData\D9F8C395-CAB8-491d-B8AC-179A1FE1BE77
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	MYSQLCONNECTOR_ASSEMBLIESPATH = C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.0
	HOMEPATH = \Users\ksathis
	PROCESSOR_REVISION = 2c02
	VS100COMNTOOLS = c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC;.PY;.PYW
	TMP = C:\Users\ksathis\AppData\Local\Temp
	MOZ_CRASHREPORTER_DISABLE = 1
	TEMP = C:\Users\ksathis\AppData\Local\Temp
	LOCALAPPDATA = C:\Users\ksathis\AppData\Local
	PUBLIC = C:\Users\Public
	GDAL_DATA = C:\Python27\GDAL\data
	USERDNSDOMAIN = ANT.AMAZON.COM
	USERDOMAIN = ANT
	ProgramFiles(x86) = C:\Program Files (x86)
	Path = C:\ProgramData\Oracle\Java\javapath;C:\Python27\Lib\site-packages\PyQt4;C:\app\MAA-SGH202PQHD$\product\11.2.0\client_1\bin;C:\app\ksathis\product\11.2.0\client_1;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Python27;C:\Python27\DLLs;C:\Python27\Scripts;C:\Python27\Lib\site-packages\vtk;C:\Python27\gnuplot\binary;C:\Python27\Lib\site-packages\osgeo;C:\Program Files (x86)\pythonxy\SciTE-3.5.1-4;C:\Program Files (x86)\pythonxy\console;C:\Program Files (x86)\pythonxy\swig;C:\Program Files (x86)\pythonxy\gettext\bin;C:\Program Files (x86)\Quarantine\;C:\Program Files (x86)\QuickTime\QTSystem\
	PROCESSOR_LEVEL = 6
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 44 Stepping 2, GenuineIntel
	windows_tracing_flags = 3
	PSModulePath = C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files (x86)\AWS Tools\PowerShell\
	NUMBER_OF_PROCESSORS = 6
	CommonProgramFiles = C:\Program Files (x86)\Common Files
	asl.log = Destination=file
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	ProgramFiles = C:\Program Files (x86)
	FP_NO_HOST_CHECK = NO
	GDAL_DRIVER_PATH = C:\Python27\Lib\site-packages\osgeo\gdalplugins
	PYTHON_LIB = C:\Python27\libs\python27.lib
	SystemRoot = C:\Windows
	CommonProgramW6432 = C:\Program Files\Common Files
	PYTHON_INCLUDE = C:\Python27\include
	LOGONSERVER = \\DC-MAA3-01
	USERPROFILE = C:\Users\ksathis
	APPDATA = C:\Users\ksathis\AppData\Roaming
	HOMEDRIVE = C:
	windows_tracing_logfile = C:\BVTBin\Tests\installpackage\csilogfile.log
	USERNAME = ksathis
	PROCESSOR_ARCHITECTURE = x86
	OS = Windows_NT
	ComSpec = C:\Windows\system32\cmd.exe
	SystemDrive = C:
	windir = C:\Windows
	ALLUSERSPROFILE = C:\ProgramData
11:42:17 [INF][      Workbench]: Current version given by meta info is: 6.3.5
11:42:17 [INF][      Workbench]: This is the first start of a new version. Doing some clean up.
11:42:18 [INF][      Workbench]: Setting PATH to: C:\Windows\system32;C:\ProgramData\Oracle\Java\javapath;C:\app\MAA-SGH202PQHD$\product\11.2.0\client_1\bin;C:\app\ksathis\product\11.2.0\client_1;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Imaging\;C:\Program Files (x86)\Quarantine\;C:\Program Files (x86)\QuickTime\QTSystem\
11:42:18 [INF][ mforms managed]: Initializing mforms wrapper
11:42:20 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	plugin path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	struct path: 
	module path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/modules
	library path: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	user data dir: C:\Users\ksathis\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
11:42:20 [INF][      WBContext]: WbContext::init
11:42:21 [INF][            grt]: Scanning module directory C:\Users\ksathis\AppData\Roaming\MySQL\Workbench\modules.	
11:42:21 [INF][            grt]: Scanning module directory ..	
11:42:22 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/modules.	
11:42:27 [INF][            WBA]: Looking for extension modules for WBA...
11:42:27 [INF][            WBA]: 0 extension modules found
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [WRN][            grt]: C:\Program Files (x86)\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
11:42:27 [INF][            grt]: Scanning module directory C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE.	
11:42:28 [WRN][            grt]: C:\Users\ksathis\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{9DA817E6-6EE5-49CB-ABEF-EAF2441D32E0}' <object GrtObject> key=owner could not be resolved
11:42:28 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (32 bit)
	Configuration Directory: C:\Users\ksathis\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 7 Enterprise
	CPU: 6x Intel(R) Xeon(R) CPU           W3670  @ 3.20GHz, 16.0 GiB RAM
	Active video adapter NVIDIA Quadro 600 
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1200 x 4294967296 colors
	Used bit depth: 32
	Driver version: 8.17.12.7589
	Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
	Current user language: English (United States)

11:42:28 [INF][      Workbench]: UI is up
11:42:29 [INF][      Workbench]: Running the application
11:42:55 [INF][      SqlEditor]: Opened connection 'Studio LSA' to MySQL Community Server (GPL) version 5.6.19-log
11:42:58 [INF][     AutoCCache]: Initializing autocompletion cache for Studio_LSA
11:42:58 [INF][        WQE.net]: Launching SQL IDE
11:43:00 [ERR][      Workbench]: External component has thrown an exception.
Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException (0x80004005): External component has thrown an exception.
   at MySQL.Workbench.WbContext.toolbar_for_form(UIForm form)
   at MySQL.GUI.Workbench.MainForm.SetupDockLayout(ITabDocument document, UIForm backend, Boolean withPadding)
   at MySQL.GUI.Workbench.MainForm.DockDocument(ITabDocument document, Boolean main, Boolean activate)
   at MySQL.GUI.Workbench.MainForm.CreateMainFormView(String ViewName, UIForm viewBE)
11:43:06 [ERR][ mforms backend]: Code Editor Config: cannot load configuration file "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/data/code_editor.xml":
	Failed to open file (row: 0, column: 0)
11:43:06 [ERR][ mforms backend]: Code Editor Config: cannot load configuration file "C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE/data/code_editor.xml":
	Failed to open file (row: 0, column: 0)
11:43:06 [ERR][Code Completion]: Token file not found (C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\data/MySQL.tokens)
11:43:06 [ERR][Code Completion]: Grammar file not found
11:43:06 [ERR][   WBContext UI]: Exception caught while processing action from home screen: C:\Program Files (x86)\MySQL\MySQL Workbench 6.3 CE\data/main_menu.xml

Hello Sathish,

Thank you for report.
I'm not seeing this issue with latest WB GA build 6.3.6, could you please upgrade to latest WB version and let us know if you are still experiencing the issue along with full WB log file.

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Thanks,
Umesh