clcikhouse Code: 1000. DB::Exception: File not found

My_Fresh_Start

于 2021-01-31 11:28:08 发布

阅读量1k

点赞数

分类专栏：大数据 cickhouse 文章标签：大数据

本文链接：https://blog.csdn.net/Xwxcy/article/details/113462721

版权

博客探讨了ClickHouse在处理大数据时遇到的问题，具体表现为Code: 1000错误，DB::Exception提示文件未找到。内容指出可能是由于数据写入速度过快，引发合并过程中的问题，但总数据量是正常的。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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