MySQL Bugs: #32037: Query Browser process enters in an infinite loop upon selecting a schema

Bug #32037	Query Browser process enters in an infinite loop upon selecting a schema
Submitted:	1 Nov 2007 19:32	Modified:	26 May 2009 13:13
Reporter:	Raul Gomez	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12	OS:	Linux (openSuSE 10.3 (x86_64))
Assigned to:		CPU Architecture:	Any
Tags:	Browser, crash, hang, query, schema, SELECT

Description:
When you select a database schema, Query Browser process enters in an infinite loop, eating up remaining CPU resources.

The problem arises when you open a connection to a database specifying a default schema, or when you select one once you have connected to the database.

I have downgraded to release 6 (1.12.6) and the problem disappears, schema selection works perfectly. Any release from 8 (the next one) to latest 12 seem to have this problem.

The problem is independent of the architecture version (i386, x86_64).

I only have used binaries provided in MySQL website.

How to repeat:
Just install a fresh copy of openSuSE 10.3, x86_64 version and MySQL GUI Tools 1.2.12 (SuSE or MySQL rpm binaries, doesn't matter).

Create a schema, add some tables and insert some registers.

Re-start Query Browser and select a schema. The infinite loop should happen.

With 1.12.6 I cannot reproduce the problem (seems not bugged).

Suggested fix:
No idea, but you can review the changes related to schema selection introduced between 1.2.6 and 1.2.8 releases, as a starting point.

Thank you for the bug report. Verified as described:

./mysql-query-browser: line 103: 16998 Killed                  $PRG-bin $args
miguel@pochita:~/mysql-gui-tools-5.0> cat /etc/issue

Welcome to openSUSE 10.3 (X86-64) - Kernel \r (\l).

As a note after experining this problem with 10.3 so i installed Fedora 8, and am having this same proble

Bug: http://bugs.mysql.com/bug.php?id=32818 was marked as duplicate of
this one.

I have the same problem on Fedora 8. Hope this bug will be fixed soon.

Alex,

Anja Stock from Novell has recently distributed an update of openSuSE's Query Browser rpm package, with the following patch applied to the source:

mysql-gui-tools-5.0r11.ORIG/mysql-query-browser/source/linux/MQQueryDispatcher.cc mysql-gui-tools-5.0r11/mysql-query-browser/source/linux/MQQueryDispatcher.cc
--- mysql-gui-tools-5.0r11.ORIG/mysql-query-browser/source/linux/MQQueryDispatcher.cc	2007-02-21 01:31:19.000000000 +0000
+++ mysql-gui-tools-5.0r11/mysql-query-browser/source/linux/MQQueryDispatcher.cc	2007-11-09 15:31:38.000000000 +0000
@@ -558,8 +558,8 @@
 
   Gtk::Main::instance()->run();
 
-  while(!req->is_complete())
-    ;
+//  while(!req->is_complete())
+//    ;
 
   return sps;
 }

Now, it isn't freezing anymore.

You can see it here: https://bugzilla.novell.com/show_bug.cgi?id=339356

This bug is resolved, I hope MySQL Query Browser dev team apply this patch to the next program release.

Raúl

Thanks Raul. Everything is working fine now.

see my version of solution posted in response to bug 30055
i needed no patch

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/