EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

java.lang.OutOfMemoryError  XML

Forum Index » Tuning and Migration Wizard
Author Message
Eric _t

New member

Joined: 16 Feb 2009 09:45:51
Messages: 2
Offline

When i try to migrate a large table from mysql (data only) using the online migration tool in the EnterpriseDB Migration Studio 8.3 i get the following error:

Exception in thread "Thread-22" java.lang.OutOfMemoryError: java heap space.

I have added the following to migrationstudio/runMigrationStudio.sh

../jre/bin/java -Xmx1024M -Xms1024m -jar edb-migrationstudio.jar&

to bump the heap space, but the problem still persists.

raghavendra_rao

Senior member
[Avatar]

Joined: 2 Sep 2009 06:28:39
Messages: 108
Offline

Hi,

The OutOfMemoryError always occurs when the JVM doesn't allocate sufficient space during the object creation.
Mainly, the migration will have many objects and classes. The heap size can be mentioned like -Xmx1024M -Xms1024m
The no. should be the 1/2 of the RAM in the system.

For example, if the machine has 4 MB RAM, -Xmx2048M -Xms2048m should be set.

Hope this will help in resolving the issue.

regards
Raghavendra
EnterpriseDB

Best Regards
Raghavendra
EnterpriseDB
Blog: http://raghavt.blogspot.com/
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team