在安装和启动ClickHouse时遇到错误,可能是由多种原因造成的。以下是一些常见的错误及其解决方法:1. **依赖问题**: - **错误**:`libssl-dev` 或 `libssl1.1` 等依赖未安装。 - **解决方法**:使用包管理器安装依
摘要:1、启动时报错<Error> Application: DB::Exception: There is no profile 'default' i
1、启动时报错<Error> Application: DB::Exception: There is no profile 'default' in configuration file.->关注清哥聊技术公众号,了解更多技术文章
2021.08.07 15:05:30.719723 [ 1 ] {} <Information> : Starting ClickHouse 19.4.5.35 with revision 54416
2021.08.07 15:05:30.723015 [ 1 ] {} <Information> Application: starting up
2021.08.07 15:05:30.725499 [ 1 ] {} <Trace> Application: Will mlockall to prevent executable memory from being paged out. It may take a few seconds.
2021.08.07 15:05:30.765438 [ 1 ] {} <Trace> Application: The memory map of clickhouse executable has been mlock'ed
2021.08.07 15:05:30.765680 [ 1 ] {} <Debug> Application: rlimit on number of file descriptors is 128000
2021.08.07 15:05:30.765701 [ 1 ] {} <Debug> Application: Initializing DateLUT.
2021.08.07 15:05:30.765718 [ 1 ] {} <Trace> Application: Initialized DateLUT with time zone `PRC'.
2021.08.07 15:05:30.769868 [ 1 ] {} <Debug> ConfigReloader: Loading config `/etc/clickhouse-server/config.xml'
2021.08.07 15:05:30.773574 [ 1 ] {} <Information> Application: Shutting down storages.
2021.08.07 15:05:30.773606 [ 1 ] {} <Debug> Application: Shutted down storages.
2021.08.07 15:05:30.774008 [ 1 ] {} <Debug> Application: Destroyed global context.
2021.08.07 15:05:30.774584 [ 1 ] {} <Error> Application: DB::Exception: There is no profile 'default' in configuration file.
2021.08.07 15:05:30.774617 [ 1 ] {} <Information> Application: shutting down
2021.08.07 15:05:30.774630 [ 1 ] {} <Debug> Application: Uninitializing subsystem: Logging Subsystem
2021.08.07 15:05:30.774735 [ 2 ] {} <Information> BaseDaemon: Stop SignalListener thread
这是因为在config.xml中设置了<default_profile>default</default_profile> 但是并没有在 config.xml中指定<users_config>users.xml</users_config> 这个标签元素,导致
default_profile无法和users.xml 中的default profile 关联起来。
