Bug #62979 When you alter routine the system crashes

• Submitted: 27 Oct 2011 19:56
• Modified: 31 Jan 2012 4:40
• Reporter: Alexander Ratz
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.35
• OS: MacOS (10.7.2)
• CPU Architecture: Any

[27 Oct 2011 19:56] Alexander Ratz

Description:
Your Workbench / GUI crashes VERY often, if not TOO often, under ALL OSX's.. 10.4,10.5,10.6,10.7 as we have them all in our office.

It makes the job a lot of fun...

How to repeat:
Right click on a routein -> Alter routine -> Apply [Yes, as simple as that]

Suggested fix:
test your system

[28 Oct 2011 3:42] Valeriy Kravchuk

Crash info from Mac OS X 10.5.6

Attachment: bug62979.txt (text/plain), 41.58 KiB.

[28 Oct 2011 3:44] Valeriy Kravchuk

Thank you for the bug report. Indeed, it was easy to verify on Mac OS X 10.5.x:

1. Alter routine > change something > Apply
2. Alter routine (for the same routine) > change back > Apply
3. Revert (nothing happens) > Apply > crash

Crash info is attached.

[28 Oct 2011 15:00] Alexander Ratz

Hi Valeriy,

Thanks for the update.

For me it actually happens when you initially click on the apply button.

[28 Oct 2011 15:08] Alexander Ratz

I have found several other issues:

1. When you do the following, it won't recognize the query and only drop it

DROP PROCEDURE [P_NAME]

DELIMITER $$

CREATE PROCEDURE [P_NAME]
BEGIN
...
END$$

[28 Oct 2011 15:09] Alexander Ratz

Also, before it was possible to click on Command+shift+arrow down and it would select everything that is below the selection.

No longer works actually

[3 Nov 2011 14:47] Alfredo Kojima

Alexander, can you attach the crash logs for WB in ~/Library/Logs/DiagnosticReports ?

[27 Jan 2012 16:00] Alfredo Kojima

The 2nd issue being reported is not a bug. You're probably using the "Execute current statement" command instead of Execute All.

[31 Jan 2012 4:40] Philip Olson

Fixed as of 5.2.36:

Altering and saving a routine twice, reverting, and then
clicking "Apply" would crash Workbench.