Re: failure in 019_replslot_limit

2024-02-09 Thread Alexander Lakhin
09.02.2024 21:59, Andres Freund wrote: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=kestrel=2024-02-04%2001%3A53%3A44 ) and saw that it's not checkpointer, but walsender is hanging: How did you reproduce this? As kestrel didn't produce this failure until recently, I supposed that

Re: failure in 019_replslot_limit

2024-02-09 Thread Andres Freund
Hi, On 2024-02-09 18:00:01 +0300, Alexander Lakhin wrote: > I've managed to reproduce this issue (which still persists: > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=kestrel=2024-02-04%2001%3A53%3A44 > ) and saw that it's not checkpointer, but walsender is hanging: How did you

Re: failure in 019_replslot_limit

2024-02-09 Thread Alexander Lakhin
Hello Andres, 05.04.2023 21:48, Andres Freund wrote: I just saw the following failure: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mylodon=2023-04-05%2017%3A47%3A03 after a commit of mine. The symptoms look unrelated though. [17:54:42.188](258.345s) # poll_query_until timed out

Re: failure in 019_replslot_limit

2023-04-05 Thread Kyotaro Horiguchi
At Wed, 5 Apr 2023 11:55:14 -0700, Andres Freund wrote in > 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 > >

Re: failure in 019_replslot_limit

2023-04-05 Thread Andres Freund
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,

failure in 019_replslot_limit

2023-04-05 Thread Andres Freund
Hi, I just saw the following failure: https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=mylodon=2023-04-05%2017%3A47%3A03 after a commit of mine. The symptoms look unrelated though. [17:54:42.188](258.345s) # poll_query_until timed out executing this query: # SELECT wal_status FROM