Bug #63587 Tables stuck "fetching..."
Submitted: 4 Dec 2011 23:31 Modified: 7 Dec 2011 7:59
Reporter: Jeremy Bell Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.36 OS:MacOS
Assigned to: CPU Architecture:Any
Tags: Fetching, tables

[4 Dec 2011 23:31] Jeremy Bell
Description:
Upon expanding the schema for our database which is on a remote server with more than 1400 tables, the 3 sections underneath all say "Fetching..." and do not change. In Workbench 5.2.35, the tables would load within around a minute at the most.

This bug also prevents us from editing any data whatsoever, since disappointingly, and frustratingly the schema list must be expanded to be able to edit anything at all.

How to repeat:
Load workbench for a *remote* database with *more than 1400 tables*. Attempt to expand the schema to view all tables.

Suggested fix:
See what has changed between versions 5.2.35 and 5.2.36 in this area, because the tables loaded relatively quickly in 5.2.35. Possibly revert to 5.2.35 for this code?
[6 Dec 2011 23:09] Bob Dankert
I found that it was about 10x slower to fetch the tables list in 5.2.36 (reported on bug http://bugs.mysql.com/bug.php?id=63633).  Does the list eventually populate if you just let it sit and keep working?
[6 Dec 2011 23:25] Jeremy Bell
Yes, the tables do load eventually, after over half an hour :(
[7 Dec 2011 7:59] Valeriy Kravchuk
Let's consider this a duplicate of verified bug #63633.