[CI] XpackWithMultipleProjectsClientYamlTestSuiteIT test {yaml=esql/10_basic/basic with documents_found} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #7751 / amazonlinux-2023_platform-support-aws
• elasticsearch-pull-request #68467 / part-2-windows

Reproduction Line:

./gradlew ":x-pack:qa:multi-project:xpack-rest-tests-with-multiple-projects:yamlRestTest" --tests "org.elasticsearch.multiproject.test.XpackWithMultipleProjectsClientYamlTestSuiteIT.test {yaml=esql/10_basic/basic with documents_found}" -Dtests.seed=D676AAD22180945B -Dtests.locale=en-UM -Dtests.timezone=Canada/Yukon -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

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

Issue Reasons:

• [main] 2 failures in test test {yaml=esql/10_basic/basic with documents_found} (0.8% fail rate in 245 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 {yaml=esql/10_basic/basic with documents_found} (0.8% fail rate in 245 executions)

Build Scans:

• elasticsearch-periodic-platform-support #7751 / amazonlinux-2023_platform-support-aws
• elasticsearch-pull-request #68467 / part-2-windows

[elasticsearchmachine]

Pinging @elastic/es-data-management (Team:Data Management)

[nielsbauman]

Duplicate of #127046