Re: pgsql: Log details for client certificate failures - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Log details for client certificate failures
Date
Msg-id 3820525.1657979832@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Log details for client certificate failures  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: pgsql: Log details for client certificate failures
List pgsql-committers
Justin Pryzby <pryzby@telsasoft.com> writes:
> On Sat, Jul 16, 2022 at 01:57:25PM +0200, Peter Eisentraut wrote:
>> Isn't the cfbot using the same thing?

> It's using the same thing, so I suppose the failure is intermittent.
> It failed for me just now: https://cirrus-ci.com/task/6502388730167296

It looks like a timing problem, which you'd probably never reproduce
on an unloaded development system.  On the presumably-busy CI hosts,
I think we're managing to examine the log file before the backend has
written the log entry.

Can we rejigger the backend so that the log entry is written before
we shove the failure response out to the client?  Maybe not given the
implementation technology.  In that case the alternatives seem to be
(1) insert a delay in the log_like checks (ugh) or
(2) abandon attempting to test this particular behavior.

            regards, tom lane



pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Attempt to fix compiler warning on old compiler
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Log details for client certificate failures