[CI] MixedClusterEsqlSpecIT test {version.CountVersion SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5111 / 8.11.4_bwc
• elasticsearch-periodic #5105 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {version.CountVersion SYNC}" -Dtests.seed=2B32DFB6B29B9194 -Dtests.bwc=true -Dtests.locale=zgh -Dtests.timezone=JST -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected more data but no more entries found after [1]
Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected "2" but was "12"
row 0 column 1:a list containing
row 0 column 1:0: expected "aaaaa" but was "null"

Issue Reasons:

• [8.x] 2 failures in test test {version.CountVersion SYNC} (1.6% fail rate in 122 executions)
• [8.x] 2 failures in pipeline elasticsearch-periodic (50.0% fail rate in 4 executions)

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

[elasticsearchmachine]

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

[astefan]

Should be fixed by #117832