[CI] DateTimeToCharProcessorTests test {tochar-generated.csv:76 mi @ FMmiTH} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8758 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #8758 / corretto8_java-matrix
• elasticsearch-periodic #8758 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #8752 / corretto11_java-matrix
• elasticsearch-periodic #8752 / zulu11_java-matrix
• elasticsearch-periodic #8752 / zulu8_java-matrix
• elasticsearch-periodic #8752 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #8752 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #8752 / corretto8_java-matrix
• elasticsearch-periodic #8746 / zulu11_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=36E6C61A81DC20E6 -Dtests.locale=ar-MA -Dtests.timezone=Australia/Darwin -Druntime.java=8

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] 3 consecutive failures in test test {tochar-generated.csv:76 mi @ FMmiTH}
• [7.17] 21 consecutive failures in step adoptopenjdk8_java-matrix
• [7.17] 21 consecutive failures in step corretto8_java-matrix
• [7.17] 21 consecutive failures in step adoptopenjdk11_java-matrix
• [7.17] 21 consecutive failures in step corretto11_java-matrix
• [7.17] 21 consecutive failures in step zulu11_java-matrix
• [7.17] 20 consecutive failures in step zulu8_java-matrix
• [7.17] 125 failures in test test {tochar-generated.csv:76 mi @ FMmiTH} (14.0% fail rate in 890 executions)
• [7.17] 21 failures in step adoptopenjdk8_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 21 failures in step corretto8_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] 21 failures in step zulu11_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 20 failures in step zulu8_java-matrix (100.0% fail rate in 20 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]

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