Adding new worker to a shard with error

[MonXbebe]

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

[Richie_C]

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...

Thanks

[MonXbebe]

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.