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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.2.3 OS:Windows
Assigned to: 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.