citus icon indicating copy to clipboard operation
citus copied to clipboard

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

Open aykut-bozkurt opened this issue 2 years ago • 1 comments

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

session1:
select create_distributed_table_concurrently('xx','id');
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.

aykut-bozkurt avatar Sep 21 '22 15:09 aykut-bozkurt

Related to #6280

onderkalaci avatar Sep 21 '22 15:09 onderkalaci