Bug #37758 Out of Memory [19016]

• Submitted: 1 Jul 2008 9:07
• Modified: 11 Mar 2009 15:24
• Reporter: Vicens Chamorro
• Status: No Feedback
• Category: MySQL Migration Toolkit
• Severity: S1 (Critical)
• Version: 1.1.12, 1.1.14
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any
• Tags: HSQLDB, out of memory

[1 Jul 2008 9:07] Vicens Chamorro

Description:
I'm having the same problem as the bug 19016 but with the version 1.1.12:

I need to migrate a HSQLDB database to MySQL. 

The HSQLDB database has a size of 170MB.

I'm using a PC with 2GB of RAM.

This is the message log of the tool: 

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class Generic Jdbc
Opening connection ...
Connection jdbc:hsqldb:file:c:/alfresco/alf_data/hsql_data/alfresco
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :Out of Memory
Details:
org.hsqldb.jdbc.Util.sqlException(Unknown Source)
org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
org.hsqldb.jdbcDriver.getConnection(Unknown Source)
org.hsqldb.jdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGeneric.establishConnection(ReverseEngineeringGeneric.java:138)
com.mysql.grt.modules.ReverseEngineeringGeneric.getSchemata(ReverseEngineeringGeneric.java:230)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.mysql.grt.Grt.callModuleFunction(Unknown Source) 

How to repeat:
Migrate a HSQLDB database to MySQL with a similar size (170MB).

Suggested fix:
Increase the JVM Heap Size.

[17 Oct 2008 14:11] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, from GUI Tools 5.0-r13, and inform about the results.

[18 Nov 2008 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".

[2 Dec 2008 6:20] Vicens Chamorro

I've done the test with the version "GUI Tools 5.0-r14 (1.1.14 of migration toolkit)" and I still have the same problem: Out of Memory. Is possible to change the memory that the Migration Tool use?

[11 Feb 2009 15:24] Susanne Ebrecht

Connection jdbc:hsqldb:file:c:/alfresco/alf_data/hsql_data/alfresco
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringGeneric.getSchemata :Out of Memory

This looks more like your database names are too long.

Try shorter names here (maximum is 28 signs).

[12 Mar 2009 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".