topic Re: Java "main" thread Stackoverflow error in Talend Studio

Java "main" thread Stackoverflow error

aanchal_s — Fri, 15 Nov 2024 23:12:22 GMT

Hi everyone,

Can someone please help in resolving my java error in talend job. I created a job having components - tdbConnection -> tDBinput -> tLogRow or tDBOutput (tried with both)

Tdbinput has a huge query(redshift is source) , every time I tried to execute the job m getting below error:

Exception in thread "main" java.lang.StackOverflowError

at java.util.regex.Pattern$Bound.match(Pattern.java:5330)

at java.util.regex.Pattern$GroupHead.match(Pattern.java:4660)

at java.util.regex.Pattern$NotBehind.match(Pattern.java:5204)

at java.util.regex.Pattern$Branch.match(Pattern.java:4606)

at java.util.regex.Pattern$GroupHead.match(Pattern.java:4660)

at java.util.regex.Pattern$Loop.match(Pattern.java:4787)

at java.util.regex.Pattern$GroupTail.match(Pattern.java:4719)

Re: Java "main" thread Stackoverflow error

Anonymous — Wed, 16 Feb 2022 09:39:55 GMT

Do you have the same error with a simple query? Can you please upload the full track error?

Regards

Shong

Re: Java "main" thread Stackoverflow error

aanchal_s — Thu, 17 Feb 2022 02:53:05 GMT

Hi Shong,

No, I didn't get this error with simple query. Please find attached latest log on this error.

Re: Java "main" thread Stackoverflow error

aanchal_s — Mon, 21 Feb 2022 06:24:06 GMT

Hi @Shicong Hong The query consist of many temp tables and so the joins between these tables. Can this be the reason?

Any suggestion to resolve this issue is appreciated .

Regards

Aanchal

Re: Java "main" thread Stackoverflow error

aanchal_s — Tue, 22 Feb 2022 22:49:34 GMT

This is resolved.

Thanks!

Re: Java "main" thread Stackoverflow error

aanchal_s — Thu, 03 Mar 2022 00:59:48 GMT

This error is back again and seems like Talend cannot handle huge data in temp tables to work on it

Re: Java "main" thread Stackoverflow error

gjeremy1617088143 — Thu, 03 Mar 2022 10:43:27 GMT

HI, does this query work fine in the source DB ?