Postgres Pro
Downloads
Home   >   mailing lists

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

From Nick Cleaton
Subject Re: streaming replication master can fail to shut down
Date
Msg-id CAFgz3ku+LqHBfxQVJP5FWcOsyHL3x7hO-yOLk7ZU_xoqewLNmA@mail.gmail.com
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
List pgsql-bugs
Tree view 
On 10 March 2016 at 13:13, Nick Cleaton <nick@cleaton.net> wrote:

> ... and everything following that is a storm of:
>
> Packet: t=1457611872.761098, session=17578864249730
> PGSQL: type=PrimaryKeepalive, B -> F
> PRIMARY KEEP-ALIVE
>
> Packet: t=1457611872.761221, session=17578864249730
> PGSQL: type=StandbyStatusUpdate, F -> B
> STANDBY STATUS UPDATE
>
> Packet: t=1457611872.761363, session=17578864249730
> PGSQL: type=PrimaryKeepalive, B -> F
> PRIMARY KEEP-ALIVE

This patch is enough to eliminate the problem on my hardware; in this
test the server sent only 29 keepalives during the shutdown:
http://nick.cleaton.net/protodump-100k-nossl-patched.xz (47k)
Attachment

pgsql-bugs by date:

Previous
From: Dmitriy Sarafannikov
Date:
Subject: Re: [BUGS] Segfault in MemoryContextAlloc
Next
From: Dmitriy Sarafannikov
Date:
Subject: Re[2]: [BUGS] Too many files in pg_replslot folder