Bug #65728 Workbench Error Code 2008: MySQL Client ran out of memory
Submitted: 25 Jun 2012 13:19 Modified: 31 Jan 2018 8:18
Reporter: Mark Rouse Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S5 (Performance)
Version:5.2.37, 5.2.40,6.0.7 OS:Windows (64-but system with 16GBs of RAM)
Assigned to: CPU Architecture:Any
Tags: out of memory, performance

[25 Jun 2012 13:19] Mark Rouse
Description:
In Workbench SQL Editor, I'm trying to do a select * on an MyISAM table that contains just over 1m records and about 20 fields and I get this error: 

Error Code 2008: MySQL Client ran out of memory

How to repeat:
Load a large table (maybe 1-2m records with perhaps 30-40 fields) into mysql and then have the Workbench trying and "select * from table".  The Workbench doesn't seem to be able to show all records.
[25 Jun 2012 13:53] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.2.40.
[25 Jun 2012 14:00] Mark Rouse
Yes, it still comes up with this error in 5.2.40.
[25 Jun 2012 14:31] Valeriy Kravchuk
Please, send the output of SHOW CREATE TABLE and SHOW TABLE STATUS for the table you select from.
[25 Jun 2012 14:52] Mark Rouse
I've uploaded two files
[25 Jun 2012 14:55] Mark Rouse
My source data gets imported into Field 1 and 2, and then a sql procedure populates the rest.
[25 Jun 2012 14:56] Mark Rouse
It's not just this table - any table that has a large volume of data in it as well.
[9 Jul 2012 22:37] Alfredo Kojima
Any idea how big are each of those records?
[1 Aug 2012 11:37] Mark Rouse
I think in this case, one record is probably 45000-55000 characters in total accross all fields.
[13 Aug 2012 14:18] Mark Rouse
Is there any solution to this problem.  This is a serious peformance issue as now I can't even display a 5M record table.
[13 Aug 2012 14:24] Mark Rouse
I get the same error through the ODBC driver if I try and connect MS Access to the data.
[15 Aug 2012 13:15] MySQL Verification Team
Please provide the output of Help->System Info. Thanks.
[16 Sep 2012 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[16 Oct 2013 8:56] Mark Rouse
Already connected to MySQL server

Already connected to MySQL server

MySQL Workbench Community (GPL) for Windows version 6.0.7  revision 11215

Configuration Directory: C:\Users\921524\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 6.0 CE

Cairo Version: 1.8.8

OS: Microsoft Windows 7 Enterprise Edition Service Pack 1 (build 7601), 32-bit

CPU: 4x Intel(R) Core(TM) i3-2120 CPU @ 3.30GHz, 3.3 GiB RAM

Active video adapter Radmin Mirror Driver V3

Installed video RAM: 0 MB

Current video mode: 1920 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 3.0.0.0

Installed display drivers: NULL

Current user language: English (United Kingdom)
[16 Oct 2013 11:31] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=70632 duplicate of this one.
[16 Oct 2013 12:15] MySQL Verification Team
out of ram

Attachment: out_of_ram.png (image/png, text), 10.01 KiB.

[16 Oct 2013 12:16] MySQL Verification Team
Thank you for the feedback. Verified as described.
[31 Jan 2018 8:18] Mike Lischke
Posted by developer:
 
Obviously the client lib ran out of memory. Not a bug of MySQL Workbench.