[CI] PushQueriesIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #8398 / windows-2019_checkpart3_platform-support-windows
• elasticsearch-periodic-platform-support #8386 / windows-2019_checkpart3_platform-support-windows
• elasticsearch-pull-request #72306 / part-3
• elasticsearch-periodic-platform-support #8362 / windows-2022_checkpart3_platform-support-windows

Reproduction Line:

gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.PushQueriesIT.testCaseInsensitiveEquality {text}" -Dtests.seed=ABDCFB586300EC85 -Dtests.locale=ksb-Latn-TZ -Dtests.timezone=Indian/Mauritius -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.io.IOException: Connection reset

Issue Reasons:

• [8.19] 4 failures in class org.elasticsearch.xpack.esql.qa.single_node.PushQueriesIT (1.6% fail rate in 246 executions)
• [8.19] 2 failures in step windows-2019_checkpart3_platform-support-windows (28.6% fail rate in 7 executions)
• [8.19] 3 failures in pipeline elasticsearch-periodic-platform-support (42.9% fail rate in 7 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)

[iverase]

fixed #128434