| 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: | |
| 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 | |
[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.
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.