Clickhouse问题集锦

最新推荐文章于 2025-05-01 09:36:05 发布

OOM先生

最新推荐文章于 2025-05-01 09:36:05 发布

阅读量4.5k

点赞数

分类专栏： clickhouse 问题文章标签：数据库

本文链接：https://blog.youkuaiyun.com/xiaoliu_1/article/details/113976866

版权

这篇博客总结了两个Clickhouse遇到的问题：一是JDBC连接错误`failed to respond`，通过升级到0.2.6版本解决了客户端和服务器HTTP连接的不一致问题；二是遇到HTTP读取超时问题，可以通过在JDBC属性中设置socket_timeout来解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、jdbc error , `failed to respond`

2021-02-22 07:31:31,656 ERROR [main] execute clickhouse Query Error
ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: xxxx, port: 8123; xxxx:8123 failed to respond
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.getException(ClickHouseExceptionSpecifier.java:91)
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:55)
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:24)
at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:633)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:117)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:100)
at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQuery(ClickHouseStatementImpl.java:95)
at ru.yandex.clickhou