citusdata / citusdata/citus

Cascading drop index fails if one of the shard indexes being dropped does not exist

Open
#3,105 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

Replicate by:

Create a huge distributed table (at least 3 shards, 300gb) and put a load on the database.

drop index concurrently some_index;
^C to abort before it's finished (leaves some indexes hanging around).
drop index concurrently some_index;

The second drop index will complain
ERROR: index "some_index_102232" does not exist
CONTEXT: while executing command on citus2.mydomain.com

And will not run until you re-create the subset of indexes that got dropped by the first drop index concurrently.

Expected to happen: Missing shard indexes in a 'drop index' silently ignored (after all, we *want* them to be missing, duh).

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.