clickhouse 重新启动报错解决方案

1. clickhouse 服务重启sudo service clickhouse-server start2. 报错提示Start clickhouse-server service: Poco::Exception. Code: 1000, e.code() = 0,e.displayText() = Exception: Failed to merge config with '/etc/c

IceBear_6

6706人浏览 · 2021-12-20 21:09:35

IceBear_6 · 2021-12-20 21:09:35 发布

1. clickhouse 服务重启

sudo service clickhouse-server start

2. 报错提示

Start clickhouse-server service: Poco::Exception. Code: 1000, e.code() = 0, 
e.displayText() = Exception: Failed to merge config with '/etc/clickhouse-server/config.d/metric_log.xml': 
Exception: Root element doesn't have the corresponding root element as the config file. 
It must be <yandex> (version 21.3.4.25 (official build))
Cannot obtain value of path from config file: /etc/clickhouse-server/config.xml

3. 问题分析

启动clickhouse服务器服务异常。无法将配置与’/etc/clickhouse server/config合并。根元素没有相应的根元素作为配置文件。它必须是（版本21.3.4.25（官方版本））无法从配置文件：/etc/clickhouse server/config.xml获取路径值

翻译过来大概就是，/etc/clickhouse-server/config.d/metric_log.xml 这个xml配置文件里面的内容无法正确解析，官方版本21.3.4.25要求配置文件内容需要在标签里面。

4. 解决方案

# 打开文件 /etc/clickhouse-server/config.d/metric_log.xml
vi /etc/clickhouse-server/config.d/metric_log.xml

# 修改前metric_log.xml文件内容
<clickhouse>
    <metric_log>
        <database>system</database>
        <table>metric_log</table>
        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
        <collect_interval_milliseconds>1000</collect_interval_milliseconds>
    </metric_log>
</clickhouse>
# 修改文件内容，将其放到<yandex>标签中
# 修改后metric_log.xml文件内容
<yandex>
	<clickhouse>
	    <metric_log>
	        <database>system</database>
	        <table>metric_log</table>
	        <flush_interval_milliseconds>7500</flush_interval_milliseconds>
	        <collect_interval_milliseconds>1000</collect_interval_milliseconds>
	    </metric_log>
	</clickhouse>
</yandex>

# 修改后保存，重新启动
sudo service clickhouse-server start
# 执行后提示
Start clickhouse-server service: Path to data directory in /etc/clickhouse-server/config.xml: /data/clickhouse/
DONE