Code: 1000. DB::Exception: Received from dn06:9001. DB::Exception: File not found: /data/clickhouse/data/wd/teat01/6_14710_14710_0/mode.mrk2.
初步判断是数据写入过快,导致合并出现问题,数据总量是没有问题的。
解决方法:
dn06 :) select count(*) from test01 where mode = 6;
SELECT count(*)
FROM test01
WHERE mode = 6
→ Progress: 720.55 thousand rows, 720.55 KB (5.92 million rows/s., 5.92 MB/s.)
Received exception from server (version 20.8.7):
Code: 1000. DB::Exception: Received from dn06:9001. DB::Exception: File not found: /data/clickhouse/data/wd/test01/6_14710_14710_0/mode.mrk2.
0 rows in set. Elapsed: 0.124 sec. Processed 720.55 thousand rows, 720.55 KB (5.81 million rows/s., 5.81 MB/s.)
1、分区剥离
dn06 :) alter table test01 deTACH partition 6;
ALTER TABLE test01
DETACH PARTITION 6
Received exception from server (version 20.8.7):
Code: 1000. DB::Exception: Received from dn06:9001. DB::Exception: File not found: /data/clickhouse/data/wd/t