Skip to content

apply RetryableExceptions to queries #1054

Description

@FrankChen021

ocasionally received such exception. a retry should be applied such exception to improve resiliency

	at org.jooq.impl.DefaultDSLContext.fetch(DefaultDSLContext.java:892) ~[jooq-3.17.99.jar!/:na]
	at org.bithon.server.storage.jdbc.clickhouse.web.DashboardStorage.getDashboard(DashboardStorage.java:72) ~[server-storage-jdbc-clickhouse-11.0.0-RELEASE.jar!/:na]
	at org.bithon.server.web.service.dashboard.DashboardManager.incrementalLoad(DashboardManager.java:114) ~[server-web-service-11.0.0-RELEASE.jar!/:na]
	at org.bithon.component.commons.concurrency.ScheduledExecutorServiceFactory$ExceptionSafeRunnable.run(ScheduledExecutorServiceFactory.java:52) ~[component-commons-11.0.0-RELEASE.jar!/:na]
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[na:na]
	at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:358) ~[na:na]
	at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[na:na]
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[na:na]
	at java.base/java.lang.Thread.run(Thread.java:1583) ~[na:na]
Caused by: java.sql.BatchUpdateException: The target server failed to respond
	at com.clickhouse.jdbc.SqlExceptionUtils.batchUpdateError(SqlExceptionUtils.java:107) ~[clickhouse-jdbc-0.7.2.jar!/:clickhouse-jdbc 0.7.2 (revision: 33b1fad)]
	at com.clickhouse.jdbc.internal.SqlBasedPreparedStatement.executeAny(SqlBasedPreparedStatement.java:223) ~[clickhouse-jdbc-0.7.2.jar!/:clickhouse-jdbc 0.7.2 (revision: 33b1fad)]
	at com.clickhouse.jdbc.internal.SqlBasedPreparedStatement.execute(SqlBasedPreparedStatement.java:470) ~[clickhouse-jdbc-0.7.2.jar!/:clickhouse-jdbc 0.7.2 (revision: 33b1fad)]
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497) ~[druid-1.1.24.jar!/:1.1.24]
	at org.jooq.tools.jdbc.DefaultPreparedStatement.execute(DefaultPreparedStatement.java:219) ~[jooq-3.17.99.jar!/:na]
	at org.jooq.impl.Tools.executeStatementAndGetFirstResultSet(Tools.java:4692) ~[jooq-3.17.99.jar!/:na]
	at org.jooq.impl.AbstractResultQuery.execute(AbstractResultQuery.java:236) ~[jooq-3.17.99.jar!/:na]
	at org.jooq.impl.AbstractQuery.execute(AbstractQuery.java:330) ~[jooq-3.17.99.jar!/:na]
	... 11 common frames omitted

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions