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

2019-10-28 Thread Kyotaro Horiguchi
Mmm.. At Tue, 29 Oct 2019 13:57:19 +0900 (JST), Kyotaro Horiguchi 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 complet

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

2019-10-28 Thread Kyotaro Horiguchi
At Thu, 24 Oct 2019 17:37:52 +0800 (CST), Thunder wrote in > Thanks for replay.I feel confused about snapshot. > > At 2019-10-23 11:51:19, "Kyotaro Horiguchi" wrote: > >Hello. > > > >At Tue, 22 Oct 2019 20:42:21 +0800 (CST), Thunder wrote > >in > >> Update the patch. > >> > >> 1. The STAN

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

2019-10-22 Thread Kyotaro Horiguchi
At Wed, 23 Oct 2019 12:51:19 +0900 (JST), Kyotaro Horiguchi wrote in > Hello. > > At Tue, 22 Oct 2019 20:42:21 +0800 (CST), Thunder 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

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

2019-10-22 Thread Kyotaro Horiguchi
Hello. At Tue, 22 Oct 2019 20:42:21 +0800 (CST), Thunder 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 ids are overflow. > 2. When we log XLOG_RUNNING_XACTS in master node, can we assume that

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

2019-10-21 Thread Robert Haas
On Mon, Oct 21, 2019 at 4:13 AM Thunder wrote: > Can we fix this issue like the following patch? > > $git diff src/backend/access/transam/xlog.c > diff --git a/src/backend/access/transam/xlog.c > b/src/backend/access/transam/xlog.c > index 49ae97d4459..0fbdf6fd64a 100644 > --- a/src/backend/acces

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

2019-10-21 Thread Thunder
Can we fix this issue like the following patch? $git diff src/backend/access/transam/xlog.c diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c index 49ae97d4459..0fbdf6fd64a 100644 --- a/src/backend/access/transam/xlog.c +++ b/src/backend/access/transam/xlog.c @@