ClickHouse/ClickHouse
BACKUP doesn't work with database engine MaterializedPostgreSQL
已關閉
#44,252 建立於 2022年12月15日
help wantedminorunfinished code
倉庫指標
- 星標
- (47,419 顆星)
- PR 合併指標
- (平均合併 2天 2小時) (30 天內合併 1,000 個 PR)
描述
Describe what's wrong PostgreSQL
echo 'CREATE DATABASE ch_pgsql_repl' | PGPASSWORD=root psql -v ON_ERROR_STOP=1 -U root
CREATE DATABASE
echo "CREATE TABLE t1 (id BIGINT PRIMARY KEY, s VARCHAR(255)); INSERT INTO t1(id, s) VALUES(1,'s1'),(2,'s2'),(3,'s3')" | PGPASSWORD=root psql -v ON_ERROR_STOP=1 -U root -d ch_pgsql_repl
CREATE TABLE
INSERT 0 3
ClickHouse
CREATE DATABASE ch_pgsql_repl ENGINE=MaterializedPostgreSQL('pgsql:5432','ch_pgsql_repl','root','root')
SETTINGS materialized_postgresql_allow_automatic_update = 1, materialized_postgresql_schema = 'public';
SHOW TABLES FROM ch_pgsql_repl;
┌─name─┐
│ t1 │
└──────┘
BACKUP DATABASE ch_pgsql_repl TO File('ch_pgsql_repl.zip');
Query id: d9df1341-64dd-4335-88c4-ad55e99c7854
// query stuck
tail -f /var/log/clickhouse-server/clickhouse-server.err.log inifinte messages
<Warning> BackupEntriesCollector: DB::Exception: Table ch_pgsql_repl.t1 were created or changed its definition during scanning
KILL QUERY WHERE query_id='d9df1341-64dd-4335-88c4-ad55e99c7854' also doesn't work
Does it reproduce on recent release?
Yes, tested on Head and 22.11
Expected behavior
Successful backup, Inside database we just have ReplacingMergeTree(_version) table