Problem with select query in Crate 3.2.2

This is in regards to the following issue.
It is closed but I am having a similar issue and also it is very intermittent.

Query: select count(city), city from test group by city
Error Stacktrace:
SQLActionException: 500 Internal Server Error 5000 IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.rangeCheck( at java.util.ArrayList.get( at io.crate.expression.InputRow.get( at io.crate.execution.engine.collect.InputCollectExpression.setNextRow( at io.crate.execution.engine.collect.InputCollectExpression.setNextRow( at io.crate.execution.engine.collect.GroupByOptimizedIterator.applyAggregatesGroupedByKey( at io.crate.execution.engine.collect.GroupByOptimizedIterator.lambda$tryOptimizeSingleStringKey$3( at at at$loadNextBatch$1( at java.util.concurrent.CompletableFuture$ at org.elasticsearch.common.util.concurrent.ThreadContext$ at java.util.concurrent.ThreadPoolExecutor.runWorker( at java.util.concurrent.ThreadPoolExecutor$ at

After hours of research, I am still unable to get the exact solution. Any help would be much appreciated.

1 Like

I have had the same issue on crate 3.2.2