[CI] EsqlClientYamlIT test {p0=esql/10_basic/basic with documents_found} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #9210 / sles-15_platform-support-unix
• elasticsearch-periodic-platform-support #9203 / ubuntu-2004_platform-support-unix
• elasticsearch-periodic-platform-support #9189 / ubuntu-2204_platform-support-unix
• elasticsearch-intake #24964 / part3
• elasticsearch-periodic-platform-support #9126 / windows-2019_checkpart3_platform-support-windows
• elasticsearch-periodic-platform-support #9069 / oraclelinux-9_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:yamlRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlClientYamlIT.test {p0=esql/10_basic/basic with documents_found}" -Dtests.seed=64D1CD57F26B6E4B -Dtests.locale=lmo -Dtests.timezone=Africa/Harare -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [esql/10_basic:200]: 
Expected: <10>
     but: was <9>

Issue Reasons:

• [8.19] 6 failures in test test {p0=esql/10_basic/basic with documents_found} (0.9% fail rate in 673 executions)
• [8.19] 5 failures in pipeline elasticsearch-periodic-platform-support (23.8% fail rate in 21 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)

[luigidellaquila]

Fixed by #130689