Adding new worker to a shard with error

Forum|Forum|1 year ago
November 5, 2024
2 replies
1155 views

Hello,

I'm trying to add a new worker to a shard. The test is successfull but if i try to deploy it i get following error:

ClickHouse provision error: ClickHouse DDL Failure: One of the entries is already present in ClickHouse-Keeper registry. This could happen if a previous instance with the same is not cleaned up from the ClickHouse Keeper registry.
To delete the offending entry, follow Step 8 in Deleting from ClickHouse Cluster section in user guide: https://help.fortinet.com/fsiem/7-0-0/Online-Help/HTML5_Help/clickhouse_config.htm#Advanced.

There is no step 8 in this user guide.

How can i fix this?

Kind regards

Fortisiem

Richie_C

Staff

Hi @MonXbebe

Have you previously removed the worker and tried to re-add it to the cluster? If so, there is a cleanup procedure required to make sure that references to the old worker are deleted.

Or is it a brand new worker?

I would recommend that you look at the following procedures and pick the one that applies to you:

https://help.fortinet.com/fsiem/7-2-4/Online-Help/HTML5_Help/appendix-clickhouse-advanced-operations.htm#Moving

Thanks

MonXbebeAuthor

Explorer

If someone is still facing the same problem:

the solution is simply to:

1. Login via ssh to the supervisor

2. cd /opt/phoenix/phscripts/clickhouse/

3. Run:

./cleanup_clickhouse.sh
./cleanup_clickhouse_keeper.sh

4. Try to configure your cluster again.

Sign up

Login with SSO

Login to the community

Login with SSO