ClickHouse/ClickHouse

BACKUP doesn't work with database engine MaterializedPostgreSQL

已關閉

#44,252 建立於 2022年12月15日

 (1 則留言) (0 個反應) (0 位負責人)C++ (8,400 個分叉)batch import
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

貢獻者指南