MySQL Bugs: #77176: MySQL Workbench always expanding schema and refreshing at connect

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:	MacOS (OS X 10.10.x Yosemite)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

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

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

// I could not reproduce this on Win7 with WB 6.3.3

Still present in 6.3.4, by the way

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

This works fine in 6.0.9 CE.

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