本文均为公司实际线上业务遇到的问题,视遇到问题的情况持续更新
启动报错 broken parts to remove
<Error> Application: DB::Exception: Suspiciously many (346) broken parts to remove.: Cannot attach table * from metadata file
通常是服务器意外重启(例如断电)导致的文件损坏导致,通过调整max_suspicious_broken_parts
的值来强制启动。
扩展阅读:[max_suspicious_broken_parts](https://clickhouse.com/docs/en/operations/settings/merge-tree-settings/#max_suspicio...