Bug #57939 MySQL Workbench 5.2 CE threw a System.OutOfMemoryException

Submitted: 2 Nov 2010 22:55 Modified: 15 Mar 2011 17:15
Reporter: Dann Corbit Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2 ce OS:Windows (64 bit Windows Server 2008)
Assigned to: CPU Architecture:Any

[2 Nov 2010 22:55] Dann Corbit
Description:
Loading Lahman's Baseball database threw a system out of memory exception

How to repeat:
0.  Get this file and unzip it to a temp folder:
http://baseball1.com/statistics/BDB-sql-2009-11-25.sql.zip

1.  Create a database using the workbench as:
CREATE DATABASE mlb;

2.  Use the database:
USE mlb;

3.  From the workbench, do a File/Open on the file expanded in step 0.

Memory exception was thrown.

Suggested fix:
For large files, read and execute the statements one at a time, instead of reading the whole file into memory.
[15 Mar 2011 17:15] Johannes Taxacher
This is actually a duplicate of Bug #55312

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

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