clickhouse删除数据时报错 原创 2022-06-13 14:02:15.0 阅读(4001)次 今天执行了一下ck的表数据删除报错,错误信息如下: ``` ClickHouse exception, code: 1002, host: 192.168.29.124, port: 18123; Code: 341. DB::Exception: There was an error on [192.168.29.126:9000]: Code: 341. DB::Exception: Exception happened during execution of mutation '0000000000' with part 'all_3_3_0' reason: 'Code: 198. DB::Exception: Not found address of host: ck124. (DNS_ERROR) (version 22.2.2.1)'. This error maybe retryable or not. In case of unretryable error, mutation can be killed with KILL MUTATION query. (UNFINISHED) (version 22.2.2.1). (UNFINISHED) (version 22.2.2.1) ``` 执行的语句如下: ```sql ALTER TABLE db.baz_ape_local on cluster my_cluster DELETE WHERE 1=1 ``` 查看错误 Not found address of host: ck124,原来是要配置hosts,当初安装时没有配置这个也一样运行,但目前来看安装时最好将每台机的hosts都配置一下: ```shell echo "192.168.29.124 ck124" >> /etc/hosts echo "192.168.29.126 ck126" >> /etc/hosts ``` hosts配置好后,再次运行删除,搞定! clickhouse 上一篇:postgresql jdbc driver驱动连接属性列表 下一篇:java程序员多线程常见的代码bug
相关文章 clickhouse执行查询内存超出限制问题:Memory limit (total) exceeded(14890) clickhouse如何修改字段名(10116) Clickhouse批量删除分区(8960) clickhouse如何删除数据库和创建数据库以及分布式DDL创建数据库(6686) clickhouse清空删除表数据(18494) druid执行clickhouse报错:sql injection violation, dbType clickhouse , druid-version 1.2.2, syntax error(9117) Clickhouse2022开源路线图(重大特性的实现蓝图),看看有没有你想要的(1305) clickhouse执行分布式DDL报错:Table `xxx` isn't replicated, but shard #2 is replicated according to its cluster definition(1855) clickhouse如何删除数据(40339) mybatis设置全局变量(3869) 推荐文章 elasticsearch7.1保存时报错: Validation Failed: 1: type is missing;(7) 聊聊数据保存到MySQL后数据乱码的问题(1) solr时区设置解决时间多8小时问题(1) linux下MySQL5.7.18安装过程(1) linux下MySQL5.6.2安装过程(1) spring cloud+feign+mybatis中使用seata0.9实现分布式事务(7) spring cloud gateway报错Only one connection receive subscriber allowed(82) spring cloud中Feign调用诡异报错MethodNotAllowed: status 405 reading(116) 使用spring4实现websocket连接(1) jquery对象与dom对象互转(1) 热门文章 clickhouse如何删除数据(40016) clickhouse清空删除表数据(18228) redis报错远程主机强迫关闭了一个现有的连接以及超时问题(16275) clickhouse执行查询内存超出限制问题:Memory limit (total) exceeded(14617) elasticsearch7.1保存时报错: Validation Failed: 1: type is missing;(11061) clickhouse如何修改字段名(9931) druid执行clickhouse报错:sql injection violation, dbType clickhouse , druid-version 1.2.2, syntax error(8915) Es创建索引mapping时报错:Root mapping definition has unsupported parameters: [doc(8786) Clickhouse批量删除分区(8708) postgresql生成uuid(8257) 标签列表 java java java java java java java基础 微服务 异常处理 mysql clickhouse clickhouse clickhouse clickhouse clickhouse spring cloud spring boot linux elasticsearch feign jdbc spring js docker postgresql solr seata nginx maven gateway hsqldb 数据库 架构 大数据分析 分布式事务 redis canal dubbo hadoop 消息队列 win10 websocket springmvc git html select2 mybatis jenkins rocketmq quartz activemq 数据库集群 ajax bat 电脑 笔记 eclipse 设计模式 阿里云 github freemarker jvm jquery javamail redission redission对象 hystrix http hibernate springmail svn ubuntu ueditor xheditor zookeeper 分布式 小程序 开发工具 gitlab