[CI] JdbcCsvSpecIT test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #3749 / debian-11_platform-support-unix
• elasticsearch-periodic #3776 / concurrent-search-tests
• elasticsearch-periodic-platform-support #3749 / ubuntu-1804_platform-support-unix
• elasticsearch-pull-request #28511 / part-4

Reproduction Line:

./gradlew ":x-pack:plugin:sql:qa:server:multi-cluster-with-security:javaRestTest" --tests "org.elasticsearch.xpack.sql.qa.multi_cluster_with_security.JdbcCsvSpecIT" -Dtests.method="test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1}" -Dtests.seed=E3B0270ED143D8C2 -Dtests.locale=es-CL -Dtests.timezone=AET -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.sql.SQLException: Server encountered an error [Negative longs unsupported, use writeLong or writeZLong for negative numbers [-441849600]]. [java.lang.IllegalStateException: Negative longs unsupported, use writeLong or writeZLong for negative numbers [-441849600]
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeVLong(StreamOutput.java:271)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$22(StreamOutput.java:771)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at org.elasticsearch.xpack.sql.session.ListCursor.writeTo(ListCursor.java:45)
	at [email protected]/org.elasticsearch.common.io.stream.StreamOutput.writeNamedWriteable(StreamOutput.java:1039)
	at org.elasticsearch.xpack.sql.session.Cursors.encodeToString(Cursors.java:82)
	at org.elasticsearch.xpack.sql.session.Cursors.encodeToString(Cursors.java:73)
	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.createResponse(TransportSqlQueryAction.java:226)
	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.createResponseWithSchema(TransportSqlQueryAction.java:207)
	at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.lambda$operation$0(TransportSqlQueryAction.java:171)
	at [email protected]/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
	at [email protected]/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
	at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.sendResponse(Querier.java:353)
	at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.onResponse(Querier.java:330)
	at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.onResponse(Querier.java:272)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at org.elasticsearch.xpack.sql.execution.search.Querier.lambda$closePointInTime$5(Querier.java:194)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
	at [email protected]/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at [email protected]/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:202)
	at [email protected]/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:196)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$RunBeforeActionListener.onResponse(ActionListenerImplementations.java:335)
	at [email protected]/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at [email protected]/org.elasticsearch.action.support.ContextPreservingActionListener.onResponse(ContextPreservingActionListener.java:32)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at [email protected]/org.elasticsearch.action.search.ClearScrollController.lambda$closeContexts$7(ClearScrollController.java:167)
	at [email protected]/org.elasticsearch.core.AbstractRefCounted$1.closeInternal(AbstractRefCounted.java:118)
	at [email protected]/org.elasticsearch.core.AbstractRefCounted.decRef(AbstractRefCounted.java:70)
	at [email protected]/org.elasticsearch.action.support.RefCountingRunnable.close(RefCountingRunnable.java:112)
	at [email protected]/org.elasticsearch.core.Releasables$4.close(Releasables.java:159)
	at [email protected]/org.elasticsearch.core.Releasables.close(Releasables.java:34)
	at [email protected]/org.elasticsearch.core.Releasables.closeExpectNoException(Releasables.java:56)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$2.run(ActionListenerImplementations.java:50)
	at [email protected]/org.elasticsearch.action.ActionListener$1.onResponse(ActionListener.java:216)
	at [email protected]/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at [email protected]/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at [email protected]/org.elasticsearch.action.ActionListenerResponseHandler.handleResponse(ActionListenerResponseHandler.java:48)
	at [email protected]/org.elasticsearch.transport.TransportService$ContextRestoreResponseHandler.handleResponse(TransportService.java:1498)
	at [email protected]/org.elasticsearch.transport.InboundHandler.doHandleResponse(InboundHandler.java:432)
	at [email protected]/org.elasticsearch.transport.InboundHandler.handleResponse(InboundHandler.java:381)
	at [email protected]/org.elasticsearch.transport.InboundHandler.executeResponseHandler(InboundHandler.java:148)
	at [email protected]/org.elasticsearch.transport.InboundHandler.messageReceived(InboundHandler.java:123)
	at [email protected]/org.elasticsearch.transport.InboundHandler.inboundMessage(InboundHandler.java:97)
	at [email protected]/org.elasticsearch.transport.TcpTransport.inboundMessage(TcpTransport.java:821)
	at [email protected]/org.elasticsearch.transport.InboundPipeline.forwardFragments(InboundPipeline.java:124)
	at [email protected]/org.elasticsearch.transport.InboundPipeline.doHandleBytes(InboundPipeline.java:96)
	at [email protected]/org.elasticsearch.transport.InboundPipeline.handleBytes(InboundPipeline.java:61)
	at [email protected]/org.elasticsearch.transport.netty4.Netty4MessageInboundHandler.channelRead(Netty4MessageInboundHandler.java:57)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at [email protected]/io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at [email protected]/io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
	at [email protected]/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at [email protected]/io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at [email protected]/io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at [email protected]/io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
	at [email protected]/io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:689)
	at [email protected]/io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:652)
	at [email protected]/io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
	at [email protected]/io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at [email protected]/io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
	at java.base/java.lang.Thread.run(Thread.java:1570)
]

Issue Reasons:

• [main] 3 consecutive failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1}
• [main] 4 failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} (2.3% fail rate in 173 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 2 failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} (0.6% fail rate in 332 executions)

Build Scans:

• elasticsearch-intake #8938 / part4
• elasticsearch-intake #8938 / part4

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 3 failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} (1.7% fail rate in 175 executions)

Build Scans:

• elasticsearch-periodic-platform-support #3749 / windows-2022_checkpart3_platform-support-windows
• elasticsearch-pull-request #28511 / part-3
• elasticsearch-intake #8939 / part3

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 2 consecutive failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1}
• [main] 3 failures in test test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} (1.7% fail rate in 172 executions)

Build Scans:

• elasticsearch-periodic #3776 / concurrent-search-tests
• elasticsearch-periodic-platform-support #3749 / ubuntu-1804_platform-support-unix
• elasticsearch-pull-request #28511 / part-4

[luigidellaquila]

Fixed by #111938