Bug #77176 MySQL Workbench always expanding schema and refreshing at connect
Submitted: 27 May 2015 22:01 Modified: 26 Sep 2015 21:28
Reporter: Tom Tobin Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:6.3.3 OS:Mac OS X (OS X 10.10.x Yosemite)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[27 May 2015 22:01] Tom Tobin
Description:
When I open a connection in 6.3.3, I have one active schema, and it is always expanded. 
This never finishes refreshing - I have 400,000 tables. I can't run any sql as it's waiting for the schema fetch to stop. I have code completion turned off.
If I close the schema, then kill the app, the next time it will open as expanded, which times out, and i can't run any sql
If I close the schema, wait for the schema fetch to time out, then close the app and restart, it will open as expanded then it tries to immediately refresh the schema, which times out, and i can't run any sql
If I close the schema, wait for the schema fetch to time out, and reconnect, then it tries to immediately refresh the schema, which times out, and i can't run any sql
If I edit the schema_tree file in /Users/thomastobin/Library/Application Support/MySQL/Workbench/sql_workspaces for this workspace, and edit the line for "expanded" to be just "expanded=", when it opens it will open as expanded and time out.
If I turn off the "Restore expanded state of the active schema objects" in preferences, and restart the app, then the schema will open as expanded and time out.
If I turn off "show schema in sidebar" then the schema still appears at app start, and it times out, and can't run any sql

How to repeat:
I upgraded to 6.3.3 from 6.2.0 I think...

Suggested fix:
it should respect one of the settings. Any of them - the preferences "don't remember the expanded state", the last setting in the UI before the app quits. Something
[29 May 2015 11:01] Umesh Shastry
Hello Tom Tobin,

Thank you for the report.
Observed this on OS X 10.9.x Mavericks with MySQL Workbench Community
(GPL) for Mac OS X version 6.3.3  revision 0 build 592 (32 bit).

Thanks,
Umesh
[29 May 2015 11:02] Umesh Shastry
// I could not reproduce this on Win7 with WB 6.3.3
[26 Sep 2015 21:28] Tom Tobin
Still present in 6.3.4, by the way
[23 May 2017 20:07] Tony D
This is exact behavior is present in 6.3.9 CE 64-bit.

OS Name: Microsoft Windows 7 Professional
Version: 6.1.7601 Service Pack 1 Build 7601
[23 May 2017 20:51] Tony D
This works fine in 6.0.9 CE.

It is broken in 6.1.7 CE and 6.2.5 CE as well.