Re: [BUG] standby node can not provide service even it replays alllog files

Поиск
Список
Период
Сортировка
От Kyotaro Horiguchi
Тема Re: [BUG] standby node can not provide service even it replays alllog files
Дата
Msg-id 20191023.131827.2210460300407362091.horikyota.ntt@gmail.com
обсуждение исходный текст
Ответ на Re: [BUG] standby node can not provide service even it replays alllog files  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
At Wed, 23 Oct 2019 12:51:19 +0900 (JST), Kyotaro Horiguchi <horikyota.ntt@gmail.com> wrote in 
> Hello.
> 
> At Tue, 22 Oct 2019 20:42:21 +0800 (CST), Thunder  <thunder1@126.com> wrote in 
> > Update the patch.
> > 
> > 1. The STANDBY_SNAPSHOT_PENDING state is set when we replay the first XLOG_RUNNING_XACTS and the sub transaction
idsare overflow.
 
> > 2. When we log XLOG_RUNNING_XACTS in master node, can we assume that all xact IDS < oldestRunningXid are considered
finished?
> 
> Unfortunately we can't. Standby needs to know that the *standby's*
> oldest active xid exceeds the pendig xmin, not master's. And it is
> already processed in ProcArrayApplyRecoveryInfo. We cannot assume that
> the oldest xids are not same on the both side in a replication pair.

Could we send a full xid list after new standby comes in? Or can
START_REPLICATION return it?

regards.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] Do not use StdRdOptions in Access Methods
Следующее
От: vignesh C
Дата:
Сообщение: Re: Ordering of header file inclusion