Bug #63674 running large SQL script and it just errors
Submitted: 8 Dec 2011 16:16 Modified: 14 Dec 2011 10:11
Reporter: jj ww Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.36CE OS:Windows
Assigned to: CPU Architecture:Any
Tags: memory bad allocation

[8 Dec 2011 16:16] jj ww 
Description:
Run large SQL script and system runs out of memory eventually.
Stops on INSERT line and reports bad alloc

How to repeat:
Run large SQL script and system runs out of memory eventually.

Suggested fix:
?
[8 Dec 2011 17:12] Valeriy Kravchuk 
Please, send the output of Help > System Info menu item. How large is the script you try to run?
[12 Dec 2011 16:43] jj ww 
The file is 76kb. I have uploaded the file here:
http://www.sidekicker.net/PairsTrading_Dump20111208.sql

MySQL Workbench CE for Windows version 5.2.36  revision 8542

Configuration Directory: C:\Documents and Settings\J\Application Data\MySQL\Workbench

Data Directory: C:\Program Files\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: 3.3.10600 Compatibility Profile Context

OS: Microsoft Windows XP Professional Service Pack 3 (build 2600)

CPU: 3x AMD Athlon(tm) II X3 445 Processor, 3.3 GiB RAM

Active video adapter (0): ATI Radeon HD 4250      

Installed video RAM: 700 MB

Current video mode: 1920 x 1080 x 4294967296 colors

Used bit depth: 32

Driver version: 6.14.10.7171

Installed display drivers: ati2dvag.dll

Active video adapter (2): DisplayLink Graphics Adapter

Installed video RAM: 700 MB

Current video mode: 1600 x 1200 x 4294967296 colors

Used bit depth: 32

Driver version: 5, 4, 26740, 0

Installed display drivers: ati2dvag.dll

Current user language: English (United Kingdom)
[12 Dec 2011 22:58] Rafael Antonio Bedoy Torres 
Verified on Win XP and Win 7
[13 Dec 2011 11:03] Mike Lischke 
76KB is a tiny script and I also don't see any problem with it. When we talk about large scripts then we mean a size of 100MB or larger. WB has a hard time to load larger files than this and the only way to prevent a memory allocation error would be to entirely disallow loading such big scripts. But this will be solved differently.

For this bug report, 76KB is definitly not crashing WB and hence cannot be seen as repeatable test case.
[13 Dec 2011 11:23] jj ww 
Well, what is crashing it then?
When I start the script the meory use is 2Gb and as the script is running, the memory increases and increases until it is maxed out at almost 4Gb, then WB crashes.
[13 Dec 2011 13:50] Mike Lischke 
How did you actually run the script? Did you load it into an editor and then ran it from there?
[13 Dec 2011 14:48] jj ww 
Yes, loaded into the editor and ran it.
[14 Dec 2011 1:28] MySQL Verification Team 
Which are the errors are you getting? Please replace in your create table commands the word TYPE for ENGINE and try again. Thanks.
[14 Dec 2011 10:11] jj ww 
seems to work now.
Must have been a localo memory issue.