citus
citus copied to clipboard
The exception that occurs after the worker node is removed
pg14.4 + citus11.0 : the same machine centos7
-
~/.pgpass is already configured
-
master 5432 create table t1(id int); set citus.shard_count to 2; select create_distributed_table('t1', 'id'); insert into t1 select generate_series(1, 10);
-
Initialize worker 5433
-
The master adds workers and rebalances select citus_add_node('localhost', 5433); SELECT rebalance_table_shards(shard_transfer_mode:='block_writes');
-
The master flows away the above shard and removes the worker select citus_drain_node('localhost', 5433); select citus_remove_node('localhost', 5433);
Note: all of the above are OK
- drop table t1 on the master; but t1 on worker 5433 cannot be deleted and cannot be accessed