Re: SQL:2011 application time

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>
Subject: Re: SQL:2011 application time
Date: 2025-02-12 15:23:36
Message-ID: 88d7e13c-2a14-49ec-a603-7f3a38ac66c4@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-02-12 15:28:42 Re: MAX_BACKENDS size (comment accuracy)
Previous Message Peter Eisentraut 2025-02-12 14:59:11 Re: [PoC] Federated Authn/z with OAUTHBEARER