Build Scans:

• elasticsearch-intake #14149 / part3
• elasticsearch-pull-request #45435 / part-3
• elasticsearch-pull-request #45435 / part-3
• elasticsearch-intake #14138 / part3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.action.CrossClustersEnrichIT.testTopNThenEnrichRemote" -Dtests.seed=28CDF758812ADAA7 -Dtests.locale=es-EC -Dtests.timezone=Etc/GMT -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.IllegalStateException: Found 1 problem
line -1:-1: Plan [ProjectExec[[host{f}#462, timestamp{f}#463, user{f}#464, os{r}#465, ip{r}#466]]] optimized incorrectly due to missing references [ip{r}#466]

Issue Reasons:

• [main] 2 consecutive failures in step part3
• [main] 2 consecutive failures in pipeline elasticsearch-intake
• [main] 4 failures in test testTopNThenEnrichRemote (2.4% fail rate in 169 executions)
• [main] 2 failures in step part3 (9.1% fail rate in 22 executions)
• [main] 2 failures in step part-3 (2.5% fail rate in 79 executions)
• [main] 2 failures in pipeline elasticsearch-intake (9.1% fail rate in 22 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.