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 test01DETACH PARTITION 6Received 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_13820_13820_0/. 0 rows in set. Elapsed: 0.015 sec.2、去/data/clickhouse/data/wd/test01/ 創建 6_13820_13820_0 3、分區剝離 dn06 :) alter table test01 deTACH partition 6; 4、分區恢復alter table test01 ATTACH partition 6;ALTER TABLE test01ATTACH PARTITION 6Received exception from server (version 20.8.7): Code: 226. DB::Exception: Received from dn06:9001. DB::Exception: No columns in part 6_13820_13820_0. 0 rows in set. Elapsed: 0.006 sec. 5、去/data/clickhouse/data/wd/test01/detachted下 刪除 6_13820_13820_0 6、分區恢復 alter table test01 ATTACH partition 6;ALTER TABLE test01ATTACH PARTITION 6Ok.0 rows in set. Elapsed: 0.010 sec. 7、select count(*) from test01 where mode = 6;SELECT count(*) FROM test01 WHERE mode = 6┌─count()─┐ │ 7593811 │ └─────────┘

總結

以上是生活随笔為你收集整理的clcikhouse Code: 1000. DB::Exception: File not found的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。