暂无图片
clickhouse 安装后启动不了
我来答
分享
Thomas
2024-04-11
clickhouse 安装后启动不了

https://www.atlantic.net/dedicated-server-hosting/how-to-install-clickhouse-on-oracle-linux-8/

参照此文装的CLICKHOUSE, OS是ORACLE LINUX 9, 但无法启动clickhouse-server, 报错如下

root@localhost /]# systemctl status clickhouse-server
○ clickhouse-server.service
Loaded: bad-setting (Reason: Unit clickhouse-server.service has a bad unit file setting.)
Active: inactive (dead)

Apr 11 16:00:06 localhost.localdomain systemd[1]: /usr/lib/systemd/system/clickhouse-server.service:1: Assignment outside of section. Ignoring.
Apr 11 16:00:06 localhost.localdomain systemd[1]: clickhouse-server.service: Service has no ExecStart=, ExecStop=, or SuccessAction=. Refusing.

看到配置文件下,只有systemctl daemon-reload一行,应该内容不全吧。如何补全它?
[root@localhost /]# cat /usr/lib/systemd/system/clickhouse-server.service
systemctl daemon-reload

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
Thomas

期待解答中

暂无图片 评论
暂无图片 有用 0
打赏 0
一般

你是安装的哪个版本?我找一个对应的clickhouse-server.service给你,下面是clickhouse-server-24.3.2.23.x86_64.rpm的,你可以试试

[Unit]
Description=ClickHouse Server (analytic DBMS for big data)
Requires=network-online.target
# NOTE: that After/Wants=time-sync.target is not enough, you need to ensure
# that the time was adjusted already, if you use systemd-timesyncd you are
# safe, but if you use ntp or some other daemon, you should configure it
# additionaly.
After=time-sync.target network-online.target
Wants=time-sync.target

[Service]
Type=notify

# NOTE: we leave clickhouse watchdog process enabled to be able to see OOM/SIGKILL traces in clickhouse-server.log files.
# If you wish to disable the watchdog and rely on systemd logs just add "Environment=CLICKHOUSE_WATCHDOG_ENABLE=0" line.
User=clickhouse
Group=clickhouse
Restart=always
RestartSec=30
# The following ClickHouse directives should be used instead of forcing SIGKILL by systemd:
# - shutdown_wait_unfinished_queries
# - shutdown_wait_unfinished
TimeoutStopSec=infinity
# Disable forwarding signals by watchdog, since with default systemd's
# kill-mode control-group, systemd will send signal to all process in cgroup.
Environment=CLICKHOUSE_WATCHDOG_NO_FORWARD=1
# Since ClickHouse is systemd aware default 1m30sec may not be enough
TimeoutStartSec=0
# %p is resolved to the systemd unit name
RuntimeDirectory=%p
ExecStart=/usr/bin/clickhouse-server --config=/etc/clickhouse-server/config.xml --pid-file=%t/%p/%p.pid
# Minus means that this file is optional.
EnvironmentFile=-/etc/default/%p
# Bring back /etc/default/clickhouse for backward compatibility
EnvironmentFile=-/etc/default/clickhouse
LimitCORE=infinity
LimitNOFILE=500000
CapabilityBoundingSet=CAP_NET_ADMIN CAP_IPC_LOCK CAP_SYS_NICE CAP_NET_BIND_SERVICE
AmbientCapabilities=CAP_NET_ADMIN CAP_IPC_LOCK CAP_SYS_NICE CAP_NET_BIND_SERVICE

[Install]
# ClickHouse should not start from the rescue shell (rescue.target).
WantedBy=multi-user.target

暂无图片 评论
暂无图片 有用 0
打赏 0
Thomas

谢谢,我试下

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
clickhouse查询跟删除表卡主
回答 1
使用rename table方式解决,咨询clickhouse GitHub 建议使用升级版本
clickhouse权限问题
回答 3
在ClickHouse中,您应该使用单引号括起来的通配符''。正确的GRANT语句应该类似于以下形式:GRANTSELECTONtest.chTOtemp;请确保在test数据库和ch之间使用反引号(
MergeTree存储引擎的三大特点是什么?
回答 2
已采纳
MergeTree存储引擎区别于其他数据存储引擎的关键设计理念是存储服务于计算。MergeTree存储引擎中的数据组织形式、堆放方式、压缩方式都是为计算引擎特殊设计的。反观SparkHDFS等大数据技
greenplum数据迁移至clickhouse
回答 1
4、使用clickhouse自带的数据导入工具clickhouseclient,通过命令行将数据从gp导入至clickhouse。5、使用第三方工具,如ApacheNifi、ApacheKafka等,
Clickhouse已存在的表怎么加索引?
回答 1
已采纳
ALTERTABLE[db].nameADDINDEXnameexpressionTYPEtypeGRANULARITYvalueAFTERname[AFTERname2]加索引参考资料https:/
clickhouse副本集重复数据的疑问
回答 1
查了资料,insert的幂等性,SETinsertdeduplicate0就可以了,开始没找到
ClickHouse数据库的存储引擎是如何影响查询速度的?
回答 1
已采纳
ClickHouse速度快的秘诀在于利用存储引擎的特殊设计充分减少磁盘I/O对查询速度的影响。从用户提交一条SQL语句进行查询到最终输出结果的过程中,大量的时间是消耗在了磁盘I/O上,在很多情况下,I
clickhouse 查询视图需要给基表的权限,有什么办法能场查视图不能查表呢?
回答 2
可能我没说明白, clickouse在给用户查询视图权限后,还需要给表的查询权限,用户才能查询视图,否则回报权限不够的错误。这种情况,用户可以绕过视图直接查表了,我的需求是只能查视图,不要查
clickhouse中频繁出现Transaction failed (No node): Op #0, path:报错的问题
回答 3
已采纳
原因文件drop表后,删除zk相关数据,然后立刻重建表,在5min后,zk中的task,将zk中数据删除
clickhouse 500亿数据
回答 1
在这种情况下,更倾向于选择第二种方案:300亿数据,5个字段,有删改需求。原因如下:数据规模控制: 第一种方案虽然有更多的字段,但是字段数目较多并且后期可能要添加字段,这可能导致数据结构更为