GC overhead limit exceeded error

Six Stars

GC overhead limit exceeded error

Hello, 

 

I am new to Talend and was trying to transfer data from my data source server (postgresql) to warehouse server (postgresql). In doing so, I am getting an error, screenshot attached (with designer and error), "GC overhead limit exceeded". Can anyone help me out?

 

Thanks!


Accepted Solutions
Forteen Stars

Re: GC overhead limit exceeded error

Hi,

 

welcome to community

 

you can try one of the next methods:

1. increase memory Xmx in Advanced Settings (Run tab)

Screen Shot 2019-02-08 at 9.53.44 PM.png

 

2. you could test auto-commit (in tPostgreSQLConnection advanced settings) instead of a single transaction - in case if data too big

3. in addition to 2 you could check "use cursor" in advanced settings

-----------

View solution in original post


All Replies
Forteen Stars

Re: GC overhead limit exceeded error

Hi,

 

welcome to community

 

you can try one of the next methods:

1. increase memory Xmx in Advanced Settings (Run tab)

Screen Shot 2019-02-08 at 9.53.44 PM.png

 

2. you could test auto-commit (in tPostgreSQLConnection advanced settings) instead of a single transaction - in case if data too big

3. in addition to 2 you could check "use cursor" in advanced settings

-----------

View solution in original post

Five Stars

Re: GC overhead limit exceeded error

Hi,

Not enough memory, try to increase it : 

RUN->Advanced setting-> Use specific JVM arguments

123.PNG

Thanks

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog