Bugzilla – Bug 310259
mysql-query-browser hangs on startup
Last modified: 2007-12-11 16:11:24 UTC
After starting mysql-query-browser the conection dialog appears as usual. Choosing a connection - regardless which one - and clicking connect leads to mysql-query-browser consuming 100% CPUtime and not showing up any kind of window. strace says nothing.
Still happens on RC3 (Gold)
Same for me, after selecting the connection the dialog vanishes und nothing else happens. CPU-Consumption jumps up, nothing else. I use the x86_64 version and I tried recompiling it. No change so far.
the same thing happens to me, i tryed latest version from Factory (libmysqlclient15-5.0.45-25.i586.rpm, libmysqlclient_r15-5.0.45-25.i586.rpm, mysql-query-browser-5.0r12-66.i586.rpm) but problem remain. I installed also latest staticaly linked version from mysql.org mysql-gui-tools-5.0r12-linux-i386.tar.gz but problem still remains. I tryed to connect to local database via port or socket file and i tryed to connect to remote database - in all cases i got the same problem :(
I have very similar symptoms. When running the query browser and connecting to the database I do not specify the default schema and I get the main window, but when I then run the command "use <schema>" the browser hangs and consumes 100% CPU. I have tried with a query-browser on an i586 and x86_64 versions of suse 10.3 connecting to mysql database on suse x86_64 versions 10.2 and 10.3 with the same results. All versions of suse are fully patched.
*** Bug 335525 has been marked as a duplicate of this bug. ***
Created attachment 181948 [details] Connection Dialogue
Created attachment 181949 [details] Select Schema
Workaround: Do not enter a "Default Schema" in the connection dialogue. Just enter the host, user and password information and click on "Connect". Once the main window appears, go to the menu -> File -> Select Schema... and pick the database you want to work with. Do not click on the database name in the right part of the window, that crashes the mysql-browser. (See attachments)
Sorry Andreas, I was just going to declare You as my "personal hero". But then I discovered that Your workaround doesn't work for me. It is true, that I can enter the main screen but as soon as I try to open a schema, the software hangs taking all processor ressources. Even using "use <db>;" causes a hangup. Torsten...
Simple workaround: You can find 5.0r4 packages (as shipped with 10.2) built for 10.3 in my buildservice homeproject: http://download.opensuse.org/repositories/home:/cwh/openSUSE_10.3/
Thanks Christopher, this is much more like it. Now I don't need the ssh -X "workaround" to an older machine anymore. But I still hope it will be fixed some day. Torsten...
Didn't you all have dependency problems with installing mysql-query-browser? When I tried to install the mysql-query-browser .rpm File it stopped, because I had a newer versions of the libgtkhtml and the libgailutil libraries on my system and therefore YAST couldn't find the older libraries needed. I had to force the installation with --nodeps (rpm -i --nodeps mysql-query-browser-5.0r12-1suse10.i586.rpm) and make hard links with the required libraries (ln libgailutil.so.18.0.1 libgailutil.so.17 and also ln libgtkhtml-3.14.so.19.1.0 libgtkhtml-3.8.so.15). How could you solve that problem? After these durty hacks I could start mysql-query-browser like you all, but it also crashes when I'm trying to use a database or double click on a existing database on the right side of the window.
(In reply to comment #12 from Jan Bielik) > (...) > mysql-query-browser-5.0r12-1suse10.i586.rpm) and make hard links with the > required libraries (ln libgailutil.so.18.0.1 libgailutil.so.17 and also ln > libgtkhtml-3.14.so.19.1.0 libgtkhtml-3.8.so.15). Where did you get your query-browser package? For me it looks like you tried to install it from an alpha or beta version. In the meanwhile the original problem is fixed. Use online update to install mysql-query-browser-5.0r12-56.2
I have downloaded the MySQL GUI Tools for SuSE Linux 10.x (x86) from the official URL (http://dev.mysql.com/downloads/gui-tools/5.0.html). I would be very surprised if that was an alpha or beta version. The initial reason why I have downloaded it from the URL is because I couldn't find it in YAST. Do you perhaps know why I couldn't find it?
The package on mysql.com is built for some stone age distribution and definitely not for 10.3. So no wonder that it has unresovable dependencies. SUSE packages for 10.3 can be found on DVD2 or here: http://download.opensuse.org/distribution/10.3/repo/oss/
Thx a lot christopher, the dependency problems were gone with the new SUSE packages. Unfortunately mysql-query-browser now crashes every time I try to use a database (I tryed it both ways: 1. by double clicking on the right side of the window and 2. with the command use databasename)..
So please do an online update to get the bugfixed version.
You're my hero! Everything works fine now.. Again thx a lot christopher!