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