Skip to content

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

Closed
Closed
[CI] JdbcCsvSpecIT test {agg-ordering.testHistogramDateTimeWithCountAndOrder_1} failing#111918
Labels
:Analytics/SQLSQL querying>test-failureTriaged test failures from CITeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)needs:riskRequires assignment of a risk label (low, medium, blocker)
@elasticsearchmachine

Description

@elasticsearchmachine
elasticsearchmachine
opened on Aug 15, 2024

Build Scans:

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 org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeVLong(StreamOutput.java:271)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$22(StreamOutput.java:771)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
	at org.elasticsearch.xpack.sql.session.ListCursor.writeTo(ListCursor.java:45)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/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 org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/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 org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at org.elasticsearch.xpack.sql.execution.search.Querier.lambda$closePointInTime$5(Querier.java:194)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:202)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:196)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$RunBeforeActionListener.onResponse(ActionListenerImplementations.java:335)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.ContextPreservingActionListener.onResponse(ContextPreservingActionListener.java:32)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.ClearScrollController.lambda$closeContexts$7(ClearScrollController.java:167)
	at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.AbstractRefCounted$1.closeInternal(AbstractRefCounted.java:118)
	at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.AbstractRefCounted.decRef(AbstractRefCounted.java:70)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.RefCountingRunnable.close(RefCountingRunnable.java:112)
	at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables$4.close(Releasables.java:159)
	at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables.close(Releasables.java:34)
	at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables.closeExpectNoException(Releasables.java:56)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$2.run(ActionListenerImplementations.java:50)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$1.onResponse(ActionListener.java:216)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerResponseHandler.handleResponse(ActionListenerResponseHandler.java:48)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TransportService$ContextRestoreResponseHandler.handleResponse(TransportService.java:1498)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundHandler.doHandleResponse(InboundHandler.java:432)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundHandler.handleResponse(InboundHandler.java:381)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundHandler.executeResponseHandler(InboundHandler.java:148)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundHandler.messageReceived(InboundHandler.java:123)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundHandler.inboundMessage(InboundHandler.java:97)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TcpTransport.inboundMessage(TcpTransport.java:821)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundPipeline.forwardFragments(InboundPipeline.java:124)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundPipeline.doHandleBytes(InboundPipeline.java:96)
	at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.InboundPipeline.handleBytes(InboundPipeline.java:61)
	at org.elasticsearch.transport.netty4@8.16.0-SNAPSHOT/org.elasticsearch.transport.netty4.Netty4MessageInboundHandler.channelRead(Netty4MessageInboundHandler.java:57)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.codec@4.1.109.Final/io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:444)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:412)
	at io.netty.transport@4.1.109.Final/io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1410)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:440)
	at io.netty.transport@4.1.109.Final/io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:420)
	at io.netty.transport@4.1.109.Final/io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:919)
	at io.netty.transport@4.1.109.Final/io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:166)
	at io.netty.transport@4.1.109.Final/io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
	at io.netty.transport@4.1.109.Final/io.netty.channel.nio.NioEventLoop.processSelectedKeysPlain(NioEventLoop.java:689)
	at io.netty.transport@4.1.109.Final/io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:652)
	at io.netty.transport@4.1.109.Final/io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
	at io.netty.common@4.1.109.Final/io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
	at io.netty.common@4.1.109.Final/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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    :Analytics/SQLSQL querying>test-failureTriaged test failures from CITeam:AnalyticsMeta label for analytical engine team (ESQL/Aggs/Geo)needs:riskRequires assignment of a risk label (low, medium, blocker)

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions