Clickhouse: CH complains when create a table : DB::Exception: Existing table metadata in ZooKeeper differs in primary key. Stored in ZooKeeper: name, tags, ts, local: name, ts.

[Johnny-Three]

I drop the table before and I rebuild it with another primary key .
CH says the different primary key exists in the ZK.
Should I clean the meta data as the time when drop a table ?
If have to , what is the right way to do this ?

[filimonov]

Did you drop it on all the replicas?

[Johnny-Three]

no . I have two shards and each shard has two replicas.
Only one shard's replica's table is dropped.

[filimonov]

And that is the reason. If you will drop table on all the replicas then table metadata will be removed from zookeeper. Till that moment any attempts to create table on the same zookeeper path will be considered as attempts to make another replica of that table (and all table replicas should have the same structure).

[Johnny-Three]

thanks I'll have a try .

[alexey-milovidov]

@filimonov :+1: