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.
Please sign in to leave a comment.
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.
I had the same issue with the most recent driver.
@Bmccul00, @Rob Mitchell
Could you email me vasily.chernov@jetbrains.com full zipped IDE log for further investigation?
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.
Came across the same issue with a longer multi-join statement. Works individually but breaks once the last join is added.
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.
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?
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.
I have the same problem with BigQuery : (
@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?