Bug #7154 Large script causes out of memory error

• Submitted: 10 Dec 2004 5:31
• Modified: 15 Feb 2005 10:37
• Reporter: Johann Nell
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.1.2/1.1.5
• OS: Windows (Win XP SP2)
• Assigned to: Mike Lischke
• CPU Architecture: Any

[10 Dec 2004 5:31] Johann Nell

Description:
Running a large script, like the NOLA 1.2 Fill data script causes an Out Of Memory error.

How to repeat:
Run the NOLA Fill Data script. Can supply you with the script if required.

[11 Dec 2004 7:59] Johann Nell

Fill Data Script

Attachment: filldata.sql (application/octet-stream, text), 64.21 KiB.

[11 Dec 2004 7:59] Johann Nell

Create Database Script

Attachment: database.sql (application/octet-stream, text), 87.54 KiB.

[13 Dec 2004 20:13] MySQL Verification Team

Yes please provide us the script file:

ftp://support.mysql.com/pub/mysql/upload

zipped into a file with a name identifying this bug report
and let know us here.

Thanks in advance.

[7 Jan 2005 17:34] Alexandru Mihai Bîrsan

I am having the same problem with a large script. Also, my script has some errors here-there and this is why I used Query Browser instead of the mysql console import. After running off a little more than 50% script execution it crashes, and I can see a little of the "Out of Memory" message behind the progress bar. While execution, the application becomes unresponsive and the computer runs very slow. After the execution crash the application is still running slow. I also noticed loading and scrolling the script is pretty slow too (before and after).

I have the script file, only I could not connect to the provided ftp server. (I tried anonymous connection.) Therefore I uploaded the script to my website and will be hosting it for a while now. The URL is:

http://liis.ro/~spider/live/mySQL/7154-large-script-bug.zip

Hope to see this fixed, as Query Browser is the best tool of it's kind, so far seen.

[7 Jan 2005 19:23] MySQL Verification Team

Thank you for the script I was able to repeat the behavior reported
after to edit 3 error lines, QB around 75% of script reported Out
of memory error.

[15 Feb 2005 10:37] Mike Lischke

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html