Java "main" thread Stackoverflow error

[aanchal_s]

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)

[Anonymous]

Hi

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

Regards

Shong

[aanchal_s]

Hi Shong,

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

[aanchal_s]

​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

[aanchal_s]

This is resolved.

Thanks!

[aanchal_s]

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

[gjeremy1617088143]

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