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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.