docker compose start failed, clickhouse is always restarting

[EndlessSeeker]

使用docker compose方式部署，但是clickhouse始终在重启，导致整个coze-loop无法启动成功，报错日志为：

• clickhouse-server --config=/etc/clickhouse-server/config.xml
  Processing configuration file '/etc/clickhouse-server/config.xml'.
  Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
  Logging trace to /var/log/clickhouse-server/clickhouse-server.log
  Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
  Processing configuration file '/etc/clickhouse-server/config.xml'.
  Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
  Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
  Processing configuration file '/etc/clickhouse-server/config.xml'.
  Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
  Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
• init database: clickhouse-client --config <(init_db_client_conf) --query "CREATE DATABASE IF NOT EXISTS cozeloop-clickhouse;"
  Code: 210. DB::NetException: Connection refused (localhost:9008). (NETWORK_ERROR)

[kidkidkid]

Could refer to this issue #31

[EndlessSeeker]

Could refer to this issue #31

这个issue我看ch正常启动起来了，但是我的ch一直在restarting

[kidkidkid]

Could refer to this issue #31

这个issue我看ch正常启动起来了，但是我的ch一直在restarting

和那个issue解法一样， docker logs cozeloop-clickhouse没有错误日志的话，就把sleep时间调整长一些试试。

[vs-ini]

频繁重启

=========================================================================
============================== Starting... ==============================
=========================================================================
+ clickhouse-server --config=/etc/clickhouse-server/config.xml
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
+ init database: clickhouse-client --config <(init_db_client_conf) --query "CREATE DATABASE IF NOT EXISTS `cozeloop-clickhouse`;"
Code: 210. DB::NetException: Connection refused (localhost:9008). (NETWORK_ERROR)

导出日志
docker exec -it cozeloop-clickhouse cat /var/log/clickhouse-server/clickhouse-server.err.log

2025.07.30 04:15:01.169526 [ 202 ] {} <Warning> Application: Calculated checksum of the binary: 5BEBF5792A40F7E345921EDA3698245B. There is no information about the reference checksum.
2025.07.30 04:15:02.180849 [ 202 ] {} <Error> Application: Not found: mark_cache_size

这个错误的问题应该差不多，可能导致clickhouse无法启动的原因有差异，怎么解？

[php-cpm]

+1

[kidkidkid]

+1

也是上面的报错么，有什么额外信息么，系统版本/机器等

[kidkidkid]

频繁重启

=========================================================================
============================== Starting... ==============================
=========================================================================
+ clickhouse-server --config=/etc/clickhouse-server/config.xml
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Logging trace to /var/log/clickhouse-server/clickhouse-server.log
Logging errors to /var/log/clickhouse-server/clickhouse-server.err.log
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
Processing configuration file '/etc/clickhouse-server/config.xml'.
Merging configuration file '/etc/clickhouse-server/config.d/docker_related_config.xml'.
Saved preprocessed configuration to '/var/lib/clickhouse/preprocessed_configs/config.xml'.
+ init database: clickhouse-client --config <(init_db_client_conf) --query "CREATE DATABASE IF NOT EXISTS `cozeloop-clickhouse`;"
Code: 210. DB::NetException: Connection refused (localhost:9008). (NETWORK_ERROR)

导出日志 docker exec -it cozeloop-clickhouse cat /var/log/clickhouse-server/clickhouse-server.err.log

2025.07.30 04:15:01.169526 [ 202 ] {} <Warning> Application: Calculated checksum of the binary: 5BEBF5792A40F7E345921EDA3698245B. There is no information about the reference checksum.
2025.07.30 04:15:02.180849 [ 202 ] {} <Error> Application: Not found: mark_cache_size

这个错误的问题应该差不多，可能导致clickhouse无法启动的原因有差异，怎么解？

您这个之前是不是之前用过clickhouse的镜像，建议重新拉取最新的镜像再试试拉起

[lsy357]

We provided a Docker image and deployment tools based on the image in v1.1.0. You can refer to the documentation and try it out. Please report any issues in the deployment.