Bug #79427 connection keep-alive not working
Submitted: 26 Nov 2015 16:02 Modified: 1 Dec 2015 9:42
Reporter: Telmo Calhaco Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.5 OS:Windows (Microsoft Windows 10 Home)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Nov 2015 16:02] Telmo Calhaco
Description:
15:54:14 [ERR][      Workbench]: Console redirection failed.
15:54:14 [INF][      WBContext]: Parsing application arguments.
15:54:14 [INF][      WBContext]:     C:\Program Files\MySQL\MySQL Workbench 6.3 CE\MySQLWorkbench.exe
15:54:14 [INF][      Workbench]: Starting up Workbench
15:54:14 [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: 108172890
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 32325632
15:54:14 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = TELMO-WORKPC
	USERPROFILE = C:\Users\Telmo
	HOMEPATH = \Users\Telmo
	LOCALAPPDATA = C:\Users\Telmo\AppData\Local
	PSModulePath = C:\Users\Telmo\Documents\WindowsPowerShell\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\ProgramData\Oracle\Java\javapath;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 (x86)\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\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Skype\Phone\;C:\Work\php;C:\ProgramData\ComposerSetup\bin;C:\HashiCorp\Vagrant\bin;C:\Users\Telmo\AppData\Local\Programs\Git\;C:\Work\cmder\vendor\msysgit\bin;C:\Users\Telmo\AppData\Local\atom\bin;C:\Work\php;C:\Users\Telmo\AppData\Local\Programs\Git\cmd;C:\Users\Telmo\AppData\Local\Programs\Git\;C:\Work\cmder\vendor\msysgit\bin
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\MicrosoftAccount
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	VBOX_MSI_INSTALL_PATH = C:\Program Files\Oracle\VirtualBox\
	SystemRoot = C:\WINDOWS
	USERNAME = Telmo
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	PUBLIC = C:\Users\Public
	FP_NO_HOST_CHECK = NO
	APPDATA = C:\Users\Telmo\AppData\Roaming
	PROCESSOR_REVISION = 3d04
	UOIPME_REG_PATH = C:\Program Files\Intel Corporation\USB over IP
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\Telmo\AppData\Local\Temp
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = TELMO-WORKPC
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 61 Stepping 4, GenuineIntel
	ComSpec = C:\WINDOWS\system32\cmd.exe
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 4
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	TMP = C:\Users\Telmo\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = TELMO-WORKPC
15:54:14 [INF][      Workbench]: Current version given by meta info is: 6.3.5
15:54:14 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\ProgramData\Oracle\Java\javapath;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 (x86)\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\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Skype\Phone\;C:\Work\php;C:\ProgramData\ComposerSetup\bin;C:\HashiCorp\Vagrant\bin;C:\Users\Telmo\AppData\Local\Programs\Git\;C:\Work\cmder\vendor\msysgit\bin;C:\Users\Telmo\AppData\Local\atom\bin;C:\Work\php;C:\Users\Telmo\AppData\Local\Programs\Git\cmd;C:\Users\Telmo\AppData\Local\Programs\Git\;C:\Work\cmder\vendor\msysgit\bin
15:54:14 [INF][ mforms managed]: Initializing mforms wrapper
15:54:14 [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\Telmo\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
15:54:14 [INF][      WBContext]: WbContext::init
15:54:14 [INF][            grt]: Scanning module directory C:\Users\Telmo\AppData\Roaming\MySQL\Workbench\modules.	
15:54:14 [INF][            grt]: Scanning module directory ..	
15:54:14 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE/modules.	
15:54:14 [INF][            WBA]: Looking for extension modules for WBA...
15:54:14 [INF][            WBA]: 0 extension modules found
15:54:14 [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
15:54:14 [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
15:54:14 [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
15:54:14 [INF][            grt]: Scanning module directory C:\Program Files\MySQL\MySQL Workbench 6.3 CE.	
15:54:14 [WRN][            grt]: C:\Users\Telmo\AppData\Roaming\MySQL\Workbench\connections.xml:27: link '{DB818B4E-2F28-42E8-AE34-B806578C8578}' <object GrtObject> key=owner could not be resolved
15:54:14 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.5 CE build 201 (64 bit)
	Configuration Directory: C:\Users\Telmo\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.3 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Home
	CPU: 4x Intel(R) Core(TM) i7-5500U CPU @ 2.40GHz, 7.9 GiB RAM
	Active video adapter Intel(R) HD Graphics 5500
	Installed video RAM: 1024 MB
	Current video mode: 1920 x 1080 x 4294967296 cores
	Used bit depth: 32
	Driver version: 10.18.15.4268
	Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll,igd12umd64.dll,igdumdim32,igd10iumd32,igd10iumd32,igd12umd32
	Current user language: Português (Portugal)

15:54:14 [INF][      Workbench]: UI is up
15:54:15 [INF][      Workbench]: Running the application

the keep-alive option on the config is not working, if i have a query window open to do a query or edit a function, en i going to press the execute e send the error and i have to reconnect to the server, this was working on the version 6.2.

How to repeat:
Connect to a server , open a query windows , wait a minute and execute a query .

Suggested fix:
keep-alive working :)
[26 Nov 2015 20:46] MySQL Verification Team
Which is the value of keep-alive interval you have in your preferences?. Thanks
[27 Nov 2015 9:24] Telmo Calhaco
not working with any value , i all ready try 0 ,5 ,30 , 60 seconds on the keep-alive and none of those work.
[27 Nov 2015 10:40] MySQL Verification Team
Thank you for the feedback. I couldn't repeat on Windows 10 Pro using the defaults values 600,600,60. Please read:

https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
[1 Dec 2015 9:42] Telmo Calhaco
Still not working with the default settings, and this was working in the latest version.