Skip to content

How to reload the storage_configuration in 23.8 version? #524

@zxl-wangwang

Description

@zxl-wangwang

Env :

I created a new policy in the 23.8 version directory /etc/clickhouse-server/config.d as follows:

截屏2024-11-19 16 29 36

The log also shows that zxlpolicy1 is loaded.

截屏2024-11-19 16 30 05

You can also check the system table storage_policies.

截屏2024-11-19 16 32 22

Question:

Based on the above, I delete zxlpolicy1 and create a new zxlpolicy2. The service log shows that zxlpolicy2 is loaded, but there is no zxlpolicy2 in system.storage_policies.
image

clickhouse-server log:

image

system.storage_policies:

截屏2024-11-19 16 37 17

I have to restart the cluster system table to load zxlpolicy2.

How can I get the system tables to load into zxlpolicy2 without restarting the cluster?

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions