[opensuse] mySQL Query Browser Hangs when selecting a schema
Hi Guys I downloaded the mysql query browser from the opensuse site to help me be a little more productive when developing MySQL. I also downloaded the MySQL administrator RPM. The admin app works fine. However when I use the query browser it hang when I select a schema. If I don't log in with a default schema it works fine. I can also write queries by using fully qualified object names ie. `dbname'.'tablename'. However if I select a schema visually or even do the 'use dbname' it dies on me and zombies the process using 99% CPU. I noticed some bug reports about this on the opensuse and MySQL bug pages. There is even a patch that is mentioned. Has anyone else run into this problem and have a solution? Regards Neil ----------------------------------------- Engen Petroleum Limited, disclaims liability for any loss, damage or expense however caused, arising from the sending, receipt, or use of this e-mail and on any reliance placed upon the information provided through this service and does not guarantee the completeness or accuracy of the information. Please visit http://www.engen.co.za/home/server/common/disclaimer.asp to view the full disclaimer. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Cornelius Franken wrote:
Hi Guys
I downloaded the mysql query browser from the opensuse site to help me be a little more productive when developing MySQL. I also downloaded the MySQL administrator RPM. The admin app works fine.
However when I use the query browser it hang when I select a schema. If I don't log in with a default schema it works fine. I can also write queries by using fully qualified object names ie. `dbname'.'tablename'. However if I select a schema visually or even do the 'use dbname' it dies on me and zombies the process using 99% CPU.
I noticed some bug reports about this on the opensuse and MySQL bug pages. There is even a patch that is mentioned. Has anyone else run into this problem and have a solution?
Regards Neil
Neil, I authored one of the bugs on mysql-query browser. The build service had put out a bad rpm and it was corrected as soon as it was brought to their attention. I have no problems running it on the LAN or across the internet to remote sites. Make sure you have the right version of mysql-qui-tools installed. Mine is: 23:35 Rankin-P35a~> rpm -q mysql-gui-tools mysql-gui-tools-5.0r12-56 Works great! -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Neil, I authored one of the bugs on mysql-query browser. The build >service had put out a bad rpm and it was corrected as soon as it was brought to their attention. I have no problems running it on the LAN or across the internet >to remote sites.
Make sure you have the right version of mysql-qui-tools installed. >Mine is:
23:35 Rankin-P35a~> rpm -q mysql-gui-tools mysql-gui-tools-5.0r12-56
Works great!
Hi There I have this version of the gui-tools rpm installed. The Browser works fine when you set it to a default schema when you log on. When you change schemas it still hangs. My problem is that I am busy copying data from one schema to another using SQL queries and I would like to change to another schema to look at the table structures. However if I log in as root into DB schema A everything is fine. When I click on schema B the browser hangs/zombifies and use 99% CPU. To be honest I don't need the tool but it makes me a little more productive and I like that. Regards Neil ----------------------------------------- Engen Petroleum Limited, disclaims liability for any loss, damage or expense however caused, arising from the sending, receipt, or use of this e-mail and on any reliance placed upon the information provided through this service and does not guarantee the completeness or accuracy of the information. Please visit http://www.engen.co.za/home/server/common/disclaimer.asp to view the full disclaimer. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Neil, I authored one of the bugs on mysql-query browser. The build >service had put out a bad rpm and it was corrected as soon as it was brought to
their
attention. I have no problems running it on the LAN or across the internet >to remote sites.
Make sure you have the right version of mysql-qui-tools installed. >Mine is:
23:35 Rankin-P35a~> rpm -q mysql-gui-tools mysql-gui-tools-5.0r12-56
Works great!
Hi. This issue seems to be a known bug. They mention a patch in this bugzilla report https://bugzilla.novell.com/show_bug.cgi?id=339356 how do I apply this patch? ----------------------------------------- Engen Petroleum Limited, disclaims liability for any loss, damage or expense however caused, arising from the sending, receipt, or use of this e-mail and on any reliance placed upon the information provided through this service and does not guarantee the completeness or accuracy of the information. Please visit http://www.engen.co.za/home/server/common/disclaimer.asp to view the full disclaimer. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Cornelius Franken wrote:
Neil, I authored one of the bugs on mysql-query browser. The build >service had put out a bad rpm and it was corrected as soon as it was brought to their attention. I have no problems running it on the LAN or across the internet >to remote sites.
Make sure you have the right version of mysql-qui-tools installed. >Mine is:
23:35 Rankin-P35a~> rpm -q mysql-gui-tools mysql-gui-tools-5.0r12-56
Works great!
Hi.
This issue seems to be a known bug. They mention a patch in this bugzilla report https://bugzilla.novell.com/show_bug.cgi?id=339356 how do I apply this patch?
For the original poster, Neil (I think). I don't know what else to say except you must not have the update applied. The fix came out months ago. I just tested mysql-query-browser to confirm. I can connect and switch schemas without any hang both using the File->Select Schema menu or just choosing the database I want to see using the "schemata" window on the right side of the query browser. I switched between the egroupware, mysql, test and Information Schemata databases and back and forth without a hitch. The only thing else I can suggest is that you remove and reinstall the gui-tools. You can either use Yast or the command line as root: rpm -e mysql-gui-tools && zypper in mysql-gui-tools -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----Original Message----- From: David C. Rankin [mailto:drankinatty@suddenlinkmail.com] Sent: 19 May 2008 09:25 PM To: suse Subject: Re: [opensuse] mySQL Query Browser Hangs when selecting a schema Cornelius Franken wrote:
Neil, I authored one of the bugs on mysql-query browser. The build >service had put out a bad rpm and it was corrected as soon as it was brought to their attention. I have no problems running it on the LAN or across the internet >to remote sites.
Make sure you have the right version of mysql-qui-tools installed. >Mine is:
23:35 Rankin-P35a~> rpm -q mysql-gui-tools mysql-gui-tools-5.0r12-56
Works great!
Hi.
This issue seems to be a known bug. They mention a patch in this bugzilla report https://bugzilla.novell.com/show_bug.cgi?id=339356 how do I apply this patch?
For the original poster, Neil (I think). I don't know what else to say >except you must not have the update applied. The fix came out months ago. I just tested mysql-query-browser to confirm. I can connect and switch schemas without any hang both using the File->Select Schema menu or just choosing the database I want to see using the "schemata" window on the right side of the query browser. I switched between the egroupware, mysql, test and Information
Schemata databases and back and forth without a hitch.
The only thing else I can suggest is that you remove and reinstall the gui-tools. You can either use Yast or the command line as root:
rpm -e mysql-gui-tools && zypper in mysql-gui-tools
Hi David. Excuse my newbie type questions. Originally I downloaded the mysql-gui-tools-5.0r12-suse10-i386.tar.gz from the mysql site. I installed it and the administrator worked but not the query-browser. The query-browser complained about a missing file called libgtkhtml3x or something like that. So I downloaded mysql-query-browser-5.0r12-56.i586.rpm from the opensuse software site. This installed and worked but has the problem relating to schema as discussed in the thread. Now I am wondering if installing the rpm's from mysql has not broken something else. I did download the opensuse 10.3 version on the site and not any of the other. Think I should uninstall and reinstall it. Regards Neil ----------------------------------------- Engen Petroleum Limited, disclaims liability for any loss, damage or expense however caused, arising from the sending, receipt, or use of this e-mail and on any reliance placed upon the information provided through this service and does not guarantee the completeness or accuracy of the information. Please visit http://www.engen.co.za/home/server/common/disclaimer.asp to view the full disclaimer. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Cornelius Franken wrote:
Now I am wondering if installing the rpm's from mysql has not broken something else. I did download the opensuse 10.3 version on the site and not any of the other. Think I should uninstall and reinstall it.
Regards Neil
Yes, What I would recommend is to first uninstall the mysql-gui-tools rpm that you installed and then check to make sure there aren't any lingering pieces of the source package you installed giving you problems. Then make sure you have at least the "oss" and "update" repositories selected in Yast->Software->Community Repositories this will insure you pickup the main package and the update. Then reinstall the package either Yast or zypper to make sure you bring in any dependencies. The do either Yast->Software->Online Update or from the command line, "zypper up". You can always check to see if there is a main package and an update need using webpin: 08:59 Rankin-P35a~> webpin mysql-gui-tools 2 results (1 packages) found for "mysql-gui-tools" in openSUSE_103 * mysql-gui-tools: Common Files for MySQL GUI Tools - 5.0r12 [suse-oss{ppc} | suse-update{src}] @ http://download.opensuse.org/distribution/10.3/repo/oss/suse @ http://download.opensuse.org/update/10.3 Once you have the package and the update, it will work fine. -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
David C. Rankin wrote:
Cornelius Franken wrote:
Now I am wondering if installing the rpm's from mysql has not broken something else. I did download the opensuse 10.3 version on the site and not any of the other. Think I should uninstall and reinstall it. Regards Neil
Yes,
What I would recommend is to first uninstall the mysql-gui-tools rpm that you installed and then check to make sure there aren't any lingering pieces of the source package you installed giving you problems.
Then make sure you have at least the "oss" and "update" repositories selected in Yast->Software->Community Repositories this will insure you pickup the main package and the update. Then reinstall the package either Yast or zypper to make sure you bring in any dependencies. The do either Yast->Software->Online Update or from the command line, "zypper up". You can always check to see if there is a main package and an update need using webpin:
08:59 Rankin-P35a~> webpin mysql-gui-tools 2 results (1 packages) found for "mysql-gui-tools" in openSUSE_103 * mysql-gui-tools: Common Files for MySQL GUI Tools - 5.0r12 [suse-oss{ppc} | suse-update{src}] @ http://download.opensuse.org/distribution/10.3/repo/oss/suse @ http://download.opensuse.org/update/10.3
Once you have the package and the update, it will work fine.
Also, for information about the problem leading to the update, see: https://bugzilla.novell.com/show_bug.cgi?id=340459 -- David C. Rankin, J.D., P.E. Rankin Law Firm, PLLC 510 Ochiltree Street Nacogdoches, Texas 75961 Telephone: (936) 715-9333 Facsimile: (936) 715-9339 www.rankinlawfirm.com -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
Cornelius Franken -
David C. Rankin