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

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7832 / zulu8_java-matrix
• elasticsearch-periodic #7832 / corretto8_java-matrix
• elasticsearch-periodic #7832 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #7832 / zulu11_java-matrix
• elasticsearch-periodic #7832 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #7826 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #7826 / corretto8_java-matrix
• elasticsearch-periodic #7826 / zulu11_java-matrix
• elasticsearch-periodic #7826 / corretto11_java-matrix
• elasticsearch-periodic #7826 / adoptopenjdk8_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:113 0:HH @ 1:HH12TH @ 2:fmHH24TH @ 3:FMMI @ 4:FMSSth @ 5:FMMSTH @ 6:USth @ 7:fmFF1th @ 8:FMFF2TH @ 9:FMFF3th @ 10:fmFF4 @ 11:fmFF5TH @ 12:FF6TH @ 13:fmSSSSS @ 14:SSSSTH @ 15:FMAMTH @ 16:FMam @ 17:fmPMTH @ 18:fmpmTH @ 19:fmA.M. @ 20:FMa.m.TH @ 21:FMP.M.TH @ 22:fmp.m.TH @ 23:FMY,YYYth @ 24:YYYY @ 25:YYYth @ 26:YY @ 27:Y @ 28:fmIYYY @ 29:FMIYY @ 30:fmIY @ 31:FMI @ 32:fmBCTH @ 33:FMbcth @ 34:FMAD @ 35:adTH @ 36:B.C.TH @ 37:b.c. @ 38:fmA.D. @ 39:fma.d.TH @ 40:FMMONTHth @ 41:FMMonth @ 42:fmmonthTH @ 43:fmMONTH @ 44:Mon @ 45:fmmon @ 46:fmMMTH @ 47:DAY @ 48:DayTH @ 49:FMday @ 50:FMDYTH @ 51:FMDyth @ 52:FMdy @ 53:DDDth @ 54:fmIDDD @ 55:FMDDTH @ 56:FMID @ 57:FMDTH @ 58:FMWth @ 59:WWth @ 60:FMIW @ 61:fmCCTH @ 62:FMJTH @ 63:QTH @ 64:FMRMth @ 65:rmth @ 66:FMTZH @ 67:FMTZMTH @ 68:FMOF @ 69:fmhhTH @ 70:fmhh12 @ 71:fmhh24 @ 72:mith @ 73:fmssTH @ 74:fmms @ 75:FMusth @ 76:ff1th @ 77:ff2TH @ 78:FMff3th @ 79:ff4 @ 80:fmff5 @ 81:fmff6TH @ 82:sssssth @ 83:FMssssTH @ 84:y,yyyth @ 85:yyyyth @ 86:FMyyy @ 87:fmyyTH @ 88:fmy @ 89:FMiyyyTH @ 90:iyyth @ 91:FMiyTH @ 92:FMith @ 93:mmTH @ 94:FMdddTH @ 95:fmidddth @ 96:dd @ 97:id @ 98:FMd @ 99:FMwth @ 100:fmwwth @ 101:fmiw @ 102:ccth @ 103:fmjth @ 104:qTH}" -Dtests.seed=3BCB67C617AA9095 -Dtests.locale=et -Dtests.timezone=Indian/Mauritius -Druntime.java=8

Applicable branches:
7.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.junit.ComparisonFailure: 
Line number:                        113 (in tochar-generated.csv)
zone:                               CET
timestamp (as epoch):               -96224368442.833361
timestamp (java, UTC):              -1080-10-09T00:45:57.166639Z
timestamp (postgres, to_timestamp): 1081-10-09 01:45:57.166639+01 BC
timestamp (java with zone):         -1080-10-09T01:03:27.166639+00:17:30[CET]
format string:                      0:HH @ 1:HH12TH @ 2:fmHH24TH @ 3:FMMI @ 4:FMSSth @ 5:FMMSTH @ 6:USth @ 7:fmFF1th @ 8:FMFF2TH @ 9:FMFF3th @ 10:fmFF4 @ 11:fmFF5TH @ 12:FF6TH @ 13:fmSSSSS @ 14:SSSSTH @ 15:FMAMTH @ 16:FMam @ 17:fmPMTH @ 18:fmpmTH @ 19:fmA.M. @ 20:FMa.m.TH @ 21:FMP.M.TH @ 22:fmp.m.TH @ 23:FMY,YYYth @ 24:YYYY @ 25:YYYth @ 26:YY @ 27:Y @ 28:fmIYYY @ 29:FMIYY @ 30:fmIY @ 31:FMI @ 32:fmBCTH @ 33:FMbcth @ 34:FMAD @ 35:adTH @ 36:B.C.TH @ 37:b.c. @ 38:fmA.D. @ 39:fma.d.TH @ 40:FMMONTHth @ 41:FMMonth @ 42:fmmonthTH @ 43:fmMONTH @ 44:Mon @ 45:fmmon @ 46:fmMMTH @ 47:DAY @ 48:DayTH @ 
[truncated]

Issue Reasons:

• [7.17] 5 consecutive failures in test test {tochar-generated.csv:76 mi @ FMmiTH}
• [7.17] 21 consecutive failures in step zulu8_java-matrix
• [7.17] 21 consecutive failures in step corretto8_java-matrix
• [7.17] 22 consecutive failures in step adoptopenjdk11_java-matrix
• [7.17] 22 consecutive failures in step zulu11_java-matrix
• [7.17] 18 consecutive failures in step adoptopenjdk8_java-matrix
• [7.17] 21 consecutive failures in step corretto11_java-matrix
• [7.17] 125 failures in test test {tochar-generated.csv:76 mi @ FMmiTH} (14.1% fail rate in 887 executions)
• [7.17] 21 failures in step zulu8_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] 22 failures in step adoptopenjdk11_java-matrix (100.0% fail rate in 22 executions)
• [7.17] 22 failures in step zulu11_java-matrix (100.0% fail rate in 22 executions)
• [7.17] 18 failures in step adoptopenjdk8_java-matrix (90.0% fail rate in 20 executions)
• [7.17] 21 failures in step corretto11_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]

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