[CI] LookupJoinTypesIT testLookupJoinOthers failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #8728 / oraclelinux-7_platform-support-unix
• elasticsearch-periodic-platform-support #8716 / rhel-7_platform-support-unix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.LookupJoinTypesIT.testLookupJoinOthers" -Dtests.seed=40625B8B28A0D987 -Dtests.locale=pa-PK -Dtests.timezone=America/Virgin -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: [1] shard failures

Issue Reasons:

• [8.19] 2 failures in test testLookupJoinOthers (1.4% fail rate in 148 executions)
• [8.19] 2 failures in pipeline elasticsearch-periodic-platform-support (50.0% fail rate in 4 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)

[dnhatn]

I opened #129437.