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

-----------

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

-----------
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 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog