java.lang.StackOverflowError on select count from a large select with a lot of left joins in redshift

Answered

I receive a java.lang.StackOverflowError when I try to execute a select count from a large select with a lot of left joins in redshift. I've already tryed to add the -Xss4m into the .vmoptions file and the -Dcom.btr.proxy.pac.overrideLocalIP=127.0.0.1 too, but It doesn't work. Any solution would be appreciated.

3
10 comments

Found the solution!, I am currently on the latest driver for redshift ( ver. 1.2.16.1027 ), that driver version is buggy, so I reverted to the ver. 1.2.16.1009 and deleted the -Xss4m and the Dcom.btr.proxy.pac.overrideLocalIP=127.0.0.1 from the .vmoptions; reestarted datagrip and everything is working Ok. Hope this solution helps anybody else.

3

I had the same issue with the most recent driver. 

0

@Bmccul00, @Rob Mitchell

Could you email me vasily.chernov@jetbrains.com full zipped IDE log for further investigation?

0
Avatar
Permanently deleted user

I have the same issue as well with the driver 1.2.16.1027. What I was trying to do instead was a long case statement.

0

Came across the same issue with a longer multi-join statement. Works individually but breaks once the last join is added.

1

Same issue as Thomas, multi-join statements throw the error. It's jetbrains specific since all other SQL GUIs I've tried (postico, dbeaver) don't have an issue.

0

Julio Venegas89, @Thomas, @..., @Bmccul00, @Rob Mitchell,

I filed an issue https://youtrack.jetbrains.com/issue/DBE-9815.
Could you attach your IDE logs to the issue?

0

I had the same issue with the new driver for Redshift. 

as 27 of April the driver 1.2.41.1065 presented this error.

I jumped back to the 1,2,16,1027 and the error disapeared. 

0

I have the same problem with BigQuery : (

0

@Dawid Nawrot,

BigQuery? Cool, but it should be in an another thread.

Could you file an issue https://youtrack.jetbrains.com/issues/DBE and attach IDE logs and specify your jdbc driver version?

0

Please sign in to leave a comment.