clickhouse-operator: ReplicateTable are not getting created in the new Replica

Whenever we increase replication, from operator logs i see that it’s running below query to find which tables to create in new replica

 SELECT DISTINCT
        database AS name,
        concat('CREATE DATABASE IF NOT EXISTS ', name) AS create_db_query

It often results in a message like

Creating replicated objects: []

Even though there are many replicated tables, it doesn’t create any. Manually running the generated query in clickhouse gives the correct result.

Can someone point out what may be the issue here?

About this issue

  • Original URL
  • State: closed
  • Created 4 years ago
  • Comments: 17 (7 by maintainers)

Most upvoted comments

@phatak-dev , that could be an issue with the old ClickHouse version you are using.

We recommend using Altinity stable versions, see releases there: https://www.altinity.com/blog/tag/Releases

We have not tested operator extensively for ClickHouse before 19.11 version. I will test with 19.6.2.11 to see if we can reproduce the problem.