[CI] JdbcDocCsvSpecIT test {docs.testFilterToday} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #5417 / windows-2022_checkpart2_platform-support-windows
• elasticsearch-periodic-platform-support #5417 / windows-2019_checkpart2_platform-support-windows
• elasticsearch-periodic-platform-support #5417 / windows-2016_checkpart2_platform-support-windows
• elasticsearch-periodic-platform-support #5417 / ubuntu-2004_platform-support-unix
• elasticsearch-periodic #5428 / adoptopenjdk11_java-matrix
• elasticsearch-periodic #5428 / java11_java-fips-matrix
• elasticsearch-periodic #5428 / openjdk22_java-matrix
• elasticsearch-periodic #5428 / java11_java-matrix
• elasticsearch-periodic #5428 / adoptopenjdk8_java-matrix
• elasticsearch-periodic #5428 / encryption-at-rest

Reproduction Line:

gradlew ':x-pack:plugin:sql:qa:server:single-node:javaRestTest' --tests "org.elasticsearch.xpack.sql.qa.single_node.JdbcDocCsvSpecIT" -Dtests.method="test {docs.testFilterToday}" -Dtests.seed=5FA9670BA7CF215E -Dtests.locale=fi-FI -Dtests.timezone=Asia/Gaza -Druntime.java=22

Applicable branches:
7.17

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.junit.ComparisonFailure: Different result for column [first_name], entry [5] expected:<B[oja]n> but was:<B[rendo]n>

Issue Reasons:

• [7.17] 44 consecutive failures in test test {docs.testFilterToday}
• [7.17] 2 consecutive failures in step windows-2022_checkpart2_platform-support-windows
• [7.17] 2 consecutive failures in step windows-2019_checkpart2_platform-support-windows
• [7.17] 2 consecutive failures in step windows-2016_checkpart2_platform-support-windows
• [7.17] 2 consecutive failures in step ubuntu-2004_platform-support-unix
• [7.17] 2 consecutive failures in step adoptopenjdk11_java-matrix
• [7.17] 2 consecutive failures in step java11_java-fips-matrix
• [7.17] 2 consecutive failures in step openjdk22_java-matrix
• [7.17] 2 consecutive failures in step java11_java-matrix
• [7.17] 2 consecutive failures in step adoptopenjdk8_java-matrix
• [7.17] 2 consecutive failures in step encryption-at-rest
• [7.17] 2 consecutive failures in step ubuntu-1804_platform-support-unix
• [7.17] 2 consecutive failures in step zulu11_java-matrix
• [7.17] 2 consecutive failures in step amazonlinux-2023_platform-support-aws
• [7.17] 2 consecutive failures in step ubuntu-2204_platform-support-unix

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 8.x

Mute Reasons:

• [8.x] 2 failures in test test {docs.testFilterToday} (1.3% fail rate in 154 executions)

Build Scans:

• elasticsearch-intake #14582 / part3
• elasticsearch-pull-request #46872 / part-3

[elasticsearchmachine]

Pinging @elastic/es-core-infra (Team:Core/Infra)

[elasticsearchmachine]

Pinging @elastic/es-core-infra (Team:Core/Infra)

[elasticsearchmachine]

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

[alex-spies]

This happened again today, randomly on one of my pull requests against main. Buildscan