[CI] EsqlSpecIT test {csv-spec:date.EvalDateTruncQuarterlyIntervalWithGTInRange} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #11043 / debian-12_platform-support-unix
• elasticsearch-pull-request #96786 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {csv-spec:date.EvalDateTruncQuarterlyIntervalWithGTInRange}" -Dtests.seed=21A8BC6622EB1BE2 -Dtests.locale=kde-TZ -Dtests.timezone=Africa/Bujumbura -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [GET], host [http://[::1]:35133], URI [/_query/async/FjZ2aTgwbU5KUURLbGxRNzF5QV9ua2ccTkF3dUJBX0RSUy1udjlscFBHWi1IQTozNjg2Mw==?wait_for_completion_timeout=6000s&pretty=true&error_trace=true], status line [HTTP/1.1 503 Service Unavailable]
{
  "error" : {
    "root_cause" : [
      {
        "type" : "cluster_block_exception",
        "reason" : "blocked by: [SERVICE_UNAVAILABLE/2/no master];",
        "stack_trace" : "org.elasticsearch.cluster.block.ClusterBlockException: blocked by: [SERVICE_UNAVAILABLE/2/no master];\n"
      }
    ],
    "type" : "cluster_block_exception",
    "reason" : "blocked by: [SERVICE_UNAVAILABLE/2/no master];",
    "stack_trace" : "org.elasticsearch.cluster.block.ClusterBlockException: blocked by: [SERVICE_UNAVAILABLE/2/no master];\n"
  },
  "status" : 503
}

Issue Reasons:

• [main] 2 failures in test test {csv-spec:date.EvalDateTruncQuarterlyIntervalWithGTInRange} (0.4% fail rate in 565 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 {csv-spec:date.EvalDateTruncQuarterlyIntervalWithGTInRange} (0.4% fail rate in 565 executions)

Build Scans:

• elasticsearch-periodic-platform-support #11043 / debian-12_platform-support-unix
• elasticsearch-pull-request #96786 / part-3

[elasticsearchmachine]

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

[astefan]

@afoucret please check this one, as well. At the same time that test failed, I see in a node logs this:

[2025-10-07T17:35:41,545][ERROR][o.e.b.ElasticsearchUncaughtExceptionHandler] [test-cluster-1] fatal error in thread [elasticsearch[test-cluster-1][search][T#2]], exiting
java.lang.AssertionError: returned more bytes than it used
	at org.elasticsearch.xpack.esql.core.expression.FoldContext$1.addWithoutBreaking(FoldContext.java:118) ~[?:?]
	at org.elasticsearch.compute.data.BlockFactory.adjustBreaker(BlockFactory.java:90) ~[?:?]
	at org.elasticsearch.compute.data.AbstractVector.closeInternal(AbstractVector.java:39) ~[?:?]
	at org.elasticsearch.compute.data.AbstractNonThreadSafeRefCounted.decRef(AbstractNonThreadSafeRefCounted.java:46) ~[?:?]
	at org.elasticsearch.compute.data.AbstractNonThreadSafeRefCounted.close(AbstractNonThreadSafeRefCounted.java:59) ~[?:?]
	at org.elasticsearch.core.Releasables.close(Releasables.java:39) ~[elasticsearch-core-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.core.Releasables.closeExpectNoException(Releasables.java:72) ~[elasticsearch-core-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.compute.data.FloatArrayBlock.closeInternal(FloatArrayBlock.java:247) ~[?:?]
	at org.elasticsearch.compute.data.AbstractNonThreadSafeRefCounted.decRef(AbstractNonThreadSafeRefCounted.java:46) ~[?:?]
	at org.elasticsearch.compute.data.AbstractNonThreadSafeRefCounted.close(AbstractNonThreadSafeRefCounted.java:59) ~[?:?]
	at org.elasticsearch.core.Releasables.close(Releasables.java:39) ~[elasticsearch-core-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.core.Releasables.close(Releasables.java:48) ~[elasticsearch-core-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.core.Releasables.closeExpectNoException(Releasables.java:62) ~[elasticsearch-core-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.compute.data.Page.releaseBlocks(Page.java:245) ~[?:?]
	at org.elasticsearch.xpack.esql.inference.InferenceFunctionEvaluator.lambda$fold$0(InferenceFunctionEvaluator.java:136) ~[?:?]
	at org.elasticsearch.action.ActionListenerImplementations$ResponseDroppingActionListener.onResponse(ActionListenerImplementations.java:288) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.support.SubscribableListener$SuccessResult.complete(SubscribableListener.java:406) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.support.SubscribableListener.tryComplete(SubscribableListener.java:326) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.support.SubscribableListener.setResult(SubscribableListener.java:355) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.support.SubscribableListener.onResponse(SubscribableListener.java:262) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.compute.operator.DriverContext$AsyncActions.removeInstance(DriverContext.java:237) ~[?:?]
	at org.elasticsearch.compute.operator.DriverContext.removeAsyncAction(DriverContext.java:169) ~[?:?]
	at org.elasticsearch.compute.operator.AsyncOperator.lambda$addInput$2(AsyncOperator.java:107) ~[?:?]
	at org.elasticsearch.action.ActionListenerImplementations$RunAfterActionListener.onResponse(ActionListenerImplementations.java:314) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:413) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.ActionListenerImplementations$RunBeforeActionListener.onResponse(ActionListenerImplementations.java:350) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:413) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:111) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.xpack.esql.inference.bulk.BulkInferenceRunner.lambda$executeBulk$0(BulkInferenceRunner.java:102) ~[?:?]
	at org.elasticsearch.action.ActionListenerImplementations$ResponseDroppingActionListener.onResponse(ActionListenerImplementations.java:288) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.xpack.esql.inference.bulk.BulkInferenceRunner$BulkInferenceRequest.onBulkCompletion(BulkInferenceRunner.java:355) ~[?:?]
	at org.elasticsearch.xpack.esql.inference.bulk.BulkInferenceRunner$BulkInferenceRequest.lambda$executePendingRequests$2(BulkInferenceRunner.java:273) ~[?:?]
	at org.elasticsearch.action.ActionListenerImplementations$RunAfterActionListener.onResponse(ActionListenerImplementations.java:314) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:413) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.action.support.ThreadedActionListener$1.doRun(ThreadedActionListener.java:40) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:27) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.common.util.concurrent.TimedRunnable.doRun(TimedRunnable.java:35) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:1067) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:27) ~[elasticsearch-9.3.0-SNAPSHOT.jar:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1090) ~[?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:614) ~[?:?]
	at java.lang.Thread.run(Thread.java:1474) ~[?:?]