Re: Add client connection check during the execution of the query - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Add client connection check during the execution of the query
Date
Msg-id CA+hUKGL1uR0qKy3Hy8-9aFU=jxcGedaKqYTx_gRdyRg0p7cKGw@mail.gmail.com
Whole thread Raw
In response to Re: Add client connection check during the execution of the query  (Andres Freund <andres@anarazel.de>)
Responses Re: Add client connection check during the execution of the query
List pgsql-hackers
On Fri, Jan 14, 2022 at 4:35 PM Andres Freund <andres@anarazel.de> wrote:
> The more I think about it, the less I see why we *ever* need to re-arm the
> latch in pq_check_connection() in this approach. pq_check_connection() is only
> used from from ProcessInterrupts(), and there's plenty things inside
> ProcessInterrupts() that can cause latches to be reset (e.g. parallel message
> processing causing log messages to be sent to the client, causing network IO,
> which obviously can do a latch reset).

Thanks for the detailed explanation.  I guess I was being overly
cautious and a little myopic, "leave things exactly the way you found
them", so I didn't have to think about any of that.  I see now that
the scenario I was worrying about would be a bug in whatever
latch-wait loop happens to reach this code.  Alright then, here is
just... one... more... patch, this time consuming any latch that gets
in the way and retrying, with no restore.

Attachment

pgsql-hackers by date:

Previous
From: "kato-sho@fujitsu.com"
Date:
Subject: Re: fix crash with Python 3.11
Next
From: Julien Rouhaud
Date:
Subject: Re: relcache not invalidated when ADD PRIMARY KEY USING INDEX