shard not found for non-fastpath queries during concurrent create_distributed_table_concurrently execution
Open
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
Assessment
This issue has not been assessed yet.