Long connection with parameter “externalDatabase" on Clickhouse-server 24.3+

[Trifonov-Artem]

DBeaver version 24.0.1

After updating Clickhouse-server to 24.3.1.2672, we noticed that the connection time to clickhouse increased noticeably, it turned out that the problem was the default parameter “externalDatabase” in the clickhouse jdbc driver for dbeaver, which creates a request when connecting.

select concat('jdbc(''', name, ''')') as table_cat from jdbc('', 'show datasources') order by name;

Previously, in previous versions of LTS 23.8, this request quickly completed with an error "clickhouse-jdbc-bridge is not running" and the connection occurred in a second, now the connection is processed in about 10 seconds

the request below is processed many times longer than in previous versions, and connection many times longer

select concat('jdbc(''', name, ''')') as table_cat from jdbc('', 'show datasources') order by name;

[chriscomeau79]

I ran into something similar but it was more like 32 seconds in a 3-server replicated cluster. A single server (under WSL) was about 10 seconds.

In DBeaver this can be fixed across all ClickHouse connections by adding a property in the Driver Manager -> ClickHouse Driver Properties tab -> add user property: externalDatabase false

then my 32 seconds went down to 200ms

[chernser]

Good day, @Trifonov-Artem!
Thanks for reporting!

Quick search gave me this issue #1245
I need some time to understand the history of it and them will be able to make a fix.
Looks like externalDatabase should be defaulted to false.