MySQL Bugs: #27224: Query Browser hangs on dropped connection to remote db

Bug #27224	Query Browser hangs on dropped connection to remote db
Submitted:	16 Mar 2007 18:48	Modified:	9 Aug 2007 22:26
Reporter:	Axel Muench	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.10rc	OS:	MacOS (OSX 10.4.8)
Assigned to:		CPU Architecture:	Any

Description:
1 - Connecting to a mysql db 4.x or 5.x on Solaris hosted outside the local network
2 - Leave Mysql-Query Browser idle in background for 30 mins
3 - Trying to use the application results in the OSX spinning beach ball and application hangs.

4 - Same situation on a remote db on our local network informs me that the connections have been dropped but succesfully reconnected.

Please see Query Browser error log below.

Thanks.

How to repeat:
Date/Time:      2007-03-15 14:59:18.705 -0700
OS Version:     10.4.8 (Build 8L2127)
Report Version: 4

Command: MySQL Query Browser
Path:    /Applications/MySQL Tools/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser
Parent:  WindowServer [62]

Version: ??? (1.2.10rc)

PID:    3879
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_INVALID_ADDRESS (0x0001) at 0x424f4c67

Thread 0 Crashed:
0   libobjc.A.dylib            	0x90a55380 objc_msgSend + 16
1   com.apple.Foundation       	0x925e5207 _nsnote_callback + 230
2   com.apple.CoreFoundation   	0x908533f6 __CFXNotificationPost + 345
3   com.apple.CoreFoundation   	0x9084ac11 _CFXNotificationPostNotification + 600
4   com.apple.Foundation       	0x925dd860 -[NSNotificationCenter postNotificationName:object:userInfo:] + 121
5   com.apple.Foundation       	0x925e4755 -[NSNotificationCenter postNotificationName:object:] + 55
6   com.mysql.MySQLToolsCommon 	0x100154b3 -[MTableEditor applyChanges:] + 1702
7   com.apple.AppKit           	0x9333bd88 -[NSApplication sendAction:to:from:] + 107
8   com.apple.AppKit           	0x9333bce1 -[NSControl sendAction:to:] + 101
9   com.apple.AppKit           	0x9333de91 -[NSCell _sendActionFrom:] + 168
10  com.apple.AppKit           	0x93350671 -[NSCell trackMouse:inRect:ofView:untilMouseUp:] + 1271
11  com.apple.AppKit           	0x9336e25d -[NSButtonCell trackMouse:inRect:ofView:untilMouseUp:] + 848
12  com.apple.AppKit           	0x9336db0d -[NSControl mouseDown:] + 757
13  com.apple.AppKit           	0x9332b3af -[NSWindow sendEvent:] + 5279
14  com.apple.AppKit           	0x9331d350 -[NSApplication sendEvent:] + 5023
15  com.apple.AppKit           	0x93247dfe -[NSApplication run] + 547
16  com.apple.AppKit           	0x9323bd2f NSApplicationMain + 573
17  com.mysql.QueryBrowser     	0x0000201c main + 30 (main.m:14)
18  com.mysql.QueryBrowser     	0x00001fa6 _start + 228 (crt.c:272)
19  com.mysql.QueryBrowser     	0x00001ec1 start + 41

Thread 1:
0   libSystem.B.dylib          	0x9003f23f syscall_thread_switch + 7
1   com.apple.AppKit           	0x9332566e -[NSUIHeartBeat _heartBeatThread:] + 1399
2   com.apple.Foundation       	0x925ed36c forkThreadForFunction + 123
3   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 2:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.mysql.MySQLToolsCommon 	0x1000b6c5 -[MMySQLDispatcher(Private) getNextRequest] + 58
2   com.mysql.MySQLToolsCommon 	0x1000bb0e processRequests + 84
3   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 3:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.mysql.MySQLToolsCommon 	0x1000b6c5 -[MMySQLDispatcher(Private) getNextRequest] + 58
2   com.mysql.MySQLToolsCommon 	0x1000bb0e processRequests + 84
3   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 4:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.mysql.MySQLToolsCommon 	0x1000b6c5 -[MMySQLDispatcher(Private) getNextRequest] + 58
2   com.mysql.MySQLToolsCommon 	0x1000bb0e processRequests + 84
3   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 5:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.mysql.MySQLToolsCommon 	0x1000b6c5 -[MMySQLDispatcher(Private) getNextRequest] + 58
2   com.mysql.MySQLToolsCommon 	0x1000bb0e processRequests + 84
3   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 0 crashed with X86 Thread State (32-bit):
  eax: 0x424f4c47    ebx: 0x10020734 ecx: 0x90ab89ec edx: 0x005e27d0
  edi: 0x00000000    esi: 0x005a2fe0 ebp: 0xbffff378 esp: 0xbffff358
   ss: 0x0000001f    efl: 0x00010202 eip: 0x90a55380  cs: 0x00000017
   ds: 0x0000001f     es: 0x0000001f  fs: 0x00000000  gs: 0x00000037

Thank you for the report.

One thing is not clear:

> 3 - Trying to use the application results in the OSX spinning beach ball and
> application hangs.

Please specify exactly step-by-step what you do: simple select query, wait 30 minutes, click "Edit" doesn't hung for me.

It doesn't matter what I do in Query Browser, after letting it idle for a while (sometimes less than 30 mins sometimes 1 hour+) it hangs 100%. It never gets to the dialog that the conection was dropped and it is trying to reconnect such as it happens on the local network.

Please provide configuration file for your mysqld.

Here is the info from the web host:

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
set-variable    = key_buffer=256M
set-variable    = max_allowed_packet=2M
set-variable    = table_cache=300
set-variable    = sort_buffer=32M
set-variable    = max_user_connections=50
set-variable    = max_connections=450
set-variable    = query_cache_type=1
set-variable    = query_cache_size=10M
set-variable    = thread_cache_size=200
set-variable    = ft_min_word_len=2
set-variable    = delayed_insert_timeout=1
server-id       = 1

Thank you for the feedback.

I was not able to repeat described behaviour. Please upgrade to current 1.2.12 version of MySQL Query Browser, try with it and inform us if error still happens with this version of Query Browser.

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".

Hi, I have this same issue with macosx and the query browser, using version 1.2.12. Whenever there is a brief dropped connection, the query browser will hang for a significant period of time after a new query is issued. After this long period (usually 20-30 minutes of hanging), the browser will say that the connection was lost and ask whether it should reissue the query. Perhaps the reason you're not able to reproduce it is because you are not on a lossy connection? I'm connecting to database hosted on a different machine from a wireless connection and I lose the connection briefly every 5 minutes or so (similar to when the previous poster suggests leaving the browser on in the background for 30 minutes). It seems excessive for the query browser to take upwards of 30 minutes to recover from a dropped connection.

Thanks!

Thank you for the feedback.

I can not repeat 20-30 minute silent hung with dropped connection too. Reconnect takes about 5 minutes for me and all time I see rainbow cursor first, than message about Query Browser is trying to excute query and moving dolphin. So I close the report as "Can't repeat".

Ok, hold on a second please. It hangs for 5 minutes for you and you are closing the report as "can't repeat'? 5 minutes is not acceptable to recover from a dropped connection, maybe 1-3 seconds are, but not 5 minutes! This report is not closed for me. Let's fix this problem.

5 minutes it waits to report "Connection reject" error (when I shutdown remote server). To restore broken connections it takes about 1 second for me (after restart remote server).

Maybe this helps - My MySQL and MyPHPAdmin both hang in the browser (no response) whenever I have my wireless USB connected.  If I unplug it both MysSQL and PHPMyAdmin work fine. 

PHPMyAdmin hangs on the log in screen in the IE browser - no response.
MySQL connections in a PHP script running in the IE browser or Eclipse - also just hang.

Sorry, that didn't really help - I meant help solve the problem.  Someone please find a solution
Regards