Re: walreceiver that is behind doesn't quit, send replies

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: walreceiver that is behind doesn't quit, send replies
Date: 2021-05-11 02:59:40
Message-ID: 20210511025940.rkx73zezq3hq3eae@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2021-05-10 19:27:55 -0700, Andres Freund wrote:
> I've a couple times gotten into a situation where I was shutting down
> the primary while the standby was behind, and the system appeared to
> just lock up, with neither primary nor standby reacting to normal
> shutdown attempts. This seems to happen more often with larger wal
> segment size...

Ah - to reproduce it, you can put a pg_usleep(10000) or so above the
pg_pwrite() in XLogWalRcvMain(). That triggers it fairly reliably for
me.

Greetings,

Andres Freund

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2021-05-11 03:35:36 update/delete and execution-time partition pruning
Previous Message Andrey Lepikhov 2021-05-11 02:58:10 Re: Asynchronous Append on postgres_fdw nodes.