Connect state table may not exist on all clickhouse node in cluster

[abhishekgahlot2]

When running multiple clickhouse nodes behind load balancer.

Create connect state table is not created on all nodes or doesn't use ON CLUSTER configuration.

So on some node it may not be able to send data because the table doesn't exist and give error like

 Table default.connect_state does not exist.

[abhishekgahlot2]

Either we can specify on cluster mode here from parameters. i can raise pr if that makes sesnse?

[Paultagoras]

Hmm that's an interesting one - is this on a self-hosted instance?

[abhishekgahlot2]

yup, i had to create this table on self hosted clickhouse cluster to make the connector work.