ClickHouse 无法启动


问题描述

今天修改了clickhouse的配置之后, clickhouse就无法启动了, 启动之后日志也不打印任何信息

# 下面的命令 无法启动 clickhous
systemctl start clickhouse-server

查看clickhouse 状态

[root@node2 clickhouse-server]# sudo systemctl status clickhouse-server
● clickhouse-server.service - ClickHouse Server (analytic DBMS for big data)
   Loaded: loaded (/etc/systemd/system/clickhouse-server.service; enabled; vendor preset: disabled)
   Active: activating (auto-restart) (Result: exit-code) since 二 2021-04-19 17:10:44 CST; 3s ago
  Process: 8933 ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=/run/clickhouse-server/clickhouse-server.pid (code=exited, status=232/ADDRESS_FAMILIES)
 Main PID: 8933 (code=exited, status=232/ADDRESS_FAMILIES)

4月 19 17:10:44 node2 systemd[1]: Unit clickhouse-server.service entered failed state.
4月 19 17:10:44 node2 systemd[1]: clickhouse-server.service failed.

查看日志

[root@node2 clickhouse-server]# clickhouse-server --config-file=/etc/clickhouse-server/config.xml
Processing configuration file '/etc/clickhouse-server/config.xml'.
Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = SAXParseException: Tag mismatch in '/etc/clickhouse-server/config.xml', line 522 column 8, Stack trace (when copying this message, always include the lines below):

0. Poco::XML::SAXParseException::SAXParseException(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, Poco::XML::Locator const&) @ 0x12795b3e in /usr/bin/clickhouse
1. Poco::XML::ParserEngine::handleError(int) @ 0x1279e1d8 in /usr/bin/clickhouse
2. Poco::XML::ParserEngine::parseByteInputStream(std::__1::basic_istream<char, std::__1::char_traits<char> >&) @ 0x1279d20e in /usr/bin/clickhouse
3. Poco::XML::ParserEngine::parse(Poco::XML::InputSource*) @ 0x1279c8b7 in /usr/bin/clickhouse
4. Poco::XML::SAXParser::parse(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x12798bb9 in /usr/bin/clickhouse
5. Poco::XML::DOMBuilder::parse(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x1277bb48 in /usr/bin/clickhouse
6. Poco::XML::DOMParser::parse(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&) @ 0x1277a723 in /usr/bin/clickhouse
7. DB::ConfigProcessor::processConfig(bool*, zkutil::ZooKeeperNodeCache*, std::__1::shared_ptr<Poco::Event> const&) @ 0x103a299e in /usr/bin/clickhouse
8. DB::ConfigProcessor::loadConfig(bool) @ 0x103a52e2 in /usr/bin/clickhouse
9. BaseDaemon::reloadConfiguration() @ 0x8a6f0be in /usr/bin/clickhouse
10. BaseDaemon::initialize(Poco::Util::Application&) @ 0x8a70cbe in /usr/bin/clickhouse
11. DB::Server::initialize(Poco::Util::Application&) @ 0x8928060 in /usr/bin/clickhouse
12. Poco::Util::Application::run() @ 0x12750876 in /usr/bin/clickhouse
13. DB::Server::run() @ 0x8927ecf in /usr/bin/clickhouse
14. mainEntryClickHouseServer(int, char**) @ 0x8926b45 in /usr/bin/clickhouse
15. main @ 0x88b114e in /usr/bin/clickhouse
16. __libc_start_main @ 0x22555 in /usr/lib64/libc-2.17.so
17. _start @ 0x887c3ee in /usr/bin/clickhouse
 (version 21.4.3.21 (official build))

问题定位

看日志, 应该是配置的 config.xml 文件解析异常, 我们到config.xml对应的行去检查一下。

解决问题

. . . 省略 . . .
    <two_shard>
      <shard>
        <replica>
          <host>node3</host>
          <port>9977</port>
        </replica>
      </shard>
      <shard>
        <replica>
          <host>node2</host>
          <port>9977</port><!-- 这里下面少了一个 <replica> 补上之后再次启动-->
      </shard>
    </two_shard>
. . . 省略 . . .

文章作者: hnbian
版权声明: 本博客所有文章除特別声明外,均采用 CC BY 4.0 许可协议。转载请注明来源 hnbian !
评论
 上一篇
ClickHouse系列教程 4. 数据类型介绍 1. 基本数据类型 ClickHouse系列教程 4. 数据类型介绍 1. 基本数据类型
1. 数据类型介绍ClickHouse 可以在数据表中存储多种数据类型。本节描述 ClickHouse 支持的数据类型,以及使用或者实现它们时(如果有的话)的注意事项。你可以在系统表 system.data_type_families 中检
2021-04-20
下一篇 
ClickHouse系列教程 3. 架构与组件介绍 ClickHouse系列教程 3. 架构与组件介绍
1. 集群结构ClickHouse 采用了 Multi Master 多主架构,集群中的每个节点角色对等,客户端访问任意一个节点都能得到相同的效果。 多主架构中每个节点对等的角色使系统架构变得更加简单,不用再区分主控节点、数据节点和计算节点
2021-04-17
  目录