主要现象:服务器断电重启后,重新启动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`