Re: Race condition in recovery? - Mailing list pgsql-hackers

From Mikael Kjellström
Subject Re: Race condition in recovery?
Date
Msg-id 30a35548-01f3-f0b8-5a72-983c49abee00@mksoft.nu
Whole thread Raw
In response to Re: Race condition in recovery?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 2021-06-10 01:09, Tom Lane wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Got it. I have now committed the patch to all branches, after adapting
>> your changes just a little bit.
>> Thanks to you and Kyotaro-san for all the time spent on this. What a slog!
> 
> conchuela failed its first encounter with this test case:
> 
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=conchuela&dt=2021-06-09%2021%3A12%3A25
> 
> That machine has a certain, er, history of flakiness; so this may
> not mean anything.  Still, we'd better keep an eye out to see if
> the test needs more stabilization.

Yes, the flakiness is caused by the very weird filesystem (HAMMERFS) 
that has some weird garbage collection handling that sometimes fills up 
the disk and then never recovers automatically.

I have tried to put in the cleanup-utility for HAMMERFS in cron to run 
at a schedule but it's isn't 100% fool proof.

So I am going to upgrade to a newer version of DragonflyBSD in the near 
future.

/Mikael



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Fdw batch insert error out when set batch_size > 65535
Next
From: Michail Nikolaev
Date:
Subject: Re: Slow standby snapshot