Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: 10

已于 2023-12-06 09:35:39 修改
阅读量2.3k 收藏 17
点赞数 25
分类专栏： service 文章标签： clickhouse
于 2023-12-06 09:32:46 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gogler/article/details/134823116
版权


org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: 10., port: 83; Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)

### The error may exist in file [/Users/jasonhu/IdeaProjects/i-dal/target/classes ck/mapper/VehicleLocationCKMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT * FROM table         where device_id = ?               and ts >= ?                 and ts <= ?           and speed=0 and speed2=0         ORDER BY ts;
### Cause: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: 10.7.80.58, port: 8123; Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)

; uncategorized SQLException; SQL state [null]; error code [62]; ClickHouse exception, code: 62, host: 10.7.80.58, port: 8123; Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)
; nested exception is ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: 10.7.80.58, port: 8123; Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:75)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:447)
    at com.sun.proxy.$Proxy140.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:231)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:128)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:68)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:53)
    at com.sun.proxy.$Proxy175.vehicleLocationList(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy176.vehicleLocationList(Unknown Source)
    at comb.service.impl.VehicleLocationServiceImpl.vehicleLocationList(VehicleLocationServiceImpl.java:75)
    at com..impl.VehicleLocationServiceImpl$$FastClassBySpringCGLIB$$5ce85b8.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.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:119)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.VehicleLocationServiceImpl$$EnhancerBySpringCGLIB$$fa221c24.vehicleLocationList(<generated>)
    at com.VehicleLocationServiceImplTest.sparse(VehicleLocationServiceImplTest.java:49)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)
    at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)
    at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)
    at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)
    at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)
    at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
    at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
    at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
    at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:232)
    at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:55)
Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 62, host: 10.7.80.58, port: 8123; Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)

    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:60)
    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:30)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.checkForErrorAndThrow(ClickHouseStatementImpl.java:1083)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.getInputStream(ClickHouseStatementImpl.java:770)
    at ru.yandex.clickhouse.ClickHouseStatementImpl.executeQueryStatement(ClickHouseStatementImpl.java:272)
    at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.execute(ClickHousePreparedStatementImpl.java:139)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
    at com.sun.proxy.$Proxy483.execute(Unknown Source)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
    at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
    at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy287.query(Unknown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at comsPlugin.intercept(CatMybatisPlugin.java:81)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy287.query(Unknown Source)
    at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:142)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy287.query(Unknown Source)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:434)
    ... 59 more
Caused by: java.lang.Throwable: Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): failed at position 230 (end of query) (line 6, col 20): ;
FORMAT TabSeparatedWithNamesAndTypes. . (SYNTAX_ERROR) (version 22.3.2.1)

    at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:55)
    ... 102 more

攻城无数
关注
专栏目录
【clickhouse】ClickHouseException code: 999 Cannot allocate block number in ZooKeeper: Coordination
九师兄
02-05 4487
1.概述 clickhouse报错 com.dtstack.jlogstash.outputs.core.common.ClickhouseException: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 999, host: 172.16.8.84, port: 8123; Code: 999, e.displayText() = DB::Exception: Cannot allocate b.
CLickHouse出现端口异常问题
wppwpp1的专栏
10-15 1万+
java.lang.RuntimeException: ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 10.3.1.59, port: 9000; Port 9000 is for clickhouse-client program. You must...
ClickHouse出现这样的问题即解决方案：Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed): fai
m0_46741750的博客
03-25 1万+
一款简单粗暴的列式存储数据库（ClickHouse)
ClickHouse ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host:
jj89929665的博客
11-14 3059
错误：Exception in thread “main” java.lang.RuntimeException: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 210, host: 192.168.0.200, port: 8123;默认情况下，clickhouse只能内外访问，设置外网访问时，修改config.xml。找到clickhouse配置文件路径。
Clickhouse连接报错
m0_50440667的博客
08-30 3266
提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档 关闭防火墙未成功的解决方法 检查以前防火墙是否关闭成功 一. 删除未成功的ssh文件 二. 重新关闭防火墙 1.引入库 2.读入数据 总结 前言 提示：这里可以添加本文要记录的大概内容： 例如：随着人工智能的不断发展，机器学习这门技术也越来越重要，很多人都开启了学习机器学习，本文就介绍了机器学习的基础内容。 提示：以下是本篇文章正文内容，下面案例可供参考 一、pandas是什么？ 示例：pandas
clickhouse 操作报错
岁月静好，做自己。
07-04 6819
SQL 错误 [62]: ClickHouse exception, code: 62, host: 172.22.243.102, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 3499 (line 70, col 1): COMMENT '全景机柜信息中间表-包括特殊机房(香山同济)'. Expected one of: INTO OUTFILE, SETTINGS, FOR
Caused by: ru.yandex.clickhouse.except.ClickHouseException: ClickHouse exception, code: 69, host: clickhouse, port: 8123; Code: 69, e.displayText() = DB::Exception: Decimal result's scale is less than argument's one (version 20.3.19.4 (official build))
07-13
这个错误是由 ClickHouse 数据库引起的。错误代码 69 表示出现了一个问题，而且错误信息显示为 "Decimal result's scale is less than argument's one"。这可能是由于计算结果的小数位数小于参数的小数位数导致的。...
spark集成clickhouse报错： .ClassNotFound Failed to find data source: clickhouse. Please find packages at
m0_69097184的博客
09-25 674
Exception in thread "main" java.lang.ClassNotFoundException: Failed to find data source: clickhouse. Please find packages at http://spark.apache.org/third-party-projects.html at org.apache.spark.sql.execution.datasources.DataSource$.lookupDataSource(Da
clickhouse问题总结Caused by: com.github.housepower.jdbc.ClickHouseSQLException: DB::ExceptionDB::Excepti
weixin_43797368的博客
03-10 2252
clickhouse
Debezium报错处理系列十三：Caused by: java.io.EOFException
zhengzaifeidelushang的博客
04-13 1731
{ "id":0, "state":"FAILED", "worker_id":"p-qcbj6-dd-hadoop-debezium-001.prod-qcloud-dd-insight.net:8083", "trace":"org.apache.kafka.connect.errors.ConnectException: An exception occurred in the change event producer. This connector will be.
clickhouse.except.ClickHouseUnknownException异常
永青技术博客
03-26 7338
1、异常描述 2、异常日志 ------------------------------------------------------------ The program finished with the following exception: org.apache.flink.client.program.ProgramInvocationException: The main method caused an error: org.apache.flink.client.pro
ClickHouse:【SQL 错误 [62] [07000]: Code: 62. DB::Exception: Syntax error:
最新发布
weixin_53132877的博客
07-12 1060
MMP有没有人能告诉我为啥..................................成功了...........................
【sql】clickchouse别名使用，聚合函数报错情况
开发随笔-猫咪酱
12-05 3415
ClickHouse exception,Aggregate function sum(student_num) is found inside another aggregate function in query: While processing sum(student_num) AS student_num. (ILLEGAL_AGGREGATION) clickhouse别名复用
clickhouse常见异常以及错误码解决
热门推荐
weixin_57205390的博客
02-23 2万+
解决：合理设置max_concurrent_queries，max_bytes_before_external_sort，background_pool_size，max_memory_usage，max_memory_usage_for_all_queries，max_bytes_before_external_group_by，尤其重要的是max_memory_usage_for_all_queries 【 单机最大的内存使用量可以设置略小于机器的物理内存(留一点内操作系统)】。
ClickHouse exception, message: Code: 407. DB::Exception: Decimal math overflow 十进制溢出错误
人生快意事，读的好书，觅得良友
11-02 1698
ClickHouse exception, message: Code: 407. DB::Exception: Decimal math overflow 十进制溢出错误
node服务clickhouse查询报错： Code: 62. DB::Exception: Syntax error (Multi-statements are not allowed)
xiaomin13234038121的博客
04-23 3937
解决 s要查询的sql语句多了一个分号；将分号去掉即可解决
【clickhouse】Error querying database. No buffer space available (maximum connections reached?): conne
九师兄
04-11 662
1.概述 这个是定时任务去执行查询的，每1小时1次 查询ck，然后每次查询的数据量在几百条，然后偶尔会报错这个 Error querying database. Cause: ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: xxx, port: 8123; No buffer space available (maximum connections reache.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值