服务器突然断电重启，clickhouse启动异常Suspiciously many broken parts to remove

最新推荐文章于 2025-03-06 20:15:18 发布

dkgee

最新推荐文章于 2025-03-06 20:15:18 发布

阅读量602

点赞数 8

CC 4.0 BY-SA版权

文章标签：服务器 clickhouse java

本文链接：https://blog.youkuaiyun.com/TankRuning/article/details/139060329

主要现象：服务器断电重启后，重新启动clickhouse时一直报错，如下：

2024.05.20 10:56:32.882584 [ 221 ] {} <Error> xxx.analys_log (f2a5df75-9220-4ee1-b2a5-df759220cee1): Detaching broken part /var/lib/clickhouse/store/f2a/f2a5df75-9220-4ee1-b2a5-df759220cee1/20240517_17474114_17474119_1. If it happened after update, it is likely because of backward incompability. You need to resolve this manually
2024.05.20 10:56:33.071531 [ 53 ] {} <Error> Application: Caught exception while loading metadata: Code: 231, e.displayText() = DB::Exception: Suspiciously many (45) broken parts to remove.: Cannot attach table `xxx`.`analys_log` from metadata file /var/lib/clickhouse/store/7e0/7e03a687-555f-4282-be03-a687555fb282/analys_log.sql from query ATTACH TABLE XXX.analys_log UUID 'f2a5df75-9220-4ee1-b2a5-df759220cee1' (`xxx` String DEFAULT '', `xxx` String DEFAULT '', `xxx` String DEFAULT '', `xxx` String DEFAULT '', `xxx` String DEFAULT '', `xxx` String DEFAULT '', `xxx` DateTime, `xxx`