Bug #26732 Schem displays "Fetching Data" forever
Submitted: 28 Feb 2007 20:14 Modified: 29 Jan 2009 9:40
Reporter: Martin Friebe (Gold Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:1.2.11 OS:Windows (Windows XP)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: qc

[28 Feb 2007 20:14] Martin Friebe
Description:
This may only be exploitable if the query browser connects to a slower remote server via TCP/IP.

Best is to have 2 or 3 Databases, each with at least 20 tables.
(So I was able to reproduce it between the `mysql` database and a database containing only 3 procedures)

In the schema tree, Click on 2 or 3 of the arrows to open the tree and display the tables/procedures within each db.

It is important that the 2nd and 3rd db are clicked open, before the QB has finished querying the first db.

The other DBs will display fetching data", and that seems to be forever (waited 10 minutes)

You can always click the arrow in front of any of them again (close/open) and they will load the content. So it is no major issue

How to repeat:
see description above

Suggested fix:
-
[2 Mar 2007 18:34] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat with a newer version, 1.2.10 (from GUI Tools 5.0-r10), and inform about the results.
[13 Mar 2007 14:21] Martin Friebe
Reproducible with 1.2.10
However, you either need to be very quick, or have a slow server.

Set up a db server on a seperate box.
Create 5 db, with a 100 tables each.

If needed, ensure the PC holding the Mysql server is very busy or slow (eg, run some CPU intensive program)

Start query browser.

in the schemata panel click all the arrows in front of each DB-name, to open the db, and display the tables. This is best done starting with the one at the bottom, working your way up.

You must click open the other DB, before the 1st DB finished reading it's table list.

Once the DB first clicked is showing the table list, the other DBs are still showing "Fetching Data ...", and this will not change (unless you click the arrow again for each DB)
[7 May 2007 12:50] Valeriy Kravchuk
Verified just as described in your last comment, with 1.2.11.
[12 Jul 2007 3:41] Valeriy Kravchuk
Bug #29746 was marked as a duplicate of this one.
[28 Aug 2007 14:03] Mans Larsson
I have 1.2.11 and a databse server with 7 databases. Works great for 6 of them, but the "big on" (+50 tables) just wont show up - displays "fetching data" forever... Bug reported 28 feb - still no solution for this?
[29 Jan 2009 9:40] Mike Lischke
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/