Bug #74593 mysql workbench editor crashes, causes the full sytem to freeze

• Submitted: 27 Oct 2014 16:53
• Modified: 4 Feb 2015 2:05
• Reporter: sushil s
• Status: Closed
• Category: MySQL Workbench
• Severity: S2 (Serious)
• Version: 6.2.3
• OS: Windows
• CPU Architecture: Any

[27 Oct 2014 16:53] sushil s

Description:
I had copied and pasted query from a word document which had control char SOH (start heading). As soon as the chars were copied to the editor -- the workbench became non-reponsive, so did the whole system. Tried that in a different windows 7 system, same thing. I have to hard re-start the system once this happens.

The worst part is - workbench probably cached it somewhere that every time i launch workbench -- it crashes and causes the whole system to hang. Deleted all the temp files -- still no luck. Uninstalled/reinstaleld workbench -- still causes the hang when I open. Must be something cached somewhere that I don't know.

How to repeat:
I had copied and pasted query from a word document which had control char SOH (start heading). As soon as the chars were copied to the editor -- the workbench became non-reponsive, so did the whole system. Tried that in a different windows 7 system, same thing. I have to hard re-start the system once this happens.

Suggested fix:
not cause hang to the whole system, if just workbench -- i could deal with it.

[27 Oct 2014 17:17] MySQL Verification Team

Thank you for the bug report. Please provide the file from you pasted the query. Thanks.

[27 Oct 2014 19:37] sushil s

Also, I figured out the workaround so I could use workbench again:
I had to delete all the temp files from the appData, then I had to remove the saved connection before connecting. Then Uninstalled the sqlworkbench, reinstalled -- now I have my computer and wb working .

[27 Oct 2014 22:10] MySQL Verification Team

Thank you for the feedback. I couldn't repeat. According your last comment the issue can't happen anymore?. Thanks.

[27 Oct 2014 22:26] MySQL Verification Team

I was able to repeat on MaCBook Pro OS X.

[28 Oct 2014 2:55] sushil s

The issue still happens, but I have learned hot to recover from it. It looked like you were able to reproduce as well?

[3 Feb 2015 19:31] Rafael Antonio Bedoy Torres

Posted by developer:
 
Workbench is not crashing anymore, checked using 6.2.5.0 build 221

[4 Feb 2015 2:05] Philip Olson

Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.2.5 release, and here's the changelog entry:

Clicking "Revert" after adding a trigger under the "Alter Table"'s
"Triggers" tab would fail to remove the trigger name from the trigger
list, although it did delete the trigger.

Thank you for the bug report.