Re: Index maintenance function for BRIN doesn't check RecoveryInProgress()

Поиск
Список
Период
Сортировка
От Kuntal Ghosh
Тема Re: Index maintenance function for BRIN doesn't check RecoveryInProgress()
Дата
Msg-id CAGz5QC+uibv8bt+befZDuoT5pDqRcU=nHZ9EF1w1ygL6btf8Ww@mail.gmail.com
обсуждение исходный текст
Ответ на Index maintenance function for BRIN doesn't check RecoveryInProgress()  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: Index maintenance function for BRIN doesn't check RecoveryInProgress()  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Список pgsql-hackers
On Wed, Jun 13, 2018 at 2:28 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
> 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.
+1



-- 
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Index maintenance function for BRIN doesn't check RecoveryInProgress()
Следующее
От: Marina Polyakova
Дата:
Сообщение: Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors