MySQL Bugs: #19016: Out of Memory

Bug #19016	Out of Memory
Submitted:	11 Apr 2006 16:54	Modified:	30 Jun 2006 19:38
Reporter:	Joshua Wilson	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S1 (Critical)
Version:	1.0.25	OS:	Windows (Windows XP R2)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
When trying to migrate a large oracle database with 10354 stored procedures. The Mysql MT will fail with the following error during reverse engineering:

The schema could not be reverse engineered (error: 0).
ReverseEngineeringOracle.reverseEngineer :Java heap space
Details: 

The Details is left blank

How to repeat:
Setup connection for oracle and mysql click next to go to reverse engineering and 
the above message will be received.

Suggested fix:
Allow for the heap size of java to be changed.

I was able to reproduce this bug under WinXP in a laptop w/512MB RAM.  The Oracle version that I used is 10, running in a Linux box with 11000 stored procedures and 300 tables.  None of the tables have any data, and all of the stored procedures are the same and only differ in the name.

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 bug fix. More information about accessing the source trees is available at

    http://www.mysql.com/doc/en/Installing_source_tree.html

I have increased the maximum heap to 386MB. Bigger values prevented the JVM to start properly.