[CI] EsqlSpecIT test {rerank.Reranker add the _score column when missing ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #7476 / rhel-9_platform-support-unix
• elasticsearch-periodic #7447 / single-processor-node-tests
• elasticsearch-periodic #7447 / openjdk24_entitlements_true_checkpart3_java-matrix
• elasticsearch-periodic #7440 / concurrent-search-tests
• elasticsearch-pull-request #66519 / part-3
• elasticsearch-pull-request #66516 / part-3
• elasticsearch-pull-request #66215 / part-3
• elasticsearch-pull-request #65594 / 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 {rerank.Reranker add the _score column when missing ASYNC}" -Dtests.seed=E9A81693DD813AD4 -Dtests.locale=mn-Cyrl-MN -Dtests.timezone=US/Hawaii -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Data mismatch:
row 1 column 3:a list containing
row 1 column 3:0: expected <0.02222> but was <0.02273>
row 3 column 3:a list containing
row 3 column 3:0: expected <0.01515> but was <0.01493>
Actual:
book_no:keyword | title:text                                            | author:text                                 | _score:double
5327            | War and Peace                                         | Leo Tolstoy                                 | 0.03846      
4536            | War and Peace (Signet Classics)                       | [John Hockenberry, Leo Tolstoy, Pat Conroy] | 0.02273      
9032            | War and Peace: A Novel (6 Volumes)                    | Tolstoy Leo                                 | 0.02083      
2776            | The Devil and Other Stories (Oxford World's Classics) | Leo Tolstoy                                 | 0.01493      

Expected:
book_no:keyword | title:text                                            | author:text        
[truncated]

Issue Reasons:

• [main] 8 failures in test test {rerank.Reranker add the _score column when missing ASYNC} (5.7% fail rate in 141 executions)
• [main] 4 failures in step part-3 (7.8% fail rate in 51 executions)
• [main] 2 failures in pipeline elasticsearch-periodic (66.7% fail rate in 3 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (8.7% fail rate in 46 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] 8 failures in test test {rerank.Reranker add the _score column when missing ASYNC} (5.7% fail rate in 141 executions)
• [main] 4 failures in step part-3 (7.8% fail rate in 51 executions)
• [main] 2 failures in pipeline elasticsearch-periodic (66.7% fail rate in 3 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (8.7% fail rate in 46 executions)

Build Scans:

• elasticsearch-periodic-platform-support #7476 / rhel-9_platform-support-unix
• elasticsearch-periodic #7447 / single-processor-node-tests
• elasticsearch-periodic #7447 / openjdk24_entitlements_true_checkpart3_java-matrix
• elasticsearch-periodic #7440 / concurrent-search-tests
• elasticsearch-pull-request #66519 / part-3
• elasticsearch-pull-request #66516 / part-3
• elasticsearch-pull-request #66215 / part-3
• elasticsearch-pull-request #65594 / part-3

[elasticsearchmachine]

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

[dnhatn]

Fixed in #126415