• Michael Paquier's avatar
    Reset indisreplident for an invalid index in DROP INDEX CONCURRENTLY · 9511fb37
    Michael Paquier authored
    A failure when dropping concurrently an index used in a replica identity
    could leave in pg_index an index marked as !indisvalid and
    indisreplident.  Reindexing this index would switch back indisvalid to
    true, and if the replica identity of the parent relation was switched to
    use a different index, it would be possible to finish with more than one
    index marked as indisreplident.  If that were to happen, this could mess
    up with the relation cache as an incorrect index could be used for the
    replica identity.
    
    Indexes marked as invalid are discarded as candidates for the replica
    identity, as of RelationGetIndexList(), so similarly to what is done
    with indisclustered, resetting indisreplident when the index is marked
    as invalid keeps things consistent.  REINDEX CONCURRENTLY's swapping
    already resets the flag for the old index, while the new index inherits
    the value of the old index to-be-dropped, so only DROP INDEX was an
    issue.
    
    Even if this is a bug, the sequence able to reproduce a problem requires
    a failure while running DROP INDEX CONCURRENTLY, something unlikely
    going to happen in the field, so no backpatch is done.
    
    Author: Michael Paquier
    Reviewed-by: Dmitry Dolgov
    Discussion: https://postgr.es/m/20200827025721.GN2017@paquier.xyz
    9511fb37
index.c 127 KB