Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.
Дата
Msg-id 20210531.171842.1230966476067802582.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Ответы Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing.  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-hackers
Sorry for missing this.

At Mon, 31 May 2021 12:52:54 +0900, Fujii Masao <masao.fujii@oss.nttdata.com> wrote in
>
> On 2021/05/19 19:24, Fujii Masao wrote:
> > On 2021/05/19 16:43, Kyotaro Horiguchi wrote:
> >> +1 for adding some tests for pg_wal_replay_pause() but the test seems
> >> like checking only that pg_get_wal_replay_pause_state() returns the
> >> expected state value.  Don't we need to check that the recovery is
> >> actually paused and that the promotion happens at expected LSN?
> > Sounds good. Attached is the updated version of the patch.
> > I added such checks into the test.

Thanks! Looks fine. The paused-state test may get false-success but it
would be sufficient that it detects the problem in most cases.

> > BTW, while reading some recovery regression tests, I found that
> > 013_crash_restart.pl has "use Time::HiRes qw(usleep)" but it seems
> > not necessary. We can safely remove that? Patch attached.

Looks just fine for the removal of HiRes usage.  All other use of
HiRes are accompanied by a usleep usage.

> Barring any objections, I'm thinking to commit these two patches.

+1.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: Race condition in recovery?
Следующее
От: Zhihong Yu
Дата:
Сообщение: Re: why is the permission granted in a non-recursive way and what are the benefits