Re: failure in 019_replslot_limit - Mailing list pgsql-hackers

From Andres Freund
Subject Re: failure in 019_replslot_limit
Date
Msg-id 20230405185514.bbietghwyh7v4zl4@awork3.anarazel.de
Whole thread Raw
In response to failure in 019_replslot_limit  (Andres Freund <andres@anarazel.de>)
Responses Re: failure in 019_replslot_limit
List pgsql-hackers
Hi,

On 2023-04-05 11:48:53 -0700, Andres Freund wrote:
> Note that a checkpoint started at "17:50:23.787", but didn't finish before the
> database was shut down.  As far as I can tell, this can not be caused by
> checkpoint_timeout, because by the time we get to invalidating replication
> slots, we already did CheckPointBuffers(), and that's the only thing that
> delays based on checkpoint_timeout.
> 
> ISTM that this indicates that checkpointer got stuck after signalling
> 344783.
> 
> Do you see any other explanation?

This all sounded vaguely familiar. After a bit bit of digging I found this:

https://postgr.es/m/20220223014855.4lsddr464i7mymk2%40alap3.anarazel.de

Which seems like it plausibly explains the failed test?

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: failure in 019_replslot_limit
Next
From: Robert Haas
Date:
Subject: Re: Should vacuum process config file reload more often