MySQL Bugs: #42995: MySQL Query Browser crashes on startup

Bug #42995	MySQL Query Browser crashes on startup
Submitted:	18 Feb 2009 22:10	Modified:	17 Mar 2009 15:04
Reporter:	Jerry Cattell	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS (10.5.6)
Assigned to:		CPU Architecture:	Any

Description:
Everything was working fine for many months, then one day I tried to open MySQL Query Browser, and it crashed.  I have never been able to run it since.  This originally started on OS X 10.5.5, but I am now running 10.5.6 with the same results.  I have tried removing the application and re-installing it, but it has had no effect.

I've gotten by with the command line and other GUIs, but I'd like to understand why this is failing.  Here is what I get from the crash log:

Process:         MySQL Query Browser [5158]
Path:            /Applications/MySQL Tools/MySQL Query Browser.app/Contents/MacOS/MySQL Query Browser
Identifier:      com.mysql.QueryBrowser
Version:         ??? (1.2.12)
Code Type:       X86 (Native)
Parent Process:  launchd [244]

Date/Time:       2009-02-18 16:07:27.800 -0600
OS Version:      Mac OS X 10.5.6 (9G55)
Report Version:  6

Exception Type:  EXC_BAD_ACCESS (SIGBUS)
Exception Codes: KERN_PROTECTION_FAILURE at 0x0000000000000000
Crashed Thread:  0

Thread 0 Crashed:
0   com.mysql.QueryBrowser        	0x00021140 split_iso8601_date + 33 (myx_xml_history.c:606)
1   com.mysql.QueryBrowser        	0x00020fe8 history_entry_compare_asc + 80 (myx_xml_history.c:565)
2   libSystem.B.dylib             	0x932e2e21 qsort + 376
3   com.mysql.QueryBrowser        	0x00020281 myx_history_get_tree + 80 (myx_xml_history.c:206)
4   com.mysql.QueryBrowser        	0x0000de3b -[MQHistory loadFromFile:] + 400 (MQHistory.m:147)
5   com.mysql.QueryBrowser        	0x00008ac7 -[MQueryBrowserController init] + 311 (MQueryBrowserController.m:119)
6   com.apple.AppKit              	0x95b09e73 -[NSCustomObject nibInstantiate] + 315
7   com.apple.AppKit              	0x95aea865 -[NSIBObjectData instantiateObject:] + 259
8   com.apple.AppKit              	0x95ae9f86 -[NSIBObjectData nibInstantiateWithOwner:topLevelObjects:] + 297
9   com.apple.AppKit              	0x95c0df8f old_loadNib + 303
10  com.apple.AppKit              	0x95ae0056 +[NSBundle(NSNibLoading) _loadNibFile:nameTable:withZone:ownerBundle:] + 1056
11  com.apple.AppKit              	0x95adfc2b +[NSBundle(NSNibLoading) loadNibFile:externalNameTable:withZone:] + 171
12  com.apple.AppKit              	0x95adfb69 +[NSBundle(NSNibLoading) loadNibNamed:owner:] + 391
13  com.apple.AppKit              	0x95adf818 NSApplicationMain + 434
14  com.mysql.QueryBrowser        	0x00002ba4 main + 30 (main.m:14)
15  com.mysql.QueryBrowser        	0x00002b2e _start + 228 (crt.c:272)
16  com.mysql.QueryBrowser        	0x00002a49 start + 41

Thread 0 crashed with X86 Thread State (32-bit):
  eax: 0x00000000  ebx: 0x00020247  ecx: 0xffffffff  edx: 0x00000000
  edi: 0x00000000  esi: 0x008244b0  ebp: 0xbffff448  esp: 0xbffff430
   ss: 0x0000001f  efl: 0x00010286  eip: 0x00021140   cs: 0x00000017
   ds: 0x0000001f   es: 0x0000001f   fs: 0x00000000   gs: 0x00000037
  cr2: 0x00000000

How to repeat:
Start MySQL Query Browser

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/

I had this same problem and took a shot based on the traceback.

Removed /Users/myusername/Library/Application Support/MySQL/QueryBrowser/history.xml

and the query browser started working again.

That appears to have fixed my problem.  Many thanks.

Closing issue.