MySQL Bugs: #28545: Hang When Selecting a Schema on MySQL Query Browser

Bug #28545	Hang When Selecting a Schema on MySQL Query Browser
Submitted:	21 May 2007 2:56	Modified:	21 Jul 2007 23:10
Reporter:	Jason Daniels	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	v5.0	OS:	Linux (gentoo (Linux 2.6.20-gentoo-r7pseudopolis))
Assigned to:		CPU Architecture:	Any
Tags:	hang, Mysql Query Browser, Select Schema

Description:
Client Information:
MySQL Client Version 5.0.40
Linux 2.6.20-gentoo-r7pseudopolis
2x Intel(R) Pentium(R) D CPU 2.66GHz 2666.800 MHz, 2.0 GB RAM

Ubuntu MySQL Server Information:
MySQL 5.0.24a-Debian_9ubuntu2-log

Gentoo MySQL Server Information (localhost)
MySQL 5.0.40-log

How to repeat:
Method 1:
1. Start mysql-query-browser from a command prompt
2. Select Ubuntu MySQL Server or <
3. Fill in User Name and Password (NOT Default Schema)
4. Notice how the UI comes up and presents all schemas on the right hand side.
5. Click on a the "mysql" schema
6. Notice how the UI is now hung.
7. Wait Several minutes or several hours, it will not recover. Kill it the hard way (ctrl-c from Yakuake for me)

Method #2:
1. Start mysql-query-browser from a command prompt
2. Select <Ubuntu MySQL Server>
3. Fill in User Name, Password AND "mysql" as the default schema
4. Notice how the dialog goes away.
5. Check the command prompt after you see that the main UI is not coming up.
6. Notice how the app is still running.
7. Kill it the hard way.

I've repeated these steps with identical results for the following methods of installing the query browser:
#1. emerge --deep mysql-gui-tools [gentoos installer]
#2. binary download from the mysql site
#3. source code download and compile

Suggested fix:
1. Get rid of the hang when selecting a schema.
2. If this is the result of a binary protocol incompatibility (I doubt it as mysq-administrator works just fine) then have mysql-query-browser complain to the user.
3. Give me a magic wand to wave to get this to work :-)

Thank you for a problem report. Please, specify the exact version of Query Browser you had used.

Generic x86 Linux TAR (bundled dependencies)  	 	5.0r12

Thank you for the report.

Please connect to the MySQL server via mysql command line client, run following queries and say us result.

Queries:

USE mysql;
DESC user;

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

My apologies for the lateness of my reply.  For a variety of reasons I had to reinstall much of the gentoo operating system.  In this process I uninstalled all but the core system packages. After reinstalling the core OS packages I reinstalled the applications and servers I had noted as ones to keep.

Since reinstalling everything, the problem has not resurfaced.  This is terribly confusing, as I can't seem to isolate what could have made the difference.

Since I cannot reproduce this, I have marked it as closed.

In any case, thanks for your attention to this matter.
-- Jason

I am having the same problem. My environment:
openSuSE 10.3
MySQL Query Browser 1.2.12

When I try to connect to a database, if I specify a default schema on the 'Connect  to MySQL Server Instance' dialog, the window disappears. If I do not specify a default schema, I am able to connect. Once connected, if I click at a schema on Schemata tab or choose a schema from File->Select Schema... menu, the application hangs. On the other hand, if execute the command
use <schema_name>;

everything appears to work fine.