[CI] SpatialCentroidTests testAggregateIntermediate {TestCase=<geo_point> #4} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8062 / encryption-at-rest
• elasticsearch-periodic #8056 / openjdk21_checkpart3_java-matrix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.aggregate.SpatialCentroidTests.testAggregateIntermediate {TestCase=<geo_point> #4}" -Dtests.seed=593FD7B5E38466D9 -Dtests.locale=pt-TL -Dtests.timezone=America/Adak -Druntime.java=23

Applicable branches:
8.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <[1 1 0 0 0 d 8 7d 67 57 2c 2 c0 30 50 e7 29 7c 8c 11 c0]>
     but: was <[1 1 0 0 0 c 8 7d 67 57 2c 2 c0 30 50 e7 29 7c 8c 11 c0]>

Issue Reasons:

• [8.17] 2 failures in test testAggregateIntermediate {TestCase=<geo_point> Any plans to add geospatial search? #4} (2.1% fail rate in 97 executions)
• [8.17] 2 failures in pipeline elasticsearch-periodic (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)

[ivancea]

Maybe another flaky result like #114892?

[alex-spies]

@craigtaverner , could you maybe take a look if you get a chance?

[craigtaverner]

This appears to be due to a failed backport of #114892, so I've added a manual backport to 8.18 at #128037, and will see that it goes back to 8.18 and 8.17.