Bug #68337 MySQL Crash on Multiple Table Delete (OSX)
Submitted: 11 Feb 2013 13:44 Modified: 10 Jun 2013 0:49
Reporter: David Garratt Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.46 OS:MacOS (Mountain Lion)
Assigned to: CPU Architecture:Any
Tags: regression

[11 Feb 2013 13:44] David Garratt
Description:
Selecting multiple objects from SQL Editor tree and dropping them results in Workbench crashing (after deleting them).

How to repeat:
Select mutiple tables 10-15 etc, right click and select drop. Confirm and wait for drop to complete.

Suggested fix:
Stop crashing
[11 Feb 2013 15:36] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on MacBook Pro Mountain Lion. Please describe the tables and their size (# of rows). Thanks.
[11 Feb 2013 15:53] David Garratt
Crash Dump Log File

Attachment: dump.txt (text/plain), 88.04 KiB.

[11 Feb 2013 15:55] David Garratt
Database Export

Attachment: test.sql (application/octet-stream, text), 211.22 KiB.

[11 Feb 2013 15:56] David Garratt
I have attached 2 files.

A copy of the memory dump provided by osx.
An export of my test database before I deleted the tables and it crashed mysql.

I selected all 40 tables and dropped them all.

Dave
[11 Feb 2013 16:31] MySQL Verification Team
Thank you for the feedback. I couldn't repeat your sample using test.sql on the below OS:

MySQL Workbench CE for Mac OS X version 5.2.45  revision 10251
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: Darwin 12.2.1
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz, 4.0 GB RAM

Just curious your 16GB RAM are original from computer manufacturer?. Thanks.
[11 Feb 2013 16:51] MySQL Verification Team
Sorry I have not noticed I was testing 5.2.45 version after the upgrade for 5.2.46 I was able to repeat:

Process:         MySQLWorkbench [5502]
Path:            /Applications/MySQLWorkbench.app/Contents/MacOS/MySQLWorkbench
Identifier:      com.oracle.mysql.workbench
Version:         5.2.46 (1)
Code Type:       X86 (Native)
Parent Process:  launchd [410]
User ID:         501

Date/Time:       2013-02-11 14:47:34.101 -0200
OS Version:      Mac OS X 10.8.2 (12C3012)
Report Version:  10
Sleep/Wake UUID: 7BF915F5-D4E9-4C80-B2B6-E235C0227A2F

Interval Since Last Report:          646776 sec
Crashes Since Last Report:           4
Per-App Interval Since Last Report:  67 sec
Per-App Crashes Since Last Report:   1
Anonymous UUID:                      2A5B59E8-F98A-1451-49F8-DEC433009E11

Crashed Thread:  0  Dispatch queue: com.apple.main-thread

Exception Type:  EXC_CRASH (SIGABRT)
Exception Codes: 0x0000000000000000, 0x0000000000000000

Application Specific Information:
Assertion failed: (px != 0), function operator*, file /Volumes/DataHD/mysql-workbench-gpl-5.2.46-src/../mysql-mac-res/include/boost/smart_ptr/shared_ptr.hpp, line 412.
 

Thread 0 Crashed:: Dispatch queue: com.apple.main-thread
0   libsystem_kernel.dylib        	0x9502ba6a __pthread_kill + 10
1   libsystem_c.dylib             	0x96a04acf pthread_kill + 101
2   libsystem_c.dylib             	0x96a3b4f8 abort + 168
3   libsystem_c.dylib             	0x96a49d37 __assert_rtn + 326
4   libmforms.dylib               	0x01ba8dc6 boost::signals2::signal4<void, bool, int, int, int, boost::signals2::optional_last_value<void>, int, std::less<int>, boost::function<void (bool, int, int, int)>, boost::function<void (boost::signals2::connection const&, bool, int, int, int)>, boost::signals2::mutex>::operator()(bool, int, int, int) + 112
5   libmforms.dylib               	0x01ba6e1b mforms::CodeEditor::on_notify(Scintilla::SCNotification*) + 823
6   libmforms.dylib               	0x01bbb927 -[MFCodeEditor notification:] + 27
7   com.sun.Scintilla             	0x002054ef notification(long, unsigned int, unsigned long, unsigned long) + 140
8   com.sun.Scintilla             	0x00202c9f Scintilla::ScintillaCocoa::NotifyParent(Scintilla::SCNotification) + 71
9   com.sun.Scintilla             	0x0028ff51 Scintilla::Editor::NotifyDwelling(Scintilla::Point, bool) + 275
10  com.sun.Scintilla             	0x00298cfb Scintilla::Editor::Tick() + 291
11  com.sun.Scintilla             	0x001ff5d1 -[TimerTarget timerFired:] + 19
12  com.apple.Foundation          	0x922df7d4 __NSFireTimer + 117
13  com.apple.CoreFoundation      	0x927619b6 __CFRUNLOOP_IS_CALLING_OUT_TO_A_TIMER_CALLBACK_FUNCTION__ + 22
14  com.apple.CoreFoundation      	0x92761355 __CFRunLoopDoTimer + 709
15  com.apple.CoreFoundation      	0x92746162 __CFRunLoopRun + 1730
16  com.apple.CoreFoundation      	0x9274563a CFRunLoopRunSpecific + 378
17  com.apple.CoreFoundation      	0x927454ab CFRunLoopRunInMode + 123
18  com.apple.AppKit              	0x98a86389 -[NSHTMLReader _loadUsingWebKit] + 2401
19  com.apple.AppKit              	0x98a85928 -[NSHTMLReader _load] + 280
20  com.apple.AppKit              	0x98a857d5 -[NSHTMLReader attributedString] + 35
<cut>
[10 Jun 2013 0:49] Philip Olson
Fixed as of the upcoming Workbench 6.0.2, and here's the changelog entry:

Selecting and then dropping multiple objects from the SQL editor would
cause MySQL Workbench to delete the objects, and then crash.

Thank you for the bug report.