[CI] JdbcFrozenCsvSpecIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #8028 / ubuntu-2404-aarch64_platform-support-arm
• elasticsearch-periodic #7995 / encryption-at-rest
• elasticsearch-periodic-platform-support #8010 / ubuntu-2004-aarch64_platform-support-arm

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.testShowTables}" -Dtests.seed=1AE51B51242CC4AB -Dtests.locale=ca-ES -Dtests.timezone=Africa/Dar_es_Salaam -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:71] [sql/query] failed to parse field [time_zone]]. [org.elasticsearch.xcontent.XContentParseException: [-1:71] [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.el
[truncated]

Issue Reasons:

• [7.17] 3 failures in class org.elasticsearch.xpack.sql.qa.single_node.JdbcFrozenCsvSpecIT (2.6% fail rate in 117 executions)
• [7.17] 2 failures in pipeline elasticsearch-periodic-platform-support (50.0% fail rate in 4 executions)

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

[elasticsearchmachine]

Pinging @elastic/es-delivery (Team:Delivery)

[elasticsearchmachine]

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

[alex-spies]

Looks like that's due to the timezone renaming from Europe/Kiev to Europe/Kyiv.

Since this is a narrow edge case, I think this is low risk.

[alex-spies]

I think this is a duplicate of #111214. I'm keeping this open so the bot doesn't come and open a new issue every now and then when this leads to a test failure.