[CI] DateTimeToCharProcessorTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8049 / corretto8_java-matrix
• elasticsearch-periodic #8049 / zulu8_java-matrix
• elasticsearch-periodic #8049 / corretto11_java-matrix
• elasticsearch-periodic #8049 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #8049 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #8049 / zulu11_java-matrix
• elasticsearch-periodic #8043 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #8043 / corretto11_java-matrix
• elasticsearch-periodic #8043 / zulu11_java-matrix
• elasticsearch-periodic #8043 / zulu8_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:153 0:FMHHTH @ 1:FMHH12th @ 2:HH24TH @ 3:fmMITH @ 4:fmSSth @ 5:fmMSth @ 6:fmUSth @ 7:fmFF1TH @ 8:fmFF2 @ 9:fmFF3TH @ 10:FMFF4 @ 11:FF5 @ 12:FMFF6 @ 13:FMSSSSSth @ 14:FMSSSSTH @ 15:AM @ 16:fmamth @ 17:PMTH @ 18:FMpmTH @ 19:A.M. @ 20:a.m. @ 21:fmP.M. @ 22:FMp.m.TH @ 23:Y,YYYth @ 24:YYYYth @ 25:YYYTH @ 26:fmYYTH @ 27:Y @ 28:IYYY @ 29:FMIYYth @ 30:fmIYTH @ 31:fmITH @ 32:BCTH @ 33:fmbc @ 34:FMAD @ 35:fmad @ 36:B.C.th @ 37:fmb.c.th @ 38:A.D.TH @ 39:fma.d. @ 40:FMMONTHth @ 41:FMMonth @ 42:fmmonth @ 43:MONth @ 44:FMMon @ 45:fmmonth @ 46:MMTH @ 47:DAYth @ 48:fmDayTH @ 49:dayTH @ 50:DYth @ 51:FMDyth @ 52:fmdyTH @ 53:fmDDD @ 54:fmIDDDth @ 55:FMDDth @ 56:IDTH @ 57:D @ 58:fmWth @ 59:WWth @ 60:FMIWth @ 61:fmCCth @ 62:fmJ @ 63:QTH @ 64:RM @ 65:FMrm @ 66:FMTZHTH @ 67:FMTZMTH @ 68:fmOFTH @ 69:hh @ 70:fmhh12TH @ 71:FMhh24th @ 72:FMmith @ 73:FMssth @ 74:fmmsth @ 75:usTH @ 76:fmff1 @ 77:fmff2TH @ 78:FMff3 @ 79:FMff4TH @ 80:FMff5TH @ 81:fmff6 @ 82:sssssth @ 83:ssssTH @ 84:fmy,yyyth @ 85:yyyyth @ 86:yyy @ 87:fmyy @ 88:FMyTH @ 89:iyyyth @ 90:iyyTH @ 91:iyth @ 92:fmi @ 93:fmmm @ 94:fmdddTH @ 95:idddTH @ 96:ddTH @ 97:fmidTH @ 98:fmdTH @ 99:FMwth @ 100:FMwwth @ 101:fmiwth @ 102:cc @ 103:fmjth @ 104:FMqTH}" -Dtests.seed=FDCA6E7C8C45C706 -Dtests.locale=ar-MA -Dtests.timezone=Australia/Yancowinna -Druntime.java=8

Applicable branches:
7.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.junit.ComparisonFailure: 
Line number:                        153 (in tochar-generated.csv)
zone:                               CET
timestamp (as epoch):               -86799750510.092806
timestamp (java, UTC):              -0781-06-05T06:11:29.907194Z
timestamp (postgres, to_timestamp): 0782-06-05 07:11:29.907194+01 BC
timestamp (java with zone):         -0781-06-05T06:28:59.907194+00:17:30[CET]
format string:                      0:FMHHTH @ 1:FMHH12th @ 2:HH24TH @ 3:fmMITH @ 4:fmSSth @ 5:fmMSth @ 6:fmUSth @ 7:fmFF1TH @ 8:fmFF2 @ 9:fmFF3TH @ 10:FMFF4 @ 11:FF5 @ 12:FMFF6 @ 13:FMSSSSSth @ 14:FMSSSSTH @ 15:AM @ 16:fmamth @ 17:PMTH @ 18:FMpmTH @ 19:A.M. @ 20:a.m. @ 21:fmP.M. @ 22:FMp.m.TH @ 23:Y,YYYth @ 24:YYYYth @ 25:YYYTH @ 26:fmYYTH @ 27:Y @ 28:IYYY @ 29:FMIYYth @ 30:fmIYTH @ 31:fmITH @ 32:BCTH @ 33:fmbc @ 34:FMAD @ 35:fmad @ 36:B.C.th @ 37:fmb.c.th @ 38:A.D.TH @ 39:fma.d. @ 40:FMMONTHth @ 41:FMMonth @ 42:fmmonth @ 43:MONth @ 44:FMMon @ 45:fmmonth @ 46:MMTH @ 47:DAYth @ 48:fmDayTH 
[truncated]

Issue Reasons:

• [7.17] 6 consecutive failures in class org.elasticsearch.xpack.sql.expression.function.scalar.datetime.DateTimeToCharProcessorTests
• [7.17] 22 consecutive failures in step corretto8_java-matrix
• [7.17] 21 consecutive failures in step zulu8_java-matrix
• [7.17] 22 consecutive failures in step corretto11_java-matrix
• [7.17] 21 consecutive failures in step adoptopenjdk11_java-matrix
• [7.17] 21 consecutive failures in step adoptopenjdk8_java-matrix
• [7.17] 21 consecutive failures in step zulu11_java-matrix
• [7.17] 128 failures in class org.elasticsearch.xpack.sql.expression.function.scalar.datetime.DateTimeToCharProcessorTests (14.3% fail rate in 893 executions)
• [7.17] 22 failures in step corretto8_java-matrix (100.0% fail rate in 22 executions)
• [7.17] 21 failures in step zulu8_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 22 failures in step corretto11_java-matrix (100.0% fail rate in 22 executions)
• [7.17] 21 failures in step adoptopenjdk11_java-matrix (100.0% fail rate in 21 executions)
• [7.17] 21 failures in step adoptopenjdk8_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] 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.