[CI] MixedClusterEsqlSpecIT test {date.EvalDateParseWithTimezone2 ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5496 / openjdk21_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5496 / graalvm-ce17_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5496 / openjdk17_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5491 / openjdk21_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5491 / openjdk22_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5491 / openjdk17_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5486 / openjdk17_8.16.3_java-fips-matrix-bwc
• elasticsearch-periodic #5486 / graalvm-ce17_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5481 / openjdk22_8.16.3_java-matrix-bwc
• elasticsearch-periodic #5481 / openjdk21_8.16.3_java-matrix-bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.16.3#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {date.EvalDateParseWithTimezone2 ASYNC}" -Dtests.seed=64FFE48A539341BC -Dtests.bwc=true -Dtests.locale=es-VE -Dtests.timezone=America/Creston -Druntime.java=21

Applicable branches:
8.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected an empty list
0: <unexpected> but was "Date format [dd/MMM/yyyy:HH:mm:ss Z] contains textual field specifiers that could change in JDK 23. See [https://www.elastic.co/guide/en/elasticsearch/reference/8.17/mapping-date-format.html#custom-date-format-locales] for more information."

Issue Reasons:

• [8.17] 2 consecutive failures in step openjdk21_8.16.3_java-matrix-bwc
• [8.17] 2 consecutive failures in step openjdk17_8.16.3_java-matrix-bwc
• [8.17] 17 failures in test test {date.EvalDateParseWithTimezone2 ASYNC} (36.2% fail rate in 47 executions)
• [8.17] 4 failures in step openjdk21_8.16.3_java-matrix-bwc (57.1% fail rate in 7 executions)
• [8.17] 3 failures in step graalvm-ce17_8.16.3_java-matrix-bwc (50.0% fail rate in 6 executions)
• [8.17] 5 failures in step openjdk22_8.16.3_java-matrix-bwc (71.4% fail rate in 7 executions)
• [8.17] 3 failures in step openjdk17_8.16.3_java-matrix-bwc (50.0% fail rate in 6 executions)
• [8.17] 2 failures in step openjdk17_8.16.3_java-fips-matrix-bwc (33.3% fail rate in 6 executions)
• [8.17] 7 failures in pipeline elasticsearch-periodic (100.0% fail rate in 7 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)