Unable to Run Parallel ClickHouse Queries in Multiple Tabs

[SteZe85]

Description

When waiting for the results of a long-running SQL query, I’m unable to execute another query against the same database in a different tab — for example, to monitor resource consumption or inspect running processes while the original query is still executing.

The following error message is displayed:

SQL-Fehler [373] [22000]: Code: 373. DB::Exception: Session sess_12962af5-a038-46e7-afb0-29c1d512793f is locked by a concurrent client. (SESSION_IS_LOCKED) (queryId= )

DBeaver Version

Community Edition Version 26.0.5.202605171705

Operating System

Windows 11

Database and driver

ClickHouse 26.4.2.10
clickhouse-jdbc 0.9.8.

Steps to reproduce

1. Open a tab and execute:

SELECT count(*)
FROM numbers(10000000000)
WHERE cityHash64(number) % 1234567 = 42;

2. Open a second tab and execute another query for example:

select * from system.processes;

Additional context

In older versions of the clickhouse-jdbc driver it was possible to issue multiple statements at the same time in different tabs.

[davestokes]

@SteZe85 Thank you for your report.

[Destrolaric]

You can't reuse connection if you have a session_id, you can change this combo to Always, to create new connection for each tab. It's located in Connection settings SQL Editor page.

[SteZe85]

You can't reuse connection if you have a session_id, you can change this combo to Always, to create new connection for each tab. It's located in Connection settings SQL Editor page.

Thank you very much, that resolved my issue!

[E1izabeth]

Thanks for the response! We'll close the issue then