ClickHouse / ClickHouse/clickhouse-java
BatchUpdateException during inserts with jdbc driver
- 主要语言
- Java
- 星标
- 1.6k
- 派生
- 637
- 平均合并
- 2 天 23 小时
- 30 天内合并 PR
- 29
描述
Hello. I have an issue with connection to Clickhouse with the driver (version 0.4.6).
The problems with Inserts. There is an exception:
`java.sql.BatchUpdateException: Unexpected end of file from server, server ClickHouseNode [uri=http://clickhouse.dwh.staging.com:8123/default]@-971229636
at com.clickhouse.jdbc.SqlExceptionUtils.batchUpdateError(SqlExceptionUtils.java:107)
at com.clickhouse.jdbc.internal.InputBasedPreparedStatement.executeAny(InputBasedPreparedStatement.java:154)
at com.clickhouse.jdbc.internal.AbstractPreparedStatement.executeLargeBatch(AbstractPreparedStatement.java:85)`
I've tried change some timeouts on ClickHouse side, I've tested with several versions of driver. Still have this kind of problems.
Inserts 10k-100k
ch version - 23.3.8
driver - 0.4.6
It's not a blocker for me, because with retries the data is inserted but have at least 10 exceptions per hour.
Could you please give me some advice?
贡献指南
调研方向
从 com.clickhouse.jdbc.SqlExceptionUtils、InputBasedPreparedStatement 和 AbstractPreparedStatement 中的堆栈跟踪位置开始,然后使用 driver 0.4.6 针对 ClickHouse 23.3.8 重现插入 10k–100k 行的情况。完成标准是确定意外文件结束错误的原因,并在不依赖重试的情况下阻止反复出现的 BatchUpdateException。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- java
- 领域
- databases
- Issue 类型
- 缺陷
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 停滞
- 描述清晰度
- 需要澄清
- 新手友好度
- 28/100