[CI] EsqlSpecIT test {lookup-join.MvJoinKeyOnTheDataNode ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #5456 / debian-11_platform-support-unix
• elasticsearch-periodic-platform-support #5456 / rocky-8_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {lookup-join.MvJoinKeyOnTheDataNode ASYNC}" -Dtests.seed=9A6807D01B175C1B -Dtests.locale=kn -Dtests.timezone=Europe/Zurich -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Data mismatch:
row 3 column 2:a list containing
row 3 column 2:0: expected "[Mv-Lang, Mv-Lang2]" but was "[Mv-Lang2, Mv-Lang]"
Actual:
emp_no:integer | language_code:integer | language_name:keyword
10004          | 4                     | Quenya               
10005          | 5                     | null                 
10006          | 6                     | Mv-Lang              
10007          | 7                     | [Mv-Lang2, Mv-Lang]  

Expected:
emp_no:integer | language_code:integer | language_name:keyword
10004          | 4                     | Quenya               
10005          | 5                     | null                 
10006          | 6                     | Mv-Lang              
10007          | 7                     | [Mv-Lang, Mv-Lang2]  

Issue Reasons:

• [8.x] 2 consecutive failures in test test {lookup-join.MvJoinKeyOnTheDataNode ASYNC}
• [8.x] 2 failures in test test {lookup-join.MvJoinKeyOnTheDataNode ASYNC} (1.1% fail rate in 188 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)