Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to reload the storage_configuration in 23.8 version? #524

Open
zxl-wangwang opened this issue Nov 19, 2024 · 0 comments
Open

How to reload the storage_configuration in 23.8 version? #524

zxl-wangwang opened this issue Nov 19, 2024 · 0 comments
Labels
question Further information is requested

Comments

@zxl-wangwang
Copy link

zxl-wangwang commented Nov 19, 2024

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?

@zxl-wangwang zxl-wangwang added the question Further information is requested label Nov 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

1 participant