Re: SQL:2011 application time - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SQL:2011 application time
Date
Msg-id 88d7e13c-2a14-49ec-a603-7f3a38ac66c4@eisentraut.org
Whole thread Raw
In response to Re: SQL:2011 application time  (Paul Jungwirth <pj@illuminatedcomputing.com>)
Responses Re: SQL:2011 application time
List pgsql-hackers
On 05.02.25 19:31, Paul Jungwirth wrote:
> On 2/5/25 05:37, Peter Eisentraut wrote:
>> On 29.01.25 07:34, Paul Jungwirth wrote:
>>> Is it possible to commit an RI_PLAN_NO_ACTION addition and see if 
>>> that makes the buildfarm failures go away? Here is a proposed patch 
>>> for that (v48.1). I would understand if this is too questionable a 
>>> practice---but it would be nice to get sufficient test exposure to 
>>> see if it makes a difference. Since I still haven't reproduced this 
>>> locally (despite running continuously for almost a week), it's not an 
>>> experiment I can do myself. If it *does* make the failures go away, 
>>> then it suggests there is still some latent problem somewhere.
>>
>> I'm tempted to give this a try.  But the cfbot is currently in a bit 
>> of a mess, so I'll wait until that is clean again so that we can have 
>> a usable baseline to work against.
> 
> Okay, thanks! I've been spending some more time on this, but I haven't 
> made much progress.

I committed your patch on Sunday, and now it's about 72 hours later.

I've been observing this on cfbot for some time.  Before the patch, you 
could go to cfbot at any time and find between 5 and 10 test failures 
from this problem.  And now there are none.  So I'm calling provisional 
success on this.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER
Next
From: Andres Freund
Date:
Subject: Re: MAX_BACKENDS size (comment accuracy)