Re: streaming replication master can fail to shut down

From: Nick Cleaton <nick(at)cleaton(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: streaming replication master can fail to shut down
Date: 2016-03-11 14:12:37
Message-ID: CAFgz3ku+LqHBfxQVJP5FWcOsyHL3x7hO-yOLk7ZU_xoqewLNmA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 10 March 2016 at 13:13, Nick Cleaton <nick(at)cleaton(dot)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 Content-Type Size
no-keep-flood.patch text/x-patch 505 bytes

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-03-11 14:42:07 Re: Re: [BUGS] Segfault in MemoryContextAlloc
Previous Message Dmitriy Sarafannikov 2016-03-11 13:03:33 Re: [BUGS] Segfault in MemoryContextAlloc