citusdata / citusdata/citus

master_copy_shard_placement() ignores DEFAULT PRIVILEGES IN SCHEMA

Open
#3,394 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

When I use master_copy_shard_placement() to recover a broken shard, the new shard is created without the default privileges defined in the schema.
In my particular case I am also working with a partitioned table.
As updates to the parent table are coming in during the master_copy_shard_placement() operation, the new shard immediately fails with a permission error.
I can work around the issue by locking the parent table, doing the copy operation, and manually setting the correct permissions. I am running Citusdata 8.1 and postgresql 11.1.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.