name: DIRECTORY_ALREADY_EXISTS code: 84 value: 8776060 last_error_time: 2024-04-26 12:02:34 last_error_message: Cannot clone part 20240416_1076165_1076248_2 from 'store/fe0/fe059c58-60b0-45bc-9ef3-5d03c1a891df/20240416_1076165_1076248_2/' to 'store/fe0/fe059c58-60b0-45bc-9ef...
--- DB::Exception: user `john`: cannot insert because user `john` already exists in local directory: Couldn't insert user `john`. Successfully inserted: none. 2. 创建角色(Create Role) 创建角色,角色是一组权限。分配了角色的用户获得该角色的所有权限。 CREATE ROLE [IF NOT EXISTS | OR RE...
--- DB::Exception: user `john`: cannot insert because user `john` already exists in local directory: Couldn't insert user `john`. Successfully inserted: none. 2. 创建角色(Create Role) 创建角色,角色是一组权限。分配了角色的用户获得该角色的所有权限。 CREATE ROLE [IF NOT EXISTS | OR RE...
--- DB::Exception: user `john`: cannot insert because user `john` already exists in local directory: Couldn't insert user `john`. Successfully inserted: none. 2. 创建角色(Create Role) 创建角色,角色是一组权限。分配了角色的用户获得该角色的所有权限。 CREATE ROLE [IF NOT EXI...
Code: 253. DB::Exception: Received from localhost:9000. DB::Exception: There was an error on [p0-tklcdh-clickhouse02:9000]: Code: 253. DB::Exception: Replica /clickhouse/tables/01/table_test01/replicas/p0-tklcdh-clickhouse01-01 already exists. (REPLICA_IS_ALREADY_EXIST) (version 22.3.2....
(DIRECTORY_ALREADY_EXISTS)All the time zookeepers are reachable and other 2 replicas of this shard do not reports any issues.In logs I can see:<Warning> stats_s1.invoicing (ReplicatedMergeTreeRestartingThread): Table was in readonly mode. Will try to activate it. ... Directory covered-by-...
clickhouse-backup restore 2021-08-21T06-35-10 -s -d --rm 2021/08/21 14:40:51 error can't create table `default`.`t`: code: 57, message: Directory for table data store/c57/c5780d8a-7d5a-47a3-8578-0d8a7d5a37a3/ already exists after 1 times, please check your schema depencnc...
报错 DB::Exception: Replica xxxxx already exists 。CK会对同一个block保证重复插入的insert的幂等性，会检测重复，默认会去重，使用 insert_deduplicate 配置。如果不需要去重则可以使用 SET insert_deduplicate=0 ，但不推荐这样做。查询超过了限制的时间（60s）,需要优化sql，或者做预聚合 一次写入的...
already exists 使用时 FINAL 和SAMPLE together, e.g. select count() from table final sample 1/2. 修复 #5186. #7907 (尼古拉*科切托夫) 现在表的第一个参数 joinGet 函数可以是表标识符。 #7707 (阿莫斯鸟) 允许使用 MaterializedView 与上面的子查询 Kafka 桌子#8197 (filimonov) 现在后台在磁盘之间...
Fixed "Directory already exists and is not empty" error on detaching broken part that might prevent ReplicatedMergeTree table from starting replication. Fixes #40957. #41981 (Alexander Tokmakov). toDateTime64 now returns the same output with negative integer and float arguments. #42025 (Robert ...