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