Re: streaming replication master can fail to shut down - Mailing list pgsql-bugs

From Andres Freund
Subject Re: streaming replication master can fail to shut down
Date
Msg-id 20160429033818.57elicwvviugfwyv@alap3.anarazel.de
Whole thread Raw
In response to Re: streaming replication master can fail to shut down  (Nick Cleaton <nick@cleaton.net>)
Responses Re: streaming replication master can fail to shut down
Re: streaming replication master can fail to shut down
List pgsql-bugs
On 2016-04-28 20:04:21 +0100, Nick Cleaton wrote:
> On 28 April 2016 at 19:14, Andres Freund <andres@anarazel.de> wrote:
> >
> >> in this test the server sent only 29 keepalives during the shutdown:
> >> http://nick.cleaton.net/protodump-100k-nossl-patched.xz (47k)
> >
> > I guess you have a fair amount of WAL traffic, and the receiver was
> > behind a good bit?
>
> No, IIRC this was on the test cluster that I installed for the purpose
> of replicating the problem under 9.5; it was essentially idle.

The reason I'm asking is that I so far can't really replicate the issue
so far. It's pretty clear that waiting_for_ping_response = true; is
needed, but I'm suspicious that that's not all.

Was your standby on a separate machine? What kind of latency?

Andres

pgsql-bugs by date:

Previous
From: kayzizz@gmail.com
Date:
Subject: BUG #14120: Documentation suggestion 35.4.2
Next
From: Nick Cleaton
Date:
Subject: Re: streaming replication master can fail to shut down