Bug #100113 My workbench freezes and crashes frequently
Submitted: 5 Jul 2020 6:47 Modified: 20 Aug 2020 12:25
Reporter: Vignesh Satheesh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:8.0.20 OS:Windows (Microsoft Windows 10 Pro N)
Assigned to: MySQL Verification Team CPU Architecture:Other (4gb ram,2.80Ghz processor)
Tags: WBBugReporter

[5 Jul 2020 6:47] Vignesh Satheesh
Description:
----[For better reports, please attach the log file after submitting it. You can find it in C:\Users\vigne\AppData\Roaming\MySQL\Workbench\log\wb.log]
12:02:14 [ERR][      Workbench]: Console redirection failed.
12:02:15 [INF][      Workbench]: Starting up Workbench
12:02:15 [INF][      Workbench]: Current environment:
	Command line: "C:\Program Files\MySQL\MySQL Workbench 8.0 CE\MySQLWorkbench.exe" 
	CurrentDirectory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	HasShutdownStarted: False
	OSVersion: Microsoft Windows NT 6.2.9200.0
	SystemDirectory: C:\WINDOWS\system32
	TickCount: 328214578
	UserInteractive: True
	Version: 4.0.30319.42000
	WorkingSet: 41316352
12:02:15 [INF][      Workbench]: Environment variables:
	COMPUTERNAME = DESKTOP-7MBU5EC
	USERPROFILE = C:\Users\vigne
	HOMEPATH = \Users\vigne
	LOCALAPPDATA = C:\Users\vigne\AppData\Local
	PSModulePath = C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules
	PROCESSOR_ARCHITECTURE = AMD64
	Path = C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\vigne\AppData\Local\Microsoft\WindowsApps;
	CommonProgramFiles(x86) = C:\Program Files (x86)\Common Files
	ProgramFiles(x86) = C:\Program Files (x86)
	PROCESSOR_LEVEL = 6
	LOGONSERVER = \\DESKTOP-7MBU5EC
	PATHEXT = .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
	HOMEDRIVE = C:
	SystemRoot = C:\WINDOWS
	SESSIONNAME = Console
	ALLUSERSPROFILE = C:\ProgramData
	DriverData = C:\Windows\System32\Drivers\DriverData
	FPS_BROWSER_APP_PROFILE_STRING = Internet Explorer
	APPDATA = C:\Users\vigne\AppData\Roaming
	PROCESSOR_REVISION = 3a09
	USERNAME = vigne
	CommonProgramW6432 = C:\Program Files\Common Files
	TEMP = C:\Users\vigne\AppData\Local\Temp
	OneDrive = C:\Users\vigne\OneDrive
	CommonProgramFiles = C:\Program Files\Common Files
	OS = Windows_NT
	USERDOMAIN_ROAMINGPROFILE = DESKTOP-7MBU5EC
	PROCESSOR_IDENTIFIER = Intel64 Family 6 Model 58 Stepping 9, GenuineIntel
	ComSpec = C:\WINDOWS\system32\cmd.exe
	SystemDrive = C:
	FPS_BROWSER_USER_PROFILE_STRING = Default
	ProgramFiles = C:\Program Files
	NUMBER_OF_PROCESSORS = 2
	TMP = C:\Users\vigne\AppData\Local\Temp
	ProgramData = C:\ProgramData
	ProgramW6432 = C:\Program Files
	windir = C:\WINDOWS
	USERDOMAIN = DESKTOP-7MBU5EC
	PUBLIC = C:\Users\Public
12:02:15 [INF][      Workbench]: Current version given by meta info is: 8.0.20
12:02:15 [INF][      Workbench]: Setting PATH to: C:\WINDOWS\system32;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\vigne\AppData\Local\Microsoft\WindowsApps;
12:02:15 [INF][ mforms managed]: Initializing mforms wrapper
12:02:15 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	plugin path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	struct path: 
	module path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE/modules
	library path: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	user data dir: C:\Users\vigne\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:02:15 [INF][      WBContext]: WbContext::init
12:02:25 [INF][            WBA]: Looking for extension modules for WBA...
12:02:25 [INF][            WBA]: 0 extension modules found
12:02:27 [WRN][            grt]: C:\Users\vigne\AppData\Roaming\MySQL\Workbench\connections.xml:27: link '{CE7D4348-0572-47A2-B3A0-444ED7A80633}' <object GrtObject> key=owner could not be resolved
12:02:27 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Windows version 8.0.20 CE build 16114288 (64 bit)
	Configuration Directory: C:\Users\vigne\AppData\Roaming\MySQL\Workbench
	Data Directory: C:\Program Files\MySQL\MySQL Workbench 8.0 CE
	Cairo Version: 1.10.2
	OS: Microsoft Windows 10 Pro N
	CPU: 2x Intel(R) Pentium(R) CPU G2010 @ 2.80GHz, 3.9 GiB RAM
	Active video adapter Intel(R) HD Graphics
	Installed video RAM: -2036 MB
	Current video mode: 1366 x 768 x 4294967296 colors
	Used bit depth: 32
	Driver version: 10.18.10.4252
	Installed display drivers: igdumdim64.dll,igd10iumd64.dll,igd10iumd64.dll
	Current user language: English (India)

12:02:27 [INF][    WQE backend]: Found auto-save workspace C:\Users\vigne\AppData\Roaming\MySQL\Workbench\sql_workspaces\Local_instance_MySQL80-1.autosave
12:02:27 [INF][    WQE backend]: Found auto-save workspace C:\Users\vigne\AppData\Roaming\MySQL\Workbench\sql_workspaces\Project-1.autosave
12:02:27 [INF][      Workbench]: UI is up
12:02:29 [INF][      Workbench]: Running the application
12:02:41 [INF][SQL Editor Form]: Opened connection 'Project' to MySQL Community Server - GPL version 8.0.20
12:02:43 [INF][        WQE.net]: Launching SQL IDE
12:02:46 [INF][        WQE.net]: SQL IDE UI is ready

How to repeat:
I added 5 tables in my database with rows ranging from 7000 to 25000. While performing basic queries like to fetch table details using select * from table_name; freezes my workbench for at least 5 seconds, even putting a coma freezes it and later performing the same task again crashes it and workbench closes automatically
[13 Jul 2020 4:52] Vignesh Satheesh
Any Update on this bug?
[17 Jul 2020 12:12] Pierre Godts
I had the same problem with 8.0.18.
After I installed 8.0.20 the problem persisted.
Then I saw version 8.0.21 was released. But also that release is not working.

Then I re-installed version 80.17 but that didn't help.

TODAY (17 July 2020) I upgraded to 8.0.21 and now the problem 
seems to be gone.
[20 Jul 2020 12:25] MySQL Verification Team
Hello Vignesh Satheesh,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 with workbench 8.0.20 using dummy table with 10k data but I am not seeing any issues at my end. To investigate further this issue at our end, may I kindly request you to provide table structure and data which is causing the issue. Also upgrade to latest version. Thanks.

Regards,
Ashwini Patil
[21 Aug 2020 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".