【ClickHouse】＜Error＞ Application: Caught exception while loading metadata: Code: 231. DB::Exception

最新推荐文章于 2024-05-12 19:58:27 发布

图腾还未停下

最新推荐文章于 2024-05-12 19:58:27 发布

阅读量2k

点赞数

分类专栏： clickhouse 文章标签：数据库 clickhouse mysql

本文链接：https://blog.csdn.net/weixin_42270217/article/details/126406534

版权

clickhouse 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

异常描述

重启clickhouse后，发现服务一直不可用，日志报错：

 <Error> Application: Caught exception while loading metadata: Code: 231. DB::Exception: Suspiciously big size (2 parts, 10.25 GiB in total) of all broken parts to remove while maximum allowed broken parts size is 1.00 GiB. 
 You can change the maximum value with merge tree setting 'max_suspicious_broken_parts_bytes' in <merge_tree> configuration section or in table settings in.sql file (don't forget to return setting back to default value):
  Cannot attach table `db`.`tabele` from metadata file /data1/clickhouse/store/c46/c460fc04-b810-4e3e-92a6-8234a00b6b1e/table.sql from query ATTACH TABLE db.table UUID 'e4601526-e850-454f-b081-d7b4e337a826'

原因解析

查找要原因是因为在重启clickhouse这段时间内，副本表写入了大量数据，造成该节点跟副本数据块差距过大无法正常恢复。
可以调整max_suspicious_broken_parts_bytes跟max_suspicious_broken_parts的参数来解决
参数官网地址：https://clickhouse.com/docs/en/operations/settings/merge-tree-settings/#max_suspicious_broken_parts_bytes

解决方法

在clickhouse的config.xml里添加下面内容

    <merge_tree>
        <max_suspicious_broken_parts>1000</max_suspicious_broken_parts>
        <max_suspicious_broken_parts_bytes>107374182400</max_suspicious_broken_parts_bytes>
    </merge_tree>

重启Clickhouse 问题解决
systemctl restart clickhouse-server.service