Bug #91365 my system is going into deadlock multiple time.
Submitted: 22 Jun 2018 7:38 Modified: 22 Jul 2018 8:20
Reporter: Ankit Rathore Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.10 OS:Windows (Microsoft Windows 10 Pro)
Assigned to: Assigned Account CPU Architecture:x86
Tags: WBBugReporter

[22 Jun 2018 7:38] Ankit Rathore
Description:
----[For better reports, please attach the log file after submitting. You can find it in C:\Users\ABC-07\AppData\Roaming\MySQL\Workbench\log\wb.log]

12:32:16 [ERR][      Workbench]: Console redirection failed.
12:32:16 [INF][      Workbench]: Starting up Workbench
12:32:16 [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: 205812
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 34131968
12:32:16 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = EMIZA-073
	USERPROFILE = C:\Users\ABC-07
	HOMEPATH = \Users\ABC-07
	LOCALAPPDATA = C:\Users\ABC-07\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Broadcom\Broadcom 802.11 Network Adapter;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\pb120\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\WINDOWS\System32\OpenSSH\;C:\Users\ABC-07\AppData\Local\Microsoft\WindowsApps;
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 22
	LOGONSERVER = \\EMIZA-073
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\WINDOWS
	RegionCode = APJ
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	APPDATA = C:\Users\ABC-07\AppData\Roaming
	PROCESSOR_REVISION = 3001
	OnlineServices = Online Services
	CommonProgramW6432 = C:\Program Files\Common Files
	OneDrive = C:\Users\ABC-07\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = EMIZA-073
	platformcode = 6U
	PROCESSOR_IDENTIFIER = AMD64 Family 22 Model 48 Stepping 1, AuthenticAMD
	ComSpec = C:\WINDOWS\system32\cmd.exe
	USERNAME = Emiza-ANK
	SystemDrive = C:
	TEMP = C:\Users\ABC-07\AppData\Local\Temp
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 4
	TOMCAT_HOME = C:\Program Files\Apache-Tomcat\apache-tomcat-8.5.15\bin
	TMP = C:\Users\ABC-07\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = EMIZA-073
	PUBLIC = C:\Users\Public
12:32:16 [INF][      Workbench]: Current version given by meta info is: 6.3.10
12:32:16 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Broadcom\Broadcom 802.11 Network Adapter;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;c:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files\OpenVPN\bin;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\pb120\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;C:\WINDOWS\System32\OpenSSH\;C:\Users\ABC-07\AppData\Local\Microsoft\WindowsApps;
12:32:16 [INF][ mforms managed]: Initializing mforms wrapper
12:32:17 [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\ABC-07\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:32:17 [INF][      WBContext]: WbContext::init
12:32:19 [INF][            WBA]: Looking for extension modules for WBA...
12:32:19 [INF][            WBA]: 0 extension modules found
12:32:19 [WRN][            grt]: C:\Users\ABC-07\AppData\Roaming\MySQL\Workbench\connections.xml:26: link '{8693CC90-F88D-4D71-83EE-FED524801DCF}' <object GrtObject> key=owner could not be resolved
12:32:20 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 6.3.10 CE build 12092614 (64 bit)
	Configuration Directory: C:\Users\ABC-07\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: 4x AMD A8-7410 APU with AMD Radeon R5 Graphics    , 3.5 GiB RAM
	Active video adapter AMD Radeon(TM) R5 Graphics
	Installed video RAM: 512 MB
	Current video mode: 1366 x 768 x 4294967296 colors
	Used bit depth: 32
	Driver version: 15.201.1201.0
	Installed display drivers: aticfx64.dll,aticfx64.dll,aticfx64.dll,amdxc64.dll
	Current user language: English (India)

12:32:20 [INF][    WQE backend]: Found auto-save workspace C:\Users\ABC-07\AppData\Roaming\MySQL\Workbench\sql_workspaces\RDC-ARRORA-1.autosave
12:32:20 [INF][      Workbench]: UI is up
12:32:22 [INF][      Workbench]: Running the application
12:33:23 [INF][SQL Editor Form]: Opened connection 'RDC-ARRORA' to MySQL Community Server (GPL) version 5.6.10
12:33:27 [INF][        WQE.net]: Launching SQL IDE
12:33:31 [INF][        WQE.net]: SQL IDE UI is ready
12:33:39 [ERR][MySQL Name Cache]: Exception while running refresh task: View 'rdc_dev_01.VW_EMIZA_CITYLIST' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
12:33:40 [ERR][MySQL Name Cache]: Exception while running refresh task: View 'rdc_dev_01.VW_EMIZA_CUSTOMER_ITEM_MASTER' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
12:33:44 [ERR][MySQL Name Cache]: Exception while running refresh task: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
12:34:03 [ERR][MySQL Name Cache]: Exception while running refresh task: View 'rdc_dev_01.VW_EMIZA_CITYLIST' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
12:34:04 [ERR][MySQL Name Cache]: Exception while running refresh task: View 'rdc_dev_01.VW_EMIZA_CUSTOMER_ITEM_MASTER' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
12:34:08 [ERR][MySQL Name Cache]: Exception while running refresh task: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

How to repeat:
whenever I used MySQL and trying to press the backspace button multiple time, your software always goes into the deadlock condition.

2. whenever I tried to search a specific word in my SP around 8-10 times it gives a proper result but after 10 attempts it goes into deadlock or shows an error popup.

please update it.
in one day I am facing 4-5 times this problem and getting windows memory out of a bound problem and my system creased.

it's only your software problem because whenever I used your MySQL then only I get this problem.

Suggested fix:

please update it.
in one day I am facing 4-5 times this problem and getting windows memory out of a bound problem and my system creased.

it's only your software problem because whenever I used your MySQL then only I get this problem.
[22 Jun 2018 8:20] MySQL Verification Team
Thank you for the bug report. Could you please try to use WorkBench with a current MySQL server version, you are using:

Opened connection 'RDC-ARRORA' to MySQL Community Server (GPL) version 5.6.10

Current 5.6 server is 5.6.40.

Thanks.
[23 Jul 2018 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".