Bug #24591 Crash while doing select in Gui

• Submitted: 25 Nov 2006 23:15
• Modified: 9 Jan 2007 9:35
• Reporter: Cid Dennis
• Status: Can't repeat
• Category: MySQL Query Browser
• Severity: S2 (Serious)
• Version: 1.2.6beta
• OS: MacOS (MAC OS)
• Assigned to: Vladimir Kolesnikov
• CPU Architecture: Any

[25 Nov 2006 23:15] Cid Dennis

Description:
CRash when doing select in gui

How to repeat:
Not sure I can do it every time on my Intel Mac 17" Powerbook Core 2 Duo.  Baicly I just do a select and execute and after a while it crashes.

Suggested fix:
Date/Time:      2006-11-25 16:10:20.814 -0700
OS Version:     10.4.8 (Build 8N1051)
Report Version: 4

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

Version: ??? (1.2.6beta)

PID:    1204
Thread: 0

Exception:  EXC_BAD_ACCESS (0x0001)
Codes:      KERN_PROTECTION_FAILURE (0x0002) at 0x00000000

Thread 0 Crashed:
0   com.mysql.MySQLToolsCommon 	0x1002a794 -[MQResultSetView displayResults:] + 2520
1   com.mysql.MySQLToolsCommon 	0x1002ae63 -[MQResultSetView queryProgress:] + 227
2   com.apple.Foundation       	0x9260f489 __NSFireMainThreadPerform + 352
3   com.apple.CoreFoundation   	0x9085d399 __CFRunLoopPerformPerform + 82
4   com.apple.CoreFoundation   	0x90829fd2 CFRunLoopRunSpecific + 1213
5   com.apple.CoreFoundation   	0x90829b0e CFRunLoopRunInMode + 61
6   com.apple.HIToolbox        	0x92dd8bef RunCurrentEventLoopInMode + 285
7   com.apple.HIToolbox        	0x92dd82fd ReceiveNextEventCommon + 385
8   com.apple.HIToolbox        	0x92dd8154 BlockUntilNextEventMatchingListInMode + 81
9   com.apple.AppKit           	0x9325d465 _DPSNextEvent + 572
10  com.apple.AppKit           	0x9325d056 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 137
11  com.apple.AppKit           	0x93256ddb -[NSApplication run] + 512
12  com.apple.AppKit           	0x9324ad2f NSApplicationMain + 573
13  com.mysql.QueryBrowser     	0x000028c4 main + 30 (main.m:14)
14  com.mysql.QueryBrowser     	0x0000284e _start + 228 (crt.c:272)
15  com.mysql.QueryBrowser     	0x00002769 start + 41

Thread 1:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.apple.Foundation       	0x9264c2f8 -[NSConditionLock lockWhenCondition:] + 39
2   com.apple.AppKit           	0x93334270 -[NSUIHeartBeat _heartBeatThread:] + 377
3   com.apple.Foundation       	0x925f636c forkThreadForFunction + 123
4   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

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

Thread 3:
0   libSystem.B.dylib          	0x90024427 semaphore_wait_signal_trap + 7
1   com.apple.Foundation       	0x926058b6 -[NSConditionLock lock] + 39
2   com.apple.Foundation       	0x9260f2a6 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:modes:] + 828
3   com.apple.Foundation       	0x9260ef4f -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:] + 149
4   com.mysql.MySQLToolsCommon 	0x1002b38e -[MQResultSetView doQuery:] + 612
5   com.apple.AppKit           	0x933fe17b +[NSApplication _startDrawingThread:] + 70
6   com.apple.Foundation       	0x925f636c forkThreadForFunction + 123
7   libSystem.B.dylib          	0x90023d87 _pthread_body + 84

Thread 0 crashed with X86 Thread State (32-bit):
  eax: 0x00000000    ebx: 0x10029dd3 ecx: 0x00000000 edx: 0x00000000
  edi: 0x00577e90    esi: 0x05d09370 ebp: 0xbfffee58 esp: 0xbfffed90
   ss: 0x0000001f    efl: 0x00010246 eip: 0x1002a794  cs: 0x00000017
   ds: 0x0000001f     es: 0x0000001f  fs: 0x00000000  gs: 0x00000037

[26 Nov 2006 1:22] MySQL Verification Team

Updating OS.

[27 Nov 2006 10:43] Sveta Smirnova

Thank you for the report.

Similar problem has been fixed in MySQL Query Browser 1.2.6beta.

Please provide query causes crash, output of SHOW CREATE TABLE and SHOW TABLE STATUS for each table frome the query.

[27 Nov 2006 14:50] Cid Dennis

Table 
CREATE TABLE  `propertydb`.`rights` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `controller` varchar(255) default NULL,
  `action` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Status
| rights                          | InnoDB | 10      | Compact    | 8     | 2048           | 16384       | 0                | 0            | 0         | 9              | 2006-11-27 07:46:55 |                     |            | latin1_swedish_ci |          |                | InnoDB free: 10240 kB |

SQL
SELECT * FROM rights r

But the real issue seems that it is random.  It does not happen on just one table but only after I did the SELECT * from <table> t on a number of diffrent tables.  The it will (what seems randomly) crash.

[28 Nov 2006 19:57] Sveta Smirnova

Thank you for the CREATE statement.

Verified using provided table.

To repeat:

1. Create in command line client database propertydb and table rights as in provided statement.
2. Open MySQL Query Browser, select propertydb database and issue SELECT * FROM rights statement.

[9 Jan 2007 9:35] Sveta Smirnova

I can not repeat it using current 1.2.8 MySQL Query Browser