Bug #73348 Hitting apply twice quickly after editing the results in a query kills workbench
Submitted: 21 Jul 2014 17:28 Modified: 27 Aug 2014 18:47
Reporter: Paul Coene Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.0.8.11354, 6.1.7 OS:Linux (Ubuntu)
Assigned to: CPU Architecture:Any
Tags: crash

[21 Jul 2014 17:28] Paul Coene 
Description:
Workbench hangs/crashed every time I hit apply twice quickly (by mistake, but it happens, and is very frustrating.

How to repeat:
Perform some sort of query (select * from table).  Edit the result set. Click apply twice quickly.

Suggested fix:
Debounce the apply button or disable it after one click until operation complete.
[22 Jul 2014 4:51] MySQL Verification Team 
Hello Paul,

Thank you for your report.
Verified as described on OL6 with WB 6.1.7.

Thanks,
Umesh
[22 Jul 2014 4:51] MySQL Verification Team 
This is not repeatable on Wind7 with WB6.1.7
[22 Jul 2014 4:52] MySQL Verification Team 
Crash details

Attachment: 73348.txt (text/plain), 65.06 KiB.
[22 Jul 2014 22:45] Alfredo Kojima 
Amazingly, this is a Ubuntu bug: https://bugs.launchpad.net/ubuntu/+source/overlay-scrollbar/+bug/903302

You can workaround by setting running
 export LIBOVERLAY_SCROLLBAR=0
from the shell you start WB from the cmdline.

There's not much we can do in WB other than forcing that environment variable to be set.
[22 Jul 2014 22:54] Paul Coene 
Any idea of a workaround when launching from the ubuntu launcher? Set the variable in what. every user's .profile or something?
[22 Jul 2014 22:58] Alfredo Kojima 
Edit /usr/bin/mysql-workbench and add that line somewhere at the top. You'll see there's already another workaround for a similar Ubuntu bug, you can put it below it.
[22 Jul 2014 23:04] Paul Coene 
Added it: snippet below.  Exited, restarted workbench and tested.  No change.  Still crashed on double apply.

# Uncomment the following line if you're having trouble with gnome-keyring lockups.
# This will cause passwords to be stored only temporarily for the session.
WB_NO_GNOME_KEYRING=1
LIBOVERLAY_SCROLLBAR=0
[22 Jul 2014 23:20] Alfredo Kojima 
You're missing the export:

export LIBOVERLAY_SCROLLBAR=0
[23 Jul 2014 1:02] Paul Coene 
Yep, that worked.  Thanks for the work-around.  Will those changes be lost every time I upgrade versions?
[23 Jul 2014 14:12] Alfredo Kojima 
The workaround will come "pre-installed" in future versions.
[27 Aug 2014 18:47] Philip Olson 
Fixed as of the upcoming MySQL Workbench 6.2.2 release, and here's the changelog entry:

Quickly clicking "Apply" twice after editing a result set entry would
cause a crash.

Thank you for the bug report.