[CI] JdbcCsvSpecIT class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #3752 / rhel-7_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / rhel-7_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / rhel-8_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / rhel-8_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / opensuse-leap-15_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / opensuse-leap-15_platform-support-unix
• elasticsearch-pull-request #28540 / part-4
• elasticsearch-pull-request #28540 / part-4
• elasticsearch-pull-request #28525 / part-4-fips
• elasticsearch-periodic #3776 / openjdk23_checkpart4_java-matrix

Reproduction Line:

./gradlew ":x-pack:plugin:sql:qa:server:security:without-ssl:javaRestTest" --tests "org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT" -Dtests.method="test {datetime.testFormatHaving}" -Dtests.seed=6FEFA21A3A1C7E95 -Dtests.locale=en -Dtests.timezone=America/Cancun -Druntime.java=22

Applicable branches: main

Reproduces locally?: N/A

Failure History: See dashboard&_a=(controlGroupInput:(chainingSystem:HIERARCHICAL,controlStyle:twoLine,ignoreParentSettings:(ignoreFilters:!f,ignoreQuery:!f,ignoreTimerange:!f,ignoreValidations:!t),panels:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:task.keyword,grow:!t,id:'0c0c9cb8-ccd2-45c6-9b13-96bac4abc542',searchTechnique:wildcard,selectedOptions:!(),singleSelect:!t,title:'Gradle%20Task',width:medium),grow:!t,order:0,type:optionsListControl,width:small),'144933da-5c1b-4257-a969-7f43455a7901':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:name.keyword,grow:!t,id:'144933da-5c1b-4257-a969-7f43455a7901',searchTechnique:wildcard,selectedOptions:!('org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT'),title:Test,width:medium),grow:!t,order:2,type:optionsListControl,width:medium),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:className.keyword,grow:!t,id:'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850',searchTechnique:wildcard,selectedOptions:!('org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT'),title:Suite,width:medium),grow:!t,order:1,type:optionsListControl,width:medium)))))

Failure Message:

java.sql.SQLException: Server encountered an error [Negative longs unsupported, use writeLong or writeZLong for negative numbers [-214099200]]. [java.lang.IllegalStateException: Negative longs unsupported, use writeLong or writeZLong for negative numbers [-214099200]
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeVLong(StreamOutput.java:271)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$22(StreamOutput.java:771)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeCollection(StreamOutput.java:1096)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericList(StreamOutput.java:836)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.lambda$static$8(StreamOutput.java:700)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeGenericValue(StreamOutput.java:883)
    at org.elasticsearch.xpack.sql.session.ListCursor.writeTo(ListCursor.java:45)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.io.stream.StreamOutput.writeNamedWriteable(StreamOutput.java:1039)
    at org.elasticsearch.xpack.sql.session.Cursors.encodeToString(Cursors.java:82)
    at org.elasticsearch.xpack.sql.session.Cursors.encodeToString(Cursors.java:73)
    at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.createResponse(TransportSqlQueryAction.java:226)
    at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.createResponseWithSchema(TransportSqlQueryAction.java:207)
    at org.elasticsearch.xpack.sql.plugin.TransportSqlQueryAction.lambda$operation$0(TransportSqlQueryAction.java:171)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
    at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.sendResponse(Querier.java:353)
    at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.onResponse(Querier.java:330)
    at org.elasticsearch.xpack.sql.execution.search.Querier$LocalAggregationSorterListener.onResponse(Querier.java:272)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
    at org.elasticsearch.xpack.sql.execution.search.Querier.lambda$closePointInTime$5(Querier.java:194)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:202)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.tasks.TaskManager$1.onResponse(TaskManager.java:196)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$RunBeforeActionListener.onResponse(ActionListenerImplementations.java:335)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.ContextPreservingActionListener.onResponse(ContextPreservingActionListener.java:32)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.ClearScrollController.lambda$closeContexts$7(ClearScrollController.java:167)
    at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.AbstractRefCounted$1.closeInternal(AbstractRefCounted.java:118)
    at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.AbstractRefCounted.decRef(AbstractRefCounted.java:70)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.RefCountingRunnable.close(RefCountingRunnable.java:112)
    at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables$4.close(Releasables.java:159)
    at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables.close(Releasables.java:34)
    at org.elasticsearch.base@8.16.0-SNAPSHOT/org.elasticsearch.core.Releasables.closeExpectNoException(Releasables.java:56)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$2.run(ActionListenerImplementations.java:50)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$1.onResponse(ActionListener.java:216)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$3.onResponse(ActionListener.java:399)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerResponseHandler.handleResponse(ActionListenerResponseHandler.java:48)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TransportService$ContextRestoreResponseHandler.handleResponse(TransportService.java:1498)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TransportService$DirectResponseChannel.processResponse(TransportService.java:1595)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TransportService$DirectResponseChannel.sendResponse(TransportService.java:1569)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TaskTransportChannel.sendResponse(TaskTransportChannel.java:35)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.SearchTransportService.lambda$registerRequestHandler$2(SearchTransportService.java:460)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.SearchTransportService.lambda$instrumentedHandler$15(SearchTransportService.java:672)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.SecurityServerTransportInterceptor$ProfileSecuredRequestHandler$1.doRun(SecurityServerTransportInterceptor.java:579)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:26)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.SecurityServerTransportInterceptor$ProfileSecuredRequestHandler$3.onResponse(SecurityServerTransportInterceptor.java:632)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.SecurityServerTransportInterceptor$ProfileSecuredRequestHandler$3.onResponse(SecurityServerTransportInterceptor.java:621)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:640)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.FieldAndDocumentLevelSecurityRequestInterceptor.intercept(FieldAndDocumentLevelSecurityRequestInterceptor.java:79)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.SearchRequestInterceptor.intercept(SearchRequestInterceptor.java:20)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.IndicesAliasesRequestInterceptor.intercept(IndicesAliasesRequestInterceptor.java:124)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.FieldAndDocumentLevelSecurityRequestInterceptor.intercept(FieldAndDocumentLevelSecurityRequestInterceptor.java:79)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.UpdateRequestInterceptor.intercept(UpdateRequestInterceptor.java:27)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.BulkShardRequestInterceptor.intercept(BulkShardRequestInterceptor.java:85)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.FieldAndDocumentLevelSecurityRequestInterceptor.intercept(FieldAndDocumentLevelSecurityRequestInterceptor.java:79)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.ShardSearchRequestInterceptor.intercept(ShardSearchRequestInterceptor.java:23)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.ResizeRequestInterceptor.intercept(ResizeRequestInterceptor.java:98)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.SearchRequestCacheDisablingInterceptor.intercept(SearchRequestCacheDisablingInterceptor.java:53)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.DlsFlsLicenseRequestInterceptor.intercept(DlsFlsLicenseRequestInterceptor.java:106)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:638)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$1.onResponse(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.FieldAndDocumentLevelSecurityRequestInterceptor.intercept(FieldAndDocumentLevelSecurityRequestInterceptor.java:79)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.interceptor.ValidateRequestInterceptor.intercept(ValidateRequestInterceptor.java:20)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.runRequestInterceptors(AuthorizationService.java:634)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.handleIndexActionAuthorizationResult(AuthorizationService.java:619)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.lambda$authorizeAction$13(AuthorizationService.java:517)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$AuthorizationResultListener.onResponse(AuthorizationService.java:1033)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService$AuthorizationResultListener.onResponse(AuthorizationService.java:999)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.ContextPreservingActionListener.onResponse(ContextPreservingActionListener.java:32)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.RBACEngine.authorizeIndexAction(RBACEngine.java:356)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.authorizeAction(AuthorizationService.java:510)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.maybeAuthorizeRunAs(AuthorizationService.java:442)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.lambda$authorize$3(AuthorizationService.java:329)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListener$2.onResponse(ActionListener.java:256)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.ContextPreservingActionListener.onResponse(ContextPreservingActionListener.java:32)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.RBACEngine.lambda$resolveAuthorizationInfo$0(RBACEngine.java:155)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.store.CompositeRolesStore.lambda$getRoles$4(CompositeRolesStore.java:192)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.store.CompositeRolesStore.lambda$getRole$5(CompositeRolesStore.java:210)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.xcore@8.16.0-SNAPSHOT/org.elasticsearch.xpack.core.security.authz.store.RoleReferenceIntersection.lambda$buildRole$0(RoleReferenceIntersection.java:49)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.support.GroupedActionListener.onResponse(GroupedActionListener.java:56)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.store.CompositeRolesStore.buildRoleFromRoleReference(CompositeRolesStore.java:290)
    at org.elasticsearch.xcore@8.16.0-SNAPSHOT/org.elasticsearch.xpack.core.security.authz.store.RoleReferenceIntersection.lambda$buildRole$1(RoleReferenceIntersection.java:53)
    at java.base/java.lang.Iterable.forEach(Iterable.java:75)
    at org.elasticsearch.xcore@8.16.0-SNAPSHOT/org.elasticsearch.xpack.core.security.authz.store.RoleReferenceIntersection.buildRole(RoleReferenceIntersection.java:53)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.store.CompositeRolesStore.getRole(CompositeRolesStore.java:208)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.store.CompositeRolesStore.getRoles(CompositeRolesStore.java:185)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.RBACEngine.resolveAuthorizationInfo(RBACEngine.java:151)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authz.AuthorizationService.authorize(AuthorizationService.java:345)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.ServerTransportFilter.lambda$inbound$1(ServerTransportFilter.java:114)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListenerImplementations.java:246)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.ActionListenerImplementations$MappedActionListener.onResponse(ActionListenerImplementations.java:96)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authc.AuthenticatorChain.authenticate(AuthenticatorChain.java:93)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authc.AuthenticationService.authenticate(AuthenticationService.java:264)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.authc.AuthenticationService.authenticate(AuthenticationService.java:201)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.ServerTransportFilter.authenticate(ServerTransportFilter.java:127)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.ServerTransportFilter.inbound(ServerTransportFilter.java:105)
    at org.elasticsearch.security@8.16.0-SNAPSHOT/org.elasticsearch.xpack.security.transport.SecurityServerTransportInterceptor$ProfileSecuredRequestHandler.messageReceived(SecurityServerTransportInterceptor.java:643)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:75)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.transport.TransportService$6.doRun(TransportService.java:1097)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:991)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:26)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.SearchTransportService$1.onResponse(SearchTransportService.java:644)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.action.search.SearchTransportService$1.onResponse(SearchTransportService.java:640)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.AbstractThrottledTaskRunner$1.doRun(AbstractThrottledTaskRunner.java:135)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:991)
    at org.elasticsearch.server@8.16.0-SNAPSHOT/org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:26)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
    at java.base/java.lang.Thread.run(Thread.java:1570)
]

Issue Reasons:

• [main] 6 consecutive failures in class org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT
• [main] 11 failures in class org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT (3.3% fail rate in 333 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (4.1% fail rate in 49 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 consecutive failures in class org.elasticsearch.xpack.sql.qa.single_node.JdbcCsvSpecIT
• [main] 5 failures in class org.elasticsearch.xpack.sql.qa.single_node.JdbcCsvSpecIT (2.9% fail rate in 175 executions)
• [main] 2 failures in step part-3 (3.1% fail rate in 64 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (3.1% fail rate in 64 executions)

Build Scans:

• elasticsearch-periodic-platform-support #3749 / ubuntu-2204_platform-support-unix
• elasticsearch-periodic-platform-support #3749 / windows-2022_checkpart3_platform-support-windows
• elasticsearch-pull-request #28511 / part-3
• elasticsearch-intake #8939 / part3
• elasticsearch-pull-request #28488 / part-3

[elasticsearchmachine]

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

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 5 failures in class org.elasticsearch.xpack.sql.qa.multi_cluster_with_security.JdbcCsvSpecIT (2.8% fail rate in 180 executions)

Build Scans:

• elasticsearch-intake #8947 / part4
• elasticsearch-periodic-platform-support #3749 / debian-11_platform-support-unix
• elasticsearch-periodic #3776 / concurrent-search-tests
• elasticsearch-periodic-platform-support #3749 / ubuntu-1804_platform-support-unix
• elasticsearch-pull-request #28511 / part-4

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 2 consecutive failures in class org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT
• [main] 7 failures in class org.elasticsearch.xpack.sql.qa.security.JdbcCsvSpecIT (2.1% fail rate in 333 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (3.9% fail rate in 51 executions)

Build Scans:

• elasticsearch-periodic-platform-support #3752 / opensuse-leap-15_platform-support-unix
• elasticsearch-periodic-platform-support #3752 / opensuse-leap-15_platform-support-unix
• elasticsearch-pull-request #28540 / part-4
• elasticsearch-pull-request #28540 / part-4
• elasticsearch-pull-request #28525 / part-4-fips
• elasticsearch-periodic #3776 / openjdk23_checkpart4_java-matrix
• elasticsearch-periodic #3776 / openjdk23_checkpart4_java-matrix
• elasticsearch-intake #8938 / part4
• elasticsearch-intake #8938 / part4

[mark-vieira]

Looks like the same as https://github.com/elastic/elasticsearch/issues/111922

[elasticsearchmachine]

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

[ldematte]

I assigned a medium risk, as this is a genuine bug but it already has a fix (and AFAIK the buggy version has not been released)