Re: [HACKERS] More replication race conditions

Поиск
Список
Период
Сортировка
От Petr Jelinek
Тема Re: [HACKERS] More replication race conditions
Дата
Msg-id 17652eff-80b5-0e93-ccd5-37e1b58d7ec7@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] More replication race conditions  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
On 28/08/17 01:36, Michael Paquier wrote:
> On Sun, Aug 27, 2017 at 6:32 PM, Petr Jelinek
> <petr.jelinek@2ndquadrant.com> wrote:
>> Attached should fix this.
> 
> +$node_master->poll_query_until('postgres',
> +"SELECT EXISTS (SELECT 1 FROM pg_replication_slots WHERE slot_name =
> 'test_slot' AND active_pid IS NULL)"
> +)
> +  or die "slot never became inactive";
> +
>  $stdout_recv = $node_master->pg_recvlogical_upto(
> I am wondering if a similar check should actually go into
> pg_recvlogical_upto() instead. I tend to think that we've learned
> things the hard way with 3043c1dd and such.
> 

Putting it there can lead to tests that take forever to finish if
written incorrectly. This way they at least just fail.

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [HACKERS] More replication race conditions
Следующее
От: Michael Malis
Дата:
Сообщение: Re: [HACKERS] Re: Poor cost estimate with interaction between tablecorrelation and partial indexes