pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection
3+ messages / 3 participants
[nested] [flat]
* BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection
@ 2023-06-01 11:27 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2023-06-01 11:27 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: olli.pekkola@grundium.com
The following bug has been logged on the website:
Bug reference: 17953
Logged by: Olli Pekkola
Email address: olli.pekkola@grundium.com
PostgreSQL version: 14.6
Operating system: Linux
Description:
I can craft a POC if neccessary, precise steps are not super clear at this
time. But the PQexecFinish() stalled several times withtout TLS with the
following stack (with TLS, not a single instance of this is observed):
#0 0x00007fd96e33f3ff in poll () from
target:/lib/x86_64-linux-gnu/libc.so.6
#1 0x0000561c06fdbed2 in poll ()
#2 0x0000561c07664bf0 in pqSocketPoll (end_time=-1, forWrite=0, forRead=1,
sock=<optimized out>) at
src/postgresql-14.6/src/interfaces/libpq/fe-misc.c:1134
#3 pqSocketCheck (conn=conn@entry=0x619000003780, forRead=forRead@entry=1,
forWrite=forWrite@entry=0, end_time=end_time@entry=-1) at
src/interfaces/libpq/fe-misc.c:1075
#4 0x0000561c07665320 in pqWaitTimed (forRead=forRead@entry=1,
forWrite=forWrite@entry=0, conn=conn@entry=0x619000003780,
finish_time=finish_time@entry=-1)
at src/postgresql-14.6/src/interfaces/libpq/fe-misc.c:1007
#5 0x0000561c0766536c in pqWait (forRead=forRead@entry=1,
forWrite=forWrite@entry=0, conn=conn@entry=0x619000003780) at
src/interfaces/libpq/fe-misc.c:992
#6 0x0000561c07663048 in PQgetResult (conn=0x619000003780) at
src/interfaces/libpq/fe-exec.c:2042
#7 PQgetResult (conn=0x619000003780) at src/interfaces/libpq/fe-exec.c:2007
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection
@ 2023-06-04 00:36 Heikki Linnakangas <hlinnaka@iki.fi>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Heikki Linnakangas @ 2023-06-04 00:36 UTC (permalink / raw)
To: olli.pekkola@grundium.com; pgsql-bugs@lists.postgresql.org
On 01/06/2023 07:27, PG Bug reporting form wrote:
> I can craft a POC if neccessary, precise steps are not super clear at this
> time. But the PQexecFinish() stalled several times withtout TLS with the
> following stack (with TLS, not a single instance of this is observed):
Yeah, I think we'll need a self-contained repro to debug this. Or at
least a lot more details on what the query is, what the server is doing
when that happens, etc. A wireshark trace might be useful.
--
Heikki Linnakangas
Neon (https://neon.tech)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection
@ 2023-06-12 01:28 Michael Paquier <michael@paquier.xyz>
parent: Heikki Linnakangas <hlinnaka@iki.fi>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Paquier @ 2023-06-12 01:28 UTC (permalink / raw)
To: Heikki Linnakangas <hlinnaka@iki.fi>; +Cc: olli.pekkola@grundium.com; pgsql-bugs@lists.postgresql.org
On Sat, Jun 03, 2023 at 08:36:02PM -0400, Heikki Linnakangas wrote:
> Yeah, I think we'll need a self-contained repro to debug this. Or at least a
> lot more details on what the query is, what the server is doing when that
> happens, etc. A wireshark trace might be useful.
Latency-sensitive issue perhaps? I am unsure of what we could do here
without more evidence and/or ways to reproduce the problem. Likely as
a small-ish libpq program and something to fake a delay?
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-06-12 01:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-01 11:27 BUG #17953: Libpq can stall indefinitely with non-tls localhost (127.0.0.1) connection PG Bug reporting form <noreply@postgresql.org>
2023-06-04 00:36 ` Heikki Linnakangas <hlinnaka@iki.fi>
2023-06-12 01:28 ` Michael Paquier <michael@paquier.xyz>
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