Bug #100699 Not Starting up

• Submitted: 31 Aug 2020 18:15
• Modified: 31 Aug 2020 21:12
• Reporter: Sai Nathan
• Status: Can't repeat
• Category: MySQL Workbench: SQL Editor
• Severity: S1 (Critical)
• Version: 8.0.21
• OS: MacOS (Catalina 10.15.6)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[31 Aug 2020 18:15] Sai Nathan

Description:
When I try to open the sql editor it gets stuck on "Opening SQL Editor". If I click cancel it keeps trying to connect which uses alot of CPU power as well. I cannot visually see my database at all and it poses a big problem for me. 

I am using this for school and it is very important for me. 

Please advise on how to fix. 

Here is the copy of the LOG file:
11:05:27 [INF][      Workbench]: Starting up Workbench
11:05:27 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /Applications/MySQLWorkbench.app/Contents/Resources
	plugin path: /Applications/MySQLWorkbench.app/Contents/PlugIns
	struct path: /Applications/MySQLWorkbench.app/Contents/Resources/grt
	module path: /Applications/MySQLWorkbench.app/Contents/PlugIns:/Applications/MySQLWorkbench.app/Contents/Resources/plugins
	library path: /Applications/MySQLWorkbench.app/Contents/Resources/libraries
	user data dir: /Users/sai/Library/Application Support/MySQL/Workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
11:05:27 [INF][      WBContext]: WbContext::init
11:05:27 [INF][            WBA]: Looking for extension modules for WBA...
11:05:27 [INF][            WBA]: 0 extension modules found
11:05:28 [WRN][            grt]: /Users/sai/Library/Application Support/MySQL/Workbench/connections.xml:18: link '444A7224-75DD-49EB-A971-F0AEFFD0A22D' <object GrtObject> key=owner could not be resolved
11:05:28 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for macOS version 8.0.21 CE build 16448441 (64 bit)
	Configuration Directory: /Users/sai/Library/Application Support/MySQL/Workbench
	Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
	Cairo Version: 1.10.2
	OS: macOS 10.15.x Catalina x86_64
	CPU: 8x Intel(R) Core(TM) i5-8257U CPU @ 1.40GHz - 8.00GiB RAM
No video adapter info available

11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:05:28 [WRN][         mforms]: Resource file not found: [e-mail]
11:06:55 [WRN][         mforms]: Resource file not found: MySQL-WB-about-screen@[e-mail]

11:08:23 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'root'@'localhost' (using password: YES)
11:08:23 [ERR][  GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'root'@'localhost' (using password: YES)

Thanks, 
Sai

How to repeat:
Install up-to-date version and try opening the local instance on the Mac. It will get stuck.

[31 Aug 2020 21:03] MySQL Verification Team

WorkBench 8.0.21 working fine on MAC OSX Catalina

Attachment: bug100699.png (image/png, text), 2.33 MiB.

[31 Aug 2020 21:06] MySQL Verification Team

Thank you for the bug report. Please see attached screenshot.

[31 Aug 2020 21:12] Sai Nathan

that still doesn't say why it was staggering and not loading the database. What I did now was I installed an older version and for now it works. But I dont know if that is the permanent solution.

[31 Aug 2020 21:20] MySQL Verification Team

I don't know to what say is the problem on your environment since on my side works fine when connecting with a server version 8.0.21 too. I am assignment to my co-worker to check on his side.