Bug #64077 MySQL workbench runs away consumming all available memory
Submitted: 19 Jan 2012 22:36 Modified: 27 Jul 2012 8:13
Reporter: Vitaliy - Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:MySQL Workbench CE 5.2.37 8576 OS:Linux (OpenSuSE 12.1 x86-64)
Assigned to: CPU Architecture:Any

[19 Jan 2012 22:36] Vitaliy -
Description:
After running the same query multiple times by hitting [ctrl]+[Enter] Workbench becomes unresponsive. Consuming 100% CPU and all available memory.

It have to be killed to regain system control.
Console output:
----------------------------------------------------
$ulimit -Sv 1024000; mysql-workbench --log-level=3
Warning! Can't use connect with timeout in paramiko 1.7.7.1 (George)
Ready.

(mysql-workbench-bin:30159): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed

(mysql-workbench-bin:30159): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed

(mysql-workbench-bin:30159): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed

***MEMORY-ERROR***: mysql-workbench-bin[30159]: GSlice: failed to allocate 496 bytes (alignment: 512): Cannot allocate memory
----------------------------------------------------
wc.log:
----------------------------------------------------
15:26:23 [   Info][      WBContext]: WbContext::init
15:26:23 [   Info][      WBContext]: System info:
        MySQL Workbench CE for Linux/Unix version 5.2.36  revision 8542
        Configuration Directory: /home/user/.mysql/workbench
        Data Directory: /usr/share/mysql-workbench
        Cairo Version: 1.10.2
        Rendering Mode: OpenGL is not available on this system, so Native is used for rendering.
        OS: Linux 3.1.0-1.2-desktop
        CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8700  @ 2.53GHz 2527.248 MHz, 3.8 GB RAM
15:26:23 [   Info][    WQE backend]: Found auto-save workspace /home/user/.mysql/workbench/sql_workspaces/localhost-1.autosave
15:26:25 [   Info][     SSH tunnel]: Starting tunnel
----------------------------------------------------

ulimit is used to prevent workbench from using up all memory.

How to repeat:
Type any query that takes few seconds to execute.
Position cursor inside this query.
Press [ctrl]+[enter] multiple times in rapid succession.
[26 Jan 2012 23:26] Vitaliy -
Happens with latest MySQL Workbench CE 5.2.37 8576 as well.
[31 Jan 2012 2:32] Alfredo Kojima
Was able to verify resultsets not being released.
[22 Feb 2012 17:59] Vitaliy -
So when is this going to get fixed? It makes this ... software 99% useless!
[21 Jul 2012 10:14] Robert Cabane
Seems a duplicate of
http://bugs.mysql.com/bug.php?id=56924
[27 Jul 2012 8:13] Philip Olson
Fixed as of Workbench 5.2.41, and here's the changelog entry:

Quickly executing the same query multiple times would cause
MySQL Workbench to use an excessive amount of memory and CPU.
[28 Jul 2012 18:37] Jesper Plauborg
Happens with latest MySQL Workbench 5.2.41 9727 as well.
[13 Feb 2014 17:29] Luis Landero
I'm using Fedora 20, KDE 4.11 and mySQL Workbench 6.0.9.11421 Build 1170
and I still get this error:
(mysql-workbench-bin:7697): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion 'node != NULL' failed

it keeps closing every 2 min. My computer is an i7, 250gb SSD, 16gb DDR3.