Bug #23144 Multi-Table Optimize crashes Administrator
Submitted: 10 Oct 2006 15:57 Modified: 24 Nov 2006 11:34
Reporter: Daniel J. Lyons III Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.5rc OS:MacOS (Mac OS X)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any
Tags: check, Optimize, Repair

[10 Oct 2006 15:57] Daniel J. Lyons III
Description:
This is a bug that has been around (at least in the Mac version) for a while.  In the Catalog View, the Administrator allows you to Shift-Click and select multiple tables.  The Table Actions that are available do not all work consistently with multiple tables selected.

If you select more than one table then select Table Action of Optimize, Repair or Check Administrator crashes.
For Edit Table, only the lowest table on the list is opened in an Editor window.
Drop Table works as expected and all selected tables are dropped from the database.

Apple Crash Details follow (This is from selecting Optimize):
Date/Time:      2006-10-10 11:37:44.839 -0400
OS Version:     10.4.8 (Build 8L127)
Report Version: 4

Command: MySQL Administrator
Path:    /Applications/MySQL Tools/MySQL Administrator.app/Contents/MacOS/MySQL Administrator
Parent:  WindowServer [742]

Version: ??? (1.2.4rc)

PID:    20247
Thread: 0

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

Thread 0 Crashed:
0   com.mysql.Administrator    	0x00043444 -[MATableMaintenanceController operationFinished:result:] + 1680
1   com.mysql.MySQLToolsCommon 	0x1000f17c -[Request finish] + 124
2   com.mysql.MySQLToolsCommon 	0x1000f824 -[MMySQLDispatcher(Private) handleFinished:] + 116
3   com.apple.Foundation       	0x9296aa00 __NSFireMainThreadPerform + 276
4   com.apple.CoreFoundation   	0x9080da78 __CFRunLoopPerformPerform + 104
5   com.apple.CoreFoundation   	0x907dd4cc __CFRunLoopDoSources0 + 384
6   com.apple.CoreFoundation   	0x907dc9fc __CFRunLoopRun + 452
7   com.apple.CoreFoundation   	0x907dc47c CFRunLoopRunSpecific + 268
8   com.apple.HIToolbox        	0x93203740 RunCurrentEventLoopInMode + 264
9   com.apple.HIToolbox        	0x93202dd4 ReceiveNextEventCommon + 380
10  com.apple.HIToolbox        	0x93202c40 BlockUntilNextEventMatchingListInMode + 96
11  com.apple.AppKit           	0x93706ae4 _DPSNextEvent + 384
12  com.apple.AppKit           	0x937067a8 -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 116
13  com.apple.AppKit           	0x938b18d8 -[NSApplication _realDoModalLoop:peek:] + 260
14  com.apple.AppKit           	0x938a82b0 -[NSApplication runModalForWindow:] + 176
15  com.mysql.Administrator    	0x00043b04 -[MATableMaintenanceController runWithTables:dispatcher:operation:] + 1016
16  com.mysql.Administrator    	0x000229bc -[MACatalogs openTableMaintenance:] + 724
17  com.mysql.Administrator    	0x00022b44 -[MACatalogs optimizeTable:] + 92
18  com.apple.AppKit           	0x937a7c4c -[NSApplication sendAction:to:from:] + 108
19  com.apple.AppKit           	0x938024b8 -[NSMenu performActionForItemAtIndex:] + 392
20  com.apple.AppKit           	0x9380223c -[NSCarbonMenuImpl performActionWithHighlightingForItemAtIndex:] + 104
21  com.apple.AppKit           	0x9382ad6c _NSPopUpCarbonMenu2 + 2480
22  com.apple.AppKit           	0x9382a3ac _NSPopUpCarbonMenu1 + 44
23  com.apple.AppKit           	0x9382a368 -[NSCarbonMenuImpl popUpMenu:atLocation:width:forView:withSelectedItem:withFont:] + 224
24  com.apple.AppKit           	0x9382a008 -[NSPopUpButtonCell trackMouse:inRect:ofView:untilMouseUp:] + 1184
25  com.apple.AppKit           	0x937c1094 -[NSControl mouseDown:] + 536
26  com.apple.AppKit           	0x93762890 -[NSWindow sendEvent:] + 4616
27  com.apple.AppKit           	0x9370b8d4 -[NSApplication sendEvent:] + 4172
28  com.apple.AppKit           	0x93702d10 -[NSApplication run] + 508
29  com.apple.AppKit           	0x937f387c NSApplicationMain + 452
30  com.mysql.Administrator    	0x000031f8 main + 64
31  com.mysql.Administrator    	0x00002d74 _start + 340 (crt.c:272)
32  com.mysql.Administrator    	0x00002c1c start + 60

Thread 1:
0   libSystem.B.dylib          	0x9002bbc8 semaphore_wait_signal_trap + 8
1   libSystem.B.dylib          	0x900306ac pthread_cond_wait + 480
2   com.apple.Foundation       	0x92964300 -[NSConditionLock lockWhenCondition:] + 68
3   com.apple.AppKit           	0x937a3708 -[NSUIHeartBeat _heartBeatThread:] + 324
4   com.apple.Foundation       	0x9295d194 forkThreadForFunction + 108
5   libSystem.B.dylib          	0x9002b508 _pthread_body + 96

Thread 2:
0   libSystem.B.dylib          	0x9002bbc8 semaphore_wait_signal_trap + 8
1   libSystem.B.dylib          	0x900306ac pthread_cond_wait + 480
2   com.apple.Foundation       	0x929606a8 -[NSConditionLock lock] + 52
3   com.apple.Foundation       	0x9296a844 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:modes:] + 780
4   com.apple.Foundation       	0x9296a518 -[NSObject(NSMainThreadPerformAdditions) performSelectorOnMainThread:withObject:waitUntilDone:] + 120
5   com.mysql.MySQLToolsCommon 	0x1000f6f0 -[MMySQLDispatcher(Private) executeRequest:] + 188
6   com.mysql.MySQLToolsCommon 	0x1000fba4 processRequests + 100
7   libSystem.B.dylib          	0x9002b508 _pthread_body + 96

Thread 0 crashed with PPC Thread State 64:
…I had to delete the rest of the report to save space - I can provide if needed…

How to repeat:
Click on one table
Shift-Click on at least one additional table
In Table Actions select Optimize, Repair or Check
The process window will come up, sometimes for several seconds, then the application will crash
[21 Nov 2006 14:00] Valeriy Kravchuk
Thank you for a problem report, and sorry for a delay with it. Please, try to repeat with a newer version, 1.2.5 rc, and inform about the results.
[21 Nov 2006 14:27] Daniel J. Lyons III
I have just verified this same bug in versino 1.2.5rc of the Administrator.  I am using the Universal Binary on an Intel based Mac
[23 Nov 2006 20:43] Sveta Smirnova
Thank you for the report.

Verified as described using last 1.2.5rc MySQL Administrator.
[24 Nov 2006 11:34] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html
[30 Nov 2006 9:40] Sveta Smirnova
There is similar Bug #24627
[1 Dec 2006 19:03] John Mertic
Still exists in 1.2.6rc