Bug #58268 importing a 21MB sql script
Submitted: 17 Nov 2010 18:48 Modified: 17 Dec 2010 19:34
Reporter: Alex Fairbanks Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.29 OS:Windows (Windows 7)
Assigned to: CPU Architecture:Any
Tags: sql script

[17 Nov 2010 18:48] Alex Fairbanks
I was importing or opening a 21MB file and it made an error that mysql encountered a problem, but then had like 4-5. I closed the response error and waited yet again & slowed down all of mysql for minutes.

MySQL Workbench has encountered a problem
Exception of type 'System.OutOfMemoryException' was thrown.

We are sorry for the inconvenience but an unexpected exception has been raised by one of the MySQL Workbench modules. In order to fix this issue we would kindly ask you to file a bug report. You can do that by pressing the [Report Bug] button below.

Please make sure to include a detailed description of your actions that lead to this problem.

Thanks a lot for taking the time to help us improve MySQL Workbench!

The MySQL Workbench Team

How to repeat:
seemed to load slowly with errors with a 21 MB file, increased the size of parameters to 2048M in ini file: my.ini.

I have stopped the service then restarted it & closed out the file completely.
I opened the program after start again.

Suggested fix:
increase memory on it & take away size limit
[17 Nov 2010 19:34] Valeriy Kravchuk
Please, send the results from Help > System Info menu item.
[18 Dec 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".