[CI] MixedClusterEsqlSpecIT test {ip.ToIpInSort SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8899 / 8.11.4_bwc
• elasticsearch-periodic #8893 / 8.11.4_bwc
• elasticsearch-periodic #8887 / 8.11.4_bwc
• elasticsearch-periodic #8881 / 8.12.2_bwc
• elasticsearch-periodic #8875 / 8.12.2_bwc
• elasticsearch-periodic #8863 / 8.13.4_bwc
• elasticsearch-periodic #8863 / 8.12.2_bwc
• elasticsearch-periodic #8857 / 8.13.4_bwc
• elasticsearch-periodic #8851 / 8.13.4_bwc
• elasticsearch-periodic #8851 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {ip.ToIpInSort SYNC}" -Dtests.seed=64FCE8CE55EFFA4 -Dtests.bwc=true -Dtests.locale=ia-001 -Dtests.timezone=Asia/Almaty -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.client.ResponseException: method [POST], host [http://[::1]:33371], URI [/_query?pretty=true&error_trace=true], status line [HTTP/1.1 500 Internal Server Error]
Warnings: [No limit defined, adding default limit of [500]]
{
  "error" : {
    "root_cause" : [
      {
        "type" : "esql_illegal_argument_exception",
        "reason" : "order by expression must be an attribute",
        "stack_trace" : "org.elasticsearch.xpack.esql.EsqlIllegalArgumentException: order by expression must be an attribute\n\tat org.elasticsearch.xpack.esql.planner.LocalExecutionPlanner.lambda$planTopN$3(LocalExecutionPlanner.java:422)\n\tat java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:197)\n\tat java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1708)\n\tat java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:509)\n\tat java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:49
[truncated]

Issue Reasons:

• [8.19] 3 consecutive failures in step 8.11.4_bwc
• [8.19] 13 failures in test test {ip.ToIpInSort SYNC} (5.3% fail rate in 244 executions)
• [8.19] 4 failures in step 8.11.4_bwc (40.0% fail rate in 10 executions)
• [8.19] 5 failures in step 8.12.2_bwc (55.6% fail rate in 9 executions)
• [8.19] 4 failures in step 8.13.4_bwc (44.4% fail rate in 9 executions)
• [8.19] 9 failures in pipeline elasticsearch-periodic (90.0% fail rate in 10 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)

[idegtiarenko]

Resolved by #129749