Bug #86430 Possible Memory Leak in Workbench 6.3.9 CE export Data to file function

Submitted: 23 May 2017 13:00 Modified: 4 Jun 2020 16:01
Reporter: Manuel Dresselhaus Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:6.3.9, 6.3.10 OS:Windows (10 64 bit)
Assigned to: CPU Architecture:Any
Tags: crash, memory leak

[23 May 2017 13:00] Manuel Dresselhaus
Description:
I had a Result set of 112740 Lines. Four Rows. Every Row is varchar < 50 characters.

Then I uses the Export function. It doesn't matter, which filetype I choosed. I used csv, csv with ; and excel spreadsheet. It always ends in collecting all the ram it could get until Windows crashes...

I have a new system with Intel i7 7th gen and 16gb ram. No other App was in use. 

Although, a bit strange is, that I was able to export even bigger resultsets. But the Ram consumption was high every time. The hole system just did not crash.

There is no error in version 6.2.

I use that version until there is an update. 

Please reselect the severity if using another version is a valid workaround. There is no workaround with the newest version.

How to repeat:
Generate a big resultset (>100000 rows). Use Export, use filetype Excel Spreadsheet. Whatch the ram consumption in task manager or some other tool.
[25 May 2017 0:06] MySQL Verification Team
Thank you for the bug report.
[4 Jun 2017 14:45] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=86579 marked as duplicate of this one.
[5 Jun 2017 15:26] Gregory Aman
I have the same issue. Issue started after updating MySQL Workbench from 6.3.6 to 6.3.9.
[29 Jun 2017 18:22] MySQL Verification Team
https://bugs.mysql.com/bug.php?id=86873 marked as duplicate of this one.
[14 Dec 2017 8:04] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=88665 marked as duplicate of this one.
[8 Aug 2018 18:24] Jared Nishida
Just upgraded my PC to Windows 10 with mySQL version 6.3.10. Memory usage explodes while trying to export.
[6 Mar 2019 20:07] Cesar Vega
I'm having the same issue.  I have to consider an alternative product unfortunately.  Large data exports is all I do.
[6 Mar 2019 20:15] Cesar Vega
Update: reverting to 6.2 corrected the issue.
[4 Jun 2020 16:01] Christine Cole
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 8.0.21 release, and here's the proposed changelog entry from the documentation team:

Memory use on a Windows host was excessive when a large result set was
exported to a file, causing MySQL Workbench to become unresponsive.

Thank you for the bug report.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 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.