Open ashishguptaom opened 3 years ago
I've got the same issue.
Caused by: java.sql.SQLException: Unable to get connection: there are no enabled urls
at ru.yandex.clickhouse.BalancedClickhouseDataSource.getAnyUrl(BalancedClickhouseDataSource.java:180) ~[clickhouse-jdbc-0.3.2-patch11-all.jar:clickhouse-jdbc 0.3.2-patch11 (revision: 27f8951)]
at ru.yandex.clickhouse.BalancedClickhouseDataSource.getConnection(BalancedClickhouseDataSource.java:205) ~[clickhouse-jdbc-0.3.2-patch11-all.jar:clickhouse-jdbc 0.3.2-patch11 (revision: 27f8951)]
at ru.yandex.clickhouse.BalancedClickhouseDataSource.getConnection(BalancedClickhouseDataSource.java:29) ~[clickhouse-jdbc-0.3.2-patch11-all.jar:clickhouse-jdbc 0.3.2-patch11 (revision: 27f8951)]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) ~[HikariCP-4.0.3.jar:?]
at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) ~[HikariCP-4.0.3.jar:?]
Good day, @leiless ! Can you upgrade to later version?
Thanks!
Ok, I'll try. Thanks!
In my project I have invoked
scheduledActualization()
while creatingBalancedClickhouseDataSource
which enable/disable urls in clickhouse cluster based on health check of node in cluster. Some time I am gettingjava.sql.SQLException: Unable to get connection: there are no enabled urls
even though at that time all node in my clickhouse cluster were alive and was able to connect and execute query using clickhouse-client.Current Behavior Getting below exception and issue getting resolved on application restart.
Expected Behavior url should be marked disable when node in cluster is not reachable and marked back as enabled when node in cluster reachable. It should not require application restart.
Code:
Exception:
java.sql.SQLException: Unable to get connection: there are no enabled urls at ru.yandex.clickhouse.BalancedClickhouseDataSource.getAnyUrl(BalancedClickhouseDataSource.java:177) at ru.yandex.clickhouse.BalancedClickhouseDataSource.getConnection(BalancedClickhouseDataSource.java:194) at com.netcore.deferredpublisher.service.BalancedDSConnectionProvider.getConnection(BalancedDSConnectionProvider.java:56) at com.netcore.deferredpublisher.dao.NmiDeferredpublishtaskDao.getUnpublishedEvents(NmiDeferredpublishtaskDao.java:45) at com.netcore.deferredpublisher.dao.NmiDeferredpublishtaskDao$$FastClassBySpringCGLIB$$8aba1b5b.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
clickhouse-driver version `
clickhouse-server version 19.14.6
Please let me know do I need to specify any additional configuration to resolve above issue?