[CI] EsqlSpecIT test {lookup-join.LookupMessageFromIndex SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #13862 / part3
• elasticsearch-pull-request #44510 / 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 {lookup-join.LookupIPFromIndex SYNC}" -Dtests.seed=F71ABA3EF7CD739B -Dtests.locale=lv -Dtests.timezone=Canada/Atlantic -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Data mismatch:
row 0 column 0:a list containing
row 0 column 0:0: expected "2023-10-23T13:55:01.543Z" but was "2023-10-23T13:33:34.937Z"
row 0 column 1:a list containing
row 0 column 1:0: expected "1756467" but was "1232382"
row 0 column 2:a list containing
row 0 column 2:0: expected "Connected to 10.1.0.1" but was "Disconnected"
row 0 column 3:a list containing
row 0 column 3:0: expected "172.21.3.15" but was "172.21.0.5"
row 0 column 4:a list containing
row 0 column 4:0: expected "Production" but was "Development"
row 1 column 0:a list containing
row 1 column 0:0: expected "2023-10-23T13:53:55.832Z" but was "2023-10-23T12:27:28.948Z"
row 1 column 1:a list containing
row 1 column 1:0: expected "5033755" but was "2764889"
row 1 column 2:a list containing
row 1 column 2:0: expected "Connection error" but was "Connected to 10.1.0.2"
row 1 column 3:a list containing
row 1 column 3:0: expected "172.21.3.15" but was "172.21.2.113"
row 1 column 4:a list containing
row 1 column 4:0: expected "Production" but was "QA"
row 2 column 0:a list containing
row 2 column 0:0: expected "2023-10-23T13:52:55.015Z" but was "2023-10-23T12:15:03.360Z"

Issue Reasons:

• [main] 2 failures in test test {lookup-join.LookupMessageFromIndex SYNC} (1.3% fail rate in 152 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 {lookup-join.LookupMessageFromIndex SYNC} (1.3% fail rate in 152 executions)

Build Scans:

• elasticsearch-intake #13862 / part3
• elasticsearch-pull-request #44510 / part-3

[elasticsearchmachine]

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