citusdata / citusdata/citus

shard not found for non-fastpath queries during concurrent create_distributed_table_concurrently execution

Open
#6,360 1 comment 0 reactions 1 assignee Claimed by @aykut-bozkurt View on GitHub
dev_reported enhancement
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

**Problem:** Shards in non-fast-path insert queries may be invalid because they are deleted by a concurrent create_distributed_table_concurrently. Example case:

```sql
session1:
select create_distributed_table_concurrently('xx','id');
```

```sql
session2:
insert into xx select random();
ERROR: could not find valid entry for shard xxx
```

**Expected Solution:** We should reroute invalid shards for those queries to prevent unpleasant error logs and execute the query if possible.

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.