[CI] DateTimeToCharProcessorTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8776 / zulu8_java-matrix
• elasticsearch-periodic #8776 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #8776 / corretto11_java-matrix
• elasticsearch-periodic #8776 / corretto8_java-matrix
• elasticsearch-periodic #8776 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #8776 / zulu11_java-matrix
• elasticsearch-periodic #8770 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #8770 / zulu8_java-matrix
• elasticsearch-periodic #8770 / corretto11_java-matrix
• elasticsearch-periodic #8770 / adoptopenjdk11_java-matrix

Reproduction Line:

./gradlew ':x-pack:plugin:sql:test' --tests "org.elasticsearch.xpack.sql.expression.function.scalar.datetime.DateTimeToCharProcessorTests" -Dtests.method="test {tochar-generated.csv:70 TZH @ FMTZHTH}" -Dtests.seed=72FEDD3EA9FA264A -Dtests.locale=ja -Dtests.timezone=Canada/Central -Druntime.java=11

Applicable branches: 7.17

Reproduces locally?: N/A

Failure History: See dashboard

Failure Message:

org.junit.ComparisonFailure: 
Line number:                        70 (in tochar-generated.csv)
zone:                               CET
timestamp (as epoch):               -140178730338.690196
timestamp (java, UTC):              -2473-11-30T23:47:41.309804Z
timestamp (postgres, to_timestamp): 2474-12-01 00:47:41.309804+01 BC
timestamp (java with zone):         -2473-12-01T00:05:11.309804+00:17:30[CET]
format string:                      TZH @ FMTZHTH
expected (postgres to_char result): +01 @ +01
actual (ES to_char result):         +00 @ +00
    FAILED (sub)pattern: TZH, expected:<+0[1]> but was:<+0[0]>

Issue Reasons:

• [7.17] 21 consecutive failures in step zulu8_java-matrix
• [7.17] 21 consecutive failures in step adoptopenjdk11_java-matrix
• [7.17] 21 consecutive failures in step corretto11_java-matrix
• [7.17] 20 consecutive failures in step corretto8_java-matrix
• [7.17] 21 consecutive failures in step adoptopenjdk8_java-matrix
• [7.17] 22 consecutive failures in step zulu11_java-matrix
• [7.17] 126 failures in class org.elasticsearch.xpack.sql.expression.function.scalar.datetime.DateTimeToCharProcessorTests (13.9% fail rate in 907 executions)
• [7.17] 21 failures in step zulu8_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 21 failures in step adoptopenjdk11_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 21 failures in step corretto11_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 20 failures in step corretto8_java-matrix (100.0% fail rate in 20 executions)
• [7.17] 21 failures in step adoptopenjdk8_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 22 failures in step zulu11_java-matrix (100.0% fail rate in 22 executions)
• [7.17] 22 failures in pipeline elasticsearch-periodic (100.0% fail rate in 22 executions)

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

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 2 failures in class org.elasticsearch.xpack.sql.expression.function.scalar.datetime.DateTimeToCharProcessorTests (0.7% fail rate in 272 executions)

Build Scans:

• elasticsearch-periodic #5957 / openjdk23_checkpart3_java-matrix
• elasticsearch-pull-request #51578 / part-3

[elasticsearchmachine]

Pinging @elastic/es-search (Team:Search)

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[astefan]

@luigidellaquila could you, please, have a look at this one? Some time ago, you've looked into an issue related to our switch to CLDR locale and I think the changes were in the same area as the test failure here.

[rjernst]

@astefan @luigidellaquila I have also applied the mute for this test to 8.x/8.18 as it breaks with the upgrade to JDK 24.