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.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.056 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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.