Re: need help, java.lang.StackOverflowError when many values in the select in() sytax

[dong wang]

shaofeng, after adding the JAVA_OPTS, the StackOverflowError is GONE, it
can return the correct result but about 10s latency time,  then we optimize
the sql, of course, which  has no that much values in the "IN" condition
for the select statement, previous, we have about 3500 values in the IN
condition