HikariCP timeout with com.clickhouse.jdbc.ClickHouseDataSource

[wzisheng]

clickhouse-jdbc 0.3.2 with HikariCP 4.0.3

if we use com.clickhouse.jdbc.ClickHouseDataSource, and convert to HikariCP datasource, then we got

while ru.yandex.clickhouse.clickhousedatasource works fine.
BTW, we use https

[zhicwu]

Hi @wzisheng, I didn't see JDBC driver show up in above stack trace. Could you elaborate? Would be great if you can provide minimal code for reproducing the issue.

[wzisheng]

@zhicwu here it is...

private static DataSource convertToHikari(final DataSource dataSource) {
HikariConfig hikariConfig = new HikariConfig();
hikariConfig.setConnectionTimeout(xxx);
hikariConfig.setMaximumPoolSize(20);
hikariConfig.setMaxLifetime(xxx);
hikariConfig.setDataSource(dataSource);
return new HikariDataSource(hikariConfig);
}

properties.put("ssl", "true");
properties.put("sslmode", "NONE");
DataSource dataSource = convertToHikari(new ClickHouseDataSource(url, properties));
while(10) {
try (Connection connection = dastaSource.getConnection(); // --- here will get timeout exception
Statement statement = connection.createStatement();
ResultSet result = statement.executeQuery(sql)) {
int count = 0;
if (result.next()) {
count = result.getInt("aa");
}
System.out.println(count);
} catch (Exception e) {
e.printStackTrace();
}
}

[zhicwu]

Not able to reproduce. Please make sure the url is valid and server is reachable from client.

Anyway, I updated examples by adding usePooledConnection() which works well.

[wzisheng]

Not able to reproduce. Please make sure the url is valid and server is reachable from client.

Anyway, I updated examples by adding usePooledConnection() which works well.

seems usePooledConnection() only get one connection, which in mine the first time it works fine . Only if the 2nd or 3/4th time it will produce..
@zhicwu

[zhicwu]

Only if the 2nd or 3/4th time it will produce..

Tried a loop for 1000 times(pool size=20) and still not able to reproduce. Please feel free to reopen the issue if you're certain it's caused by the driver.