Cancel statement doesn’t work due to “Session is locked by a concurrent client” (Regression for v2 client, v0.9.4)

[Keith-McCready]

Description

This bug appears to have returned in the v2 version of the client. Short version: When you use a Session ID, Statement.cancel() never works. I expect you need the previous fix again, which removed the session ID from the KILL QUERY options.

Steps to reproduce

1. Kick off a query that takes a long time and is killable using Connection.createStatement() and Statement.executeUpdate(...) or Statement.execute(), using a clickhouse_setting_session_id
2. Call Statement.cancel()

Error Log or Exception StackTrace

java.sql.SQLException: com.clickhouse.client.api.ServerException: Code: 373. DB::Exception: Session e589cc67-36d5-4baa-bc94-86fe9fd120e3 is locked by a concurrent client. (SESSION_IS_LOCKED) (version 25.3.2.39 (official build)) 
	at com.clickhouse.jdbc.StatementImpl.cancel(StatementImpl.java:312) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at [My Code]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[?:?]
	at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]
	at [My Code]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[?:?]
	at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]
	at [My Code]
	at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[?:?]
	at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]
	at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:219) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jersey-common-2.35.jar:?]
	at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~[jersey-server-2.35.jar:?]
	at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jersey-container-servlet-core-2.35.jar:?]
	at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jersey-container-servlet-core-2.35.jar:?]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jersey-container-servlet-core-2.35.jar:?]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jersey-container-servlet-core-2.35.jar:?]
	at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jersey-container-servlet-core-2.35.jar:?]
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1656) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:458) ~[shiro-web-1.13.0.jar:1.13.0]
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:373) ~[shiro-web-1.13.0.jar:1.13.0]
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) ~[shiro-core-1.13.0.jar:1.13.0]
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) ~[shiro-core-1.13.0.jar:1.13.0]
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387) ~[shiro-core-1.13.0.jar:1.13.0]
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:370) ~[shiro-web-1.13.0.jar:1.13.0]
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:154) ~[shiro-web-1.13.0.jar:1.13.0]
	at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at com.liveaction.lanet.server.web.filters.MultiReadServletFilter.doFilter(MultiReadServletFilter.java:49) ~[main/:?]
	at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1626) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:552) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) ~[jetty-security-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1440) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:505) ~[jetty-servlet-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1355) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:487) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) ~[jetty-server-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~[jetty-io-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) ~[jetty-util-9.4.58.v20250814.jar:9.4.58.v20250814]
	at java.base/java.lang.Thread.run(Thread.java:1583) [?:?]
Caused by: com.clickhouse.client.api.ServerException: Code: 373. DB::Exception: Session e589cc67-36d5-4baa-bc94-86fe9fd120e3 is locked by a concurrent client. (SESSION_IS_LOCKED) (version 25.3.2.39 (official build)) 
	at com.clickhouse.client.api.internal.HttpAPIClientHelper.readError(HttpAPIClientHelper.java:403) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.client.api.internal.HttpAPIClientHelper.executeRequest(HttpAPIClientHelper.java:467) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.client.api.Client.lambda$query$5(Client.java:1599) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.client.api.Client.runAsyncOperation(Client.java:2014) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.client.api.Client.query(Client.java:1644) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.client.api.Client.query(Client.java:1542) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	at com.clickhouse.jdbc.StatementImpl.cancel(StatementImpl.java:307) ~[clickhouse-jdbc-0.9.4-all.jar:clickhouse-jdbc 0.9.4 (revision: 39bd998)]
	... 98 more

Expected Behaviour

"Killed query [UUID]" in log and query no longer running

Code Example

Not sure how to give a concise example. Hopefully you already have a test for canceling queries.

Configuration

Using clickhouse_setting_session_id (see linked bug ticket). May also need a session timeout, but don't think so.

Client Configuration

Using clickhouse_setting_session_id (see linked bug ticket). May also need a session timeout, but don't think so.

Environment

• Cloud (no)
• Client version: 0.9.4; v2 client
• Language version: Java 21.0.5+11
• OS: Windows 10

ClickHouse Server

• ClickHouse Server version: 25.3.2.39
• ClickHouse Server non-default settings, if any: N/A
• CREATE TABLE statements for tables involved: Anything that takes long enough to read that you can cancel it
• Sample data for all these tables, use clickhouse-obfuscator if necessary

[Destrolaric]

It's actually a bug related to session_id, because the cancel operation has the same session ID as the query, it will fail. This was already fixed in a previous version of the driver(before v2) - #1033
And it's actually a regression

[chernser]

@Keith-McCready
thank you for reporting!
Will look into it.