[CI] JdbcFrozenCsvSpecIT test {frozen.testColumnFromFrozen} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #6702 / oraclelinux-8_platform-support-unix
• elasticsearch-periodic-platform-support #6617 / ubuntu-1804_platform-support-unix
• elasticsearch-periodic-platform-support #6561 / ubuntu-2404_platform-support-unix

Reproduction Line:

./gradlew ':x-pack:plugin:sql:qa:server:single-node:javaRestTest' --tests "org.elasticsearch.xpack.sql.qa.single_node.JdbcFrozenCsvSpecIT" -Dtests.method="test {frozen.testCountFromFrozen}" -Dtests.seed=399DDAE0C1182C00 -Dtests.locale=sr-ME -Dtests.timezone=Asia/Almaty -Druntime.java=22

Applicable branches:
7.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.sql.SQLException: Server sent bad type [x_content_parse_exception]. Original type was [[-1:112] [sql/query] failed to parse field [time_zone]]. [org.elasticsearch.xcontent.XContentParseException: [-1:112] [sql/query] failed to parse field [time_zone]
	at org.elasticsearch.xcontent.ObjectParser.throwFailedToParse(ObjectParser.java:609)
	at org.elasticsearch.xcontent.ObjectParser.parseValue(ObjectParser.java:604)
	at org.elasticsearch.xcontent.ObjectParser.parseSub(ObjectParser.java:652)
	at org.elasticsearch.xcontent.ObjectParser.parse(ObjectParser.java:320)
	at org.elasticsearch.xcontent.ObjectParser.parse(ObjectParser.java:260)
	at org.elasticsearch.xcontent.ObjectParser.apply(ObjectParser.java:393)
	at org.elasticsearch.xpack.sql.action.SqlQueryRequest.fromXContent(SqlQueryRequest.java:335)
	at org.elasticsearch.xpack.sql.plugin.RestSqlQueryAction.prepareRequest(RestSqlQueryAction.java:51)
	at org.elasticsearch.rest.BaseRestHandler.handleRequest(BaseRestHandler.java:86)
	at org.
[truncated]

Issue Reasons:

• [7.17] 3 failures in test test {frozen.testColumnFromFrozen} (0.4% fail rate in 833 executions)
• [7.17] 3 failures in pipeline elasticsearch-periodic-platform-support (13.6% 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-data-management (Team:Data Management)

[elasticsearchmachine]

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

[alex-spies]

Same problem as #123795:

Caused by: java.time.zone.ZoneRulesException: Unknown time-zone ID: America/Ciudad_Juarez