pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Log details for client certificate failures
Date: Sat, 16 Jul 2022 09:57:12 -0400
Message-ID: <3820525.1657979832@sss.pgh.pa.us> (raw)
In-Reply-To: <20220716121723.GW18011@telsasoft.com>
References: <E1oCNLk-000LCH-Af@gemulon.postgresql.org>
	<20220716113752.GU18011@telsasoft.com>
	<48b78358-70d8-8de5-02ea-669c4051e4ba@enterprisedb.com>
	<20220716121723.GW18011@telsasoft.com>

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





view thread (12+ messages)  latest in thread

Message-ID: <3820525.1657979832@sss.pgh.pa.us>
Permalink:  ../3820525.1657979832@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3820525.1657979832@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: tgl@sss.pgh.pa.us, pryzby@telsasoft.com, peter.eisentraut@enterprisedb.com, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Log details for client certificate failures
  In-Reply-To: <3820525.1657979832@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox