citusdata / citusdata/citus

Concurrent removal of a worker node and a reference table drop fails

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

Description

Setup consists of 4 workers and a reference table.

- Connection 1:
-- Start transaction
-- Remove a worker node, don’t commit
- Connection 2
-- Drop a reference table (gets blocked)
- Connection 1:
-- commit
- Connection 2:
-- Unblocked, fails with an error

```
ERROR: tuple concurrently updated
CONTEXT: SQL statement "SELECT master_drop_all_shards(v_obj.objid, v_obj.schema_name, v_obj.object_name)"
PL/pgSQL function citus_drop_trigger() line 21 at PERFORM
```

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.