Bug #55438 Loaded very large script, got "System.OutOfMemoryException"
Submitted: 21 Jul 2010 12:12 Modified: 28 Jul 2010 12:49
Reporter: Jesse Castleberry Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.25 OS:Windows (7 (64-bit))
Assigned to: CPU Architecture:Any

[21 Jul 2010 12:12] Jesse Castleberry 
Description:
When loading a large script (a backup script, actually), of approximately 109MB, got an error, "Exception of type 'System.OutOfMemoryException' was thrown.

How to repeat:
Load a large script

Suggested fix:
Not sure, obviously we don't want the error, but how to load a large script when there isn't enough memory is not something I know how to solve.
[21 Jul 2010 12:22] MySQL Verification Team 
Could you please provide the version and output of Help->System Info. Thanks in advance.
[21 Jul 2010 12:36] Jesse Castleberry 
Sorry, would have done that earlier, but the error box that popped up was modal and I could not get to the version, but here it the info:

MySQL Workbench CE for Windows version 5.2.25

Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 2.1.8874

OS: Microsoft Windows 7  (build 7600), 64-bit

CPU: 2x Intel(R) Core(TM)2 Duo CPU     P8700  @ 2.53GHz, 3.9 GiB RAM

Video adapter info:

Adapter type: Mobile Intel(R) 4 Series Express Chipset Family

Chip Type: Mobile Intel(R) 4 Series Express Chipset Family

BIOS String: Intel Video BIOS

Video Memory: 1814544 KB
[22 Jul 2010 5:21] Susanne Ebrecht 
Are you able to load the script with another graphical editor?

Like with notepad, ultraedit, word or something else?
[22 Jul 2010 12:24] Jesse Castleberry 
Yes, I can load the script in Windows Notepad.
[25 Jul 2010 21:19] Roel Van de Paar 
Jesse, please provide the script you were using so that we can test and see if we can reproduce the error. If you like, you can submit it as a private comment to this bug so that only Oracle staff will be able to view it.
[25 Jul 2010 22:35] Jesse Castleberry 
Unfortunately, "the script" is actually a backup .sql file, and contains private data from one of our customers that I cannot release.  I believe if you backup a large database, then try to run it as a script that should probably suffice.  "The script" is approximately 109MB in size.
[25 Jul 2010 22:36] Jesse Castleberry 
BTW, that same script, when I tried to run it through the Server Administration gave an error as well.
[28 Jul 2010 12:49] MySQL Verification Team 
Duplicate of bug: http://bugs.mysql.com/bug.php?id=55312.