Re: walreceiver that is behind doesn't quit, send replies - Mailing list pgsql-hackers

From Andres Freund
Subject Re: walreceiver that is behind doesn't quit, send replies
Date
Msg-id 20210511025940.rkx73zezq3hq3eae@alap3.anarazel.de
Whole thread Raw
In response to walreceiver that is behind doesn't quit, send replies  (Andres Freund <andres@anarazel.de>)
List 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



pgsql-hackers by date:

Previous
From: Andrey Lepikhov
Date:
Subject: Re: Asynchronous Append on postgres_fdw nodes.
Next
From: Amit Langote
Date:
Subject: update/delete and execution-time partition pruning