Bug #66555 Frequent crashes when executing queries in Workbench SQL Editor

• Submitted: 27 Aug 2012 17:07
• Modified: 13 Jul 2013 15:06
• Reporter: Jared Miller
• Status: No Feedback
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.44
• OS: MacOS (OS X 10.8.2)
• CPU Architecture: Any
• Tags: crash, sql editor

[27 Aug 2012 17:07] Jared Miller

Description:
Since upgrading to 5.2.42 from 5.2.3x, I have experienced intermittent but daily crashes of MySQL Workbench on OS X, always just after executing a single query using the Cmd-Enter keyboard shortcut. The OS will show the "spinning beachball" for a few seconds before Workbench crashes completely.

Possible related bugs: #66522, #66378.

How to repeat:
Unfortunately the problem is so intermittent and apparently random (yet happens about once or twice a day) I have not been able to find a specific sequence of actions that leads to the crash. However, I frequently have many queries in the editor tab and am jumping back and forth between them, editing, and executing them when it happens. 

FWIW: "Enable code completion" is checked, but "Automatically start code completion" is off (too slow and laggy for me).

Maybe related - I have also noticed since upgrading to 5.2.42 that sometimes when the cursor is in between SQL statements (such as just after the semicolon in one statement) that nothing will happen when typing Cmd-Enter, and I have to do it again to get the query to execute. This may be another symptom of the issue.

[28 Aug 2012 4:03] Alfredo Kojima

Please look for WB related files in ~/Library/Logs/DiagnosticReports/ and attach to this bug report.

[30 Aug 2012 17:37] Jared Miller

I have not experienced any more crashes since un-checking "Enable Code Completion in Editors" in Preferences > SQL Editor. The new code completion feature could be the cause of the crashes.

[13 Sep 2012 15:32] MySQL Verification Team

Yeah the completion feature was reported for Fedora 17 and verified, please try new version 5.2.43. Thanks.

[14 Oct 2012 1:00] Bugs System

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

[19 Oct 2012 23:40] Jared Miller

Recently upgraded to 5.2.44 and still experiencing almost daily crashes with Code Completion turned off. Difficult to replicate but always occurs when executing a single query with Cmd-Enter.  Will attach crash report.

[20 Oct 2012 4:27] Jared Miller

Updated OS field to 10.8.2.

[13 Jun 2013 15:06] MySQL Verification Team

Could you please try version 5.2.47 . Thanks.

[14 Jul 2013 1:00] Bugs System

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