Index maintenance function for BRIN doesn't check RecoveryInProgress() - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Index maintenance function for BRIN doesn't check RecoveryInProgress()
Date
Msg-id CAD21AoBZau4g4_NUf3BKNd=CdYK+xaPdtJCzvOC1TxGdTiJx_Q@mail.gmail.com
Whole thread Raw
Responses Re: Index maintenance function for BRIN doesn't check RecoveryInProgress()
List pgsql-hackers
Hi,

Three functions: brin_summarize_new_values, brin_summarize_range and
brin_desummarize_range can be called during recovery as follows.

=# select brin_summarize_new_values('a_idx');
ERROR:  cannot acquire lock mode ShareUpdateExclusiveLock on database
objects while recovery is in progress
HINT:  Only RowExclusiveLock or less can be acquired on database
objects during recovery.

I think we should complaint "recovery is in progress" error in this
case rather than erroring due to lock modes.
Attached patch fixes them.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Duplicate Item Pointers in Gin index
Next
From: Kuntal Ghosh
Date:
Subject: Re: Index maintenance function for BRIN doesn't check RecoveryInProgress()