Re: [PATCH] Align GSS and TLS error handling in PQconnectPoll()

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Jacob Champion <jchampion(at)timescale(dot)com>
Cc: Jelte Fennema <me(at)jeltef(dot)nl>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>
Subject: Re: [PATCH] Align GSS and TLS error handling in PQconnectPoll()
Date: 2023-02-17 06:59:34
Message-ID: Y+8l1vxXMXBCKNTS@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 16, 2023 at 09:59:54AM -0800, Jacob Champion wrote:
> On Thu, Feb 16, 2023 at 3:31 AM Jelte Fennema <me(at)jeltef(dot)nl> wrote:
>> Patch looks good to me. Definitely an improvement over the status quo.
>
> Thanks for the review!

I was looking at that a second time, and with fresh eyes I can see
that we would miss to mark conn->status with CONNECTION_BAD when using
gssencmode=require when the polling fails in pqsecure_open_gss(),
which is just wrong IMO. This code has been introduced by b0b39f7,
that has added support for GSS encryption. I am adding Stephen Frost
in CC to see if he has any comments about all this part of the logic
with gssencmode.

> I suspect this is a much deeper rabbit hole; I think it's work that
> needs to be done, but I can't sign myself up for it at the moment. The
> complexity of this function is off the charts (for instance, why do we
> recheck conn->try_gss above, if the only apparent way to get to
> CONNECTION_GSS_STARTUP is by having try_gss = true to begin with? is
> there a goto/retry path I'm missing?). I think it either needs heavy
> assistance from a committer who already has intimate knowledge of this
> state machine and all of its possible branches, or from a static
> analysis tool that can help with a step-by-step simplification.

The first one of these is from 57c0879, the second from bcd713a, which
I assume is a copy-paste of the first one. I agree that
PQconnectPoll() has grown beyond the point of making it easy to
maintain. I am wondering which approach we could take when it comes
to simplify something like that. Attempting to reduce the number of
flags stored in PGconn would be one. The second may be to split the
internal logic into more functions, for each state we are going
through? The first may lead to an even cleaner logic for the second
point.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2023-02-17 07:19:46 Re: Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes?
Previous Message Peter Smith 2023-02-17 06:57:28 Re: [PATCH] Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher