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

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: thunder1(at)126(dot)com
Cc: robertmhaas(at)gmail(dot)com, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [BUG] standby node can not provide service even it replays all log files
Date: 2019-10-29 06:01:23
Message-ID: 20191029.150123.16304488411748728.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mmm..

At Tue, 29 Oct 2019 13:57:19 +0900 (JST), Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> wrote in
> So, somehow we need to complete the KnownAssignedTransactionIds even
> if there's any subxid-overflown transactions. As mentioned upthread,
> I think we have at least the following choices.
>
> - Send back the complete xid list for START REPLICATION command from
> walreceiver.
>
> - The first XLOG_RUNNING_XACTS after a standby comes in while
> subxid-overflown transaction lives.
>
> I think the first is better.
>
> Any suggestions?

On second thought, for the first choice, currently we don't have a
means to recall snapshot at arbitrary checkpoint time so it would be
hard to do that. But the second choice doesn't seem a good way..

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Soumyadeep Chakraborty 2019-10-29 06:58:11 Re: WIP: expression evaluation improvements
Previous Message Dongming Liu 2019-10-29 05:40:41 Re: Problem with synchronous replication