MySQL Bugs: #32293: Query browser cannot select schema on Fedora 8

Bug #32293	Query browser cannot select schema on Fedora 8
Submitted:	12 Nov 2007 20:07	Modified:	14 May 2009 12:32
Reporter:	John Leary	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	5.0r12-3.fc8	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	fedora 8, query browser, select default schema

Description:
I installed a fresh copy of i386 Fedora 8 on an older compaq and a new dual core Intel pc.  The process installed version 5.0.45-4.fc8 of mysql-server and version 5.0.45-4.fc8 of mysql. I then did a "yum install mysql-query-browser" to install the query browser.  That installed version 5.0r12-3.fc8 of the query browser.  When I run the query browser I am able to successfully log in with the DB credentials.  When the program is running and I select a default schema the program freezes.  I have tried it by using the file=>Select Schema and also clicking on the Schemata name.  Both operations cause the query browser to freeze up and not respond any more.  I have reproduced this problem on two different machines both running Fedora 8.  I'm not sure if the problem is the OS or the query browser.  I am able to successfully connect to the database using the query browser on a windows machine networked with the Fedora 8 machine.  That query browser version 1.2.12 for windows seems to work ok.  The problem appears to be centered on the Query Browser running on the native Fedora 8 machine.

How to repeat:
1 - fresh install of Fedora 8 including mysql database
2 - yum install mysql-query-browser
3 - authenticate to database with query browser
4 - select schema - program locks up

Thank you for the bug report. Could you please test the GUI-Tools package
from our download page: http://dev.mysql.com/downloads/gui-tools/5.0.html
and comment here if still you get the same behavior. Thanks in advance.

I installed the Generic x86 Linux TAR (bundled dependencies)version 5.0r12 from the download site.  It installed version 1.2.12 of the query browser.  If I select the schema through the File=>Select Schema menu option the query browser works fine.  If I double click on schema name from the right side Schemata tab the query browser program locks up.

I can verify this bug using both the Fedora 8 supplied .rpm files and the official MySQL downloaded version. Additionally, I can replicate this bug in Fedora 8 for the i386 and the x86_64 architecture. As the mysql-query-browser process begins to consume more cpu time, it begins to give font errors. Mine are given below.
---
Gtk-Message: Failed to load module "gnomebreakpad": libgnomebreakpad.so: cannot open shared object file: No such file or directory
/usr/share/themes/Glossy/gtk-2.0/gtkrc:35: error: unexpected character `@', expected string constant
Fontconfig warning: line 32: unknown element "cachedir"
Fontconfig warning: line 33: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"
---
(mysql-query-browser-bin:3817): Pango-WARNING **: Error loading GPOS table 4097

After which I killed the process. It seems that the query browser is searching for a font that does not exist. Perhaps this has something to do with the absence of the xfs in Fedora 8? If there is anything I can do to help troubleshoot this, please let me know.

Thank you for the feedback. Verified on FC 8 64-bit.

I install Fedora 8 + MySQL Server 5.0.54. After that, I install Mysql GUI Tools Package. All Program Work fine but Mysql Query browser is hang up.

Issue the same for me:
SoftWares:
Linux xxx 2.6.23.1-49.fc8 #1 SMP Thu Nov 8 21:41:26 EST 2007 i686 i686 i386 GNU/Linux
mysql-query-browser-5.0r12-3.fc8.i386

What about this article:
http://bugs.mysql.com/bug.php?id=9560
|
V
http://bugs.mysql.com/bug.php?id=30055&thanks=sub
|
V
Patch:
http://bugs.mysql.com/file.php?id=7752 (mysql-gui-tools.chema_change_freeze_bug.patch)

This patch is for mysql-query-browser 5.0r11, but can be that it is not built in the 5.0r12.
Could somebody confirm it / I try to test it, but need to learn src rpm install ;-) first?

i applied the above patch form mysql-query-browser on fedora 8 but it doesn't help.

I have the same problem (described http://bugs.mysql.com/bug.php?id=32804).
I found the source file where the while instructions has to be commented as described in the patch but I wasn't able to compile it correctly (too much missing libraries and I'm not a Linux expert...). But as I see before, It doesn't help anyway...

Bug #32804 was marked as a duplicate of this one.

As I used a Fedora 8 x86_64, I tried a new installation using a Fedora 7 i386.
After perfoming complete system update (kernel, ...), I installed MySQL release downloaded from web site (Fedora 5). Everything works perfectly.
I will try to test it with a Fedora 8 i386 and included MySQL FC8 to check if it is not a problem of distribution choice (x86_64 / i386) with my Pentium 4 HT (which is said as 64 bits).

i am having the same problem with downloaded file mysql-gui-tools-5.0r12-linux-i386.tar.gz.

During startup already have this error below:

[choojun@billy-mobl mysql-gui-tools-5.0]$ ./mysql-query-browser
Gtk-Message: Failed to load module "gnomebreakpad": libgnomebreakpad.so: cannot open shared object file: No such file or directory
/usr/share/themes/Nodoka/gtk-2.0/gtkrc:35: error: unexpected character `(', expected character `}'
Fontconfig warning: line 28: unknown element "cachedir"
Fontconfig warning: line 29: unknown element "cachedir"
Fontconfig warning: "/etc/fonts/conf.d/80-delicious.conf", line 18: invalid match target "scan"

Same as the rest, when double click on the schema name, the MySQL Query GUI lock up!!

my OS detail as below:
[choojun@billy-mobl mysql-gui-tools-5.0]$ uname -a
Linux billy-mobl 2.6.23.8-63.fc8 #1 SMP Wed Nov 21 18:51:08 EST 2007 i686 i686 i386 GNU/Linux

Enabling the xfs server on fc8 solves the problem.

sudo /sbin/service xfs start

To enable it after each restart:

sudo /sbin/chkconfig xfs on

The previous solution only works if you choose the schema from the file menu.

I followed the suggestion of Suriem.  

I did a "yum install xfs" since it does not appear to install with the default packages.  Then I ran "/etc/init.d/xfs start" to start the xfs service.  I next tried the query browser.

It still locks up when selecting a schema.  This does not appear to change the behavior.

Yes, u are right, for some extrange reason the query tool work for me 
after starting the xfs server but now it hooks agains.

someone could erase my posts?

The issue seems solved in last yum update on fedora 8,

mysql-query-browser-5.0r12-4.fc8.

fixed this bug: https://bugzilla.redhat.com/show_bug.cgi?id=266781

I had similar problem on 386 and x64 running suse10.3
see my successful solution commented to bug 30055
david

hi every one ... yeah!!!! It is solved in below update in Fedora 8
mysql-query-browser-5.0r12-4.fc8

Hi, I think it's important to let everyone know that the version being distributed by MySQL does not work with Fedora Core 8 (x86_64 I can confirm still broken as of today, same issue as above).  

The source code builds correctly but does NOT run (mysql-gui-tools-5.0r12.tar.gz) on my x86_64. I don't know what the Fedora crew did to build the working yum versions, but I wish they'd share it with us. 

Therefore : all FC 8 users install mysql-query-browser and mysql-administrator via these commands :

yum install mysql-query-browser

Answer yes to the pre-requisites question. Then proceed to install 

yum install mysql-administrator

Also : the MySQL binaries go to /opt and the yum version goes /usr/bin so remember to clean one before installing the next. I spent a few hours to find this so I hope it helps someone in same situation.

Regards,
Zé

Well, one of the things that's been circulated is the following patch. As this bug is in Debian now as well, but not all installations are affected.

patch: https://bugzilla.redhat.com/attachment.cgi?id=218451

Note for Ubuntu 8.04 hardy:
The package from the mysql website still has the bug.

Install mysql-query-browser via command line:

sudo apt-get install mysql-query-browser

Will work ok after.

confirming the bug on FC8, running 
mysql-query-browser.i386 5.0r12-4.fc8
mysql-gui-tools.i386     5.0r12-4.fc8

In my case, I believe what is happening is that I am trying to connect to a db with a large number of tables and the query browser is trying to load them all in.  From command line, I avoid this by using -A and I think that the GUI should use this by default.  If I select the db of interest in the connection settings it hangs right away on connect.  If I intstead specify mysql as the db in connection settings, I can connect fine and then it hangs when I either select the schema or execute 'use my_large_db'.  I suspect that adding the equivalent of -A would solve the problem but that's just a guess.  I would appreciate if someone could work on this, as it makes this great tool useless on linux.

For Fedora users:
1) Go to http://rpm.pbone.net/index.php3
2) Advanced RPM Search
3) Select fedora version (tested with fedora 8)
4) Download mysql-query-browser-5.0r12-4.fc8.i386.rpm
5) Extract the content of mysql-query-browser-5.0r12-4.fc8.i386.rpm
6) Replace /usr/bin/mysql-query-browser with new file (extracted on step 5)
7) Replace /usr/bin/mysql-query-browser-bin with new file (extracted on step 5)
8) Delete or rename folder /usr/share/mysql-gui/query-browser
9) Copy folder "query-browser" (from step 5) to /usr/share/mysql-gui/

Tested with fedora 8 , kernel 2.6.23.1-42.

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/