Acquire properly session-level lock on new index in REINDEX CONCURRENTLY In the first transaction run for REINDEX CONCURRENTLY, a thinko in the existing logic caused two session locks to be taken on the old index, causing the session lock on the newly-created index to be missed. This made possible concurrent DDL commands (like ALTER INDEX) on the new index while REINDEX CONCURRENTLY was processing from the point where the first internal transaction committed.
This issue has been discovered while digging into another bug. Author: Michael Paquier Discussion: https://postgr.es/m/[email protected] Backpatch-through: 12 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/5d3500da72611018f2280d6a31e58ccdb4b16152 Modified Files -------------- src/backend/commands/indexcmds.c | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-)
