Dataiku shows me an error when I make a query on Redshift

[rafael_rosado97]

Hello, everyone.

I want to unload data from Redshift to S3, but when I make the query in dataiku, it shows the following error: java.lang.outofmemoryerror: gc overhead limit exceeded.

When a query with a shorter time span and it runs correctly.

I read here about modification of  jek.xmx. Can I apply it for this case? There is enough memory to run the process.

Thank you very much!

---

Operating system used: Linux

[JordanB · Accepted solution]

Hi @rafael_rosado97,

It should not be necessary to alter the jek.xmx. Please try adding the following properties in the "Advanced JDBC properties" of your Redshift connection. 

enableFetchRingBuffer -> false
enableFetchReadAndProcessBuffers -> false

Thanks!

Jordan 

[rafael_rosado97]

@JordanB Thank you very much!!