Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgpool-general-owner+archive@lists.postgresql.org>)
	id 1wmY0O-000qUD-2M
	for pgpool-general@arkaria.postgresql.org;
	Wed, 22 Jul 2026 14:33:05 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgpool-general-owner+archive@lists.postgresql.org>)
	id 1wmY0N-00Cfd9-35
	for pgpool-general@arkaria.postgresql.org;
	Wed, 22 Jul 2026 14:33:03 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <a.mantzios@cloud.gatewaynet.com>)
	id 1wmY0N-00Cfd0-2X
	for pgpool-general@lists.postgresql.org;
	Wed, 22 Jul 2026 14:33:03 +0000
Received: from cloud.gatewaynet.com ([185.90.37.94])
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <a.mantzios@cloud.gatewaynet.com>)
	id 1wmY0I-00000001Qp1-2CGc
	for pgpool-general@lists.postgresql.org;
	Wed, 22 Jul 2026 14:33:02 +0000
Content-Type: multipart/mixed; boundary="------------eULXfu6k0wVw43IcimLf6Sl5"
Message-ID: <25939319-d77c-4df9-9e65-dfb1637ccd33@cloud.gatewaynet.com>
Date: Wed, 22 Jul 2026 17:32:55 +0300
MIME-Version: 1.0
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Subject: low level protocol, implicit transactions , "idle in transaction"
 issue
To: "pgpool-general@lists.postgresql.org"
 <pgpool-general@lists.postgresql.org>
Content-Language: en-US
Cc: Achilleas Mantzios <itdev@gatewaynet.com>
List-Id: <pgpool-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgpool-general@lists.postgresql.org>
List-Owner: <mailto:pgpool-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgpool-general>
Archived-At: 
 <https://www.postgresql.org/message-id/25939319-d77c-4df9-9e65-dfb1637ccd33%40cloud.gatewaynet.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------eULXfu6k0wVw43IcimLf6Sl5
Content-Type: multipart/alternative;
 boundary="------------fc1ArHHqnDMthadkv0in1XAr"

--------------fc1ArHHqnDMthadkv0in1XAr
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Dear pgpool team

This is our setup :

Quarkus (Agroal) -> pgbouncer-1.25.1 -> pgpool 4.7.2 -> pgsql 18.3

We noticed that with no explicit transactions, at start up SQL queries 
(application_name, search_path, etc), we experienced random 'idle in 
transaction' connections from pgpool -> pgsql.

Bypassing pgpool, i.e. pgbouncer -> directly to pgsql , the issue was 
not there.

So, bypassing the past excellent relation and collaboration I had with 
you guys,  I got into the temptation to use our local AI cli agent 
(against our local GLM-5.2-NVFP4 ) from within pgpool 4.7.2 code base 
and try to see what's going on.

So it gave it a thorough examination, looked at past issues, etc and it 
came up with a patch. It applied the patch , compiled and installed, and 
I only had to restart pgpool.

The problem seems gone .

I attach the patch. Please review and tell me your thoughts. I Know I 
should maybe go the classic route, mailing list, advice from you, full 
logging, etc till I demo the issue, but the time is pushing us hard.

Thank you!

--------------fc1ArHHqnDMthadkv0in1XAr
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Dear pgpool team</p>
    <p>This is our setup :</p>
    <p>Quarkus (Agroal) -&gt;  <span
        style="color:#000000;background-color:#ffffff;">pgbouncer-1.25.1
        -&gt; pgpool </span>4.7.2 -&gt; pgsql 18.3</p>
    <p>We noticed that with no explicit transactions, at start up SQL
      queries (application_name, search_path, etc), we experienced
      random 'idle in transaction' connections from pgpool -&gt; pgsql.</p>
    <p>Bypassing pgpool, i.e. pgbouncer -&gt; directly to pgsql , the
      issue was not there.</p>
    <p>So, bypassing the past excellent relation and collaboration I had
      with you guys,  I got into the temptation to use our local AI cli
      agent (against our local 
      <span style="font-family:monospace"><span
          style="color:#000000;background-color:#ffffff;">GLM-5.2-NVFP4</span></span> )
      from within pgpool 4.7.2 code base and try to see what's going
      on. </p>
    <p>So it gave it a thorough examination, looked at past issues, etc
      and it came up with a patch. It applied the patch , compiled and
      installed, and I only had to restart pgpool.</p>
    <p>The problem seems gone .</p>
    <p>I attach the patch. Please review and tell me your thoughts. I
      Know I should maybe go the classic route, mailing list, advice
      from you, full logging, etc till I demo the issue, but the time is
      pushing us hard.</p>
    <p>Thank you!</p>
  </body>
</html>

--------------fc1ArHHqnDMthadkv0in1XAr--

--------------eULXfu6k0wVw43IcimLf6Sl5
Content-Type: text/x-patch; charset=UTF-8; name="do_query_sync.patch"
Content-Disposition: attachment; filename="do_query_sync.patch"
Content-Transfer-Encoding: base64

LS0tIGEvc3JjL3Byb3RvY29sL3Bvb2xfcHJvY2Vzc19xdWVyeS5jCisrKyBiL3NyYy9wcm90
b2NvbC9wb29sX3Byb2Nlc3NfcXVlcnkuYwpAQCAtMTk1MSw2ICsxOTUxLDcgQEAKIAlpbnQJ
CQludW1fY2xvc2VfY29tcGxldGU7CiAJaW50CQkJc3RhdGU7CiAJYm9vbAkJZGF0YV9wdXNo
ZWQ7CisJYm9vbAkJc2VudF9zeW5jID0gZmFsc2U7CQkvKiB0cnVlIGlmIHdlIHNlbnQgYSBT
eW5jIChub3QgRmx1c2gpICovCiAKIAlkYXRhX3B1c2hlZCA9IGZhbHNlOwogCkBAIC0yMTAx
LDE1ICsyMTAyLDI2IEBACiAJCS8qCiAJCSAqIFNlbmQgc3luYyBvciBmbHVzaCBtZXNzYWdl
LiBJZiB3ZSBhcmUgaW4gYW4gZXhwbGljaXQgdHJhbnNhY3Rpb24sCiAJCSAqIHNlbmRpbmcg
InN5bmMiIGlzIHNhZmUgYmVjYXVzZSBpdCB3aWxsIG5vdCBicmVhayB1bm5hbWVkIHBvcnRh
bC4KLQkJICogQWxzbyB0aGlzIGlzIGRlc2lyYWJsZSBiZWNhdXNlIGlmIG5vIHVzZXIgcXVl
cmllcyBhcmUgc2VudCBhZnRlcgotCQkgKiBkb19xdWVyeSgpLCBDT01NSVQgY29tbWFuZCBj
b3VsZCBjYXVzZSBzdGF0ZW1lbnQgdGltZSBvdXQsIGJlY2F1c2UKLQkJICogZmx1c2ggbWVz
c2FnZSBkb2VzIG5vdCBjbGVhciB0aGUgYWxhcm0gZm9yIHN0YXRlbWVudCB0aW1lIG91dCB3
aGljaAotCQkgKiBoYXMgYmVlbiBzZXQgd2hlbiBkb19xdWVyeSgpIGlzc3VlcyBxdWVyeS4K
KwkJICoKKwkJICogSW4gdGhlIGV4dGVuZGVkLXF1ZXJ5IHBhdGggd2Ugbm93IEFMV0FZUyBz
ZW5kIFN5bmMuIFRoZSBwcmV2aW91cworCQkgKiBjb2RlIHNlbnQgRmx1c2ggd2hlbiB0c3Rh
dGUgIT0gJ1QnLCBidXQgdHN0YXRlIGlzIG9ubHkgdXBkYXRlZAorCQkgKiBmcm9tIHNpbXBs
ZS1xdWVyeSBCRUdJTi9DT01NSVQgQ29tbWFuZENvbXBsZXRlIHRhZ3M7IGl0IGlzIE5PVAor
CQkgKiB1cGRhdGVkIGZyb20gdGhlIFJlYWR5Rm9yUXVlcnkgKCdaJykgdHJhbnNhY3Rpb24t
c3RhdHVzIGJ5dGUgaW4KKwkJICogdGhlIGV4dGVuZGVkIHBhdGgsIGFuZCBpdCBpcyBuZXZl
ciAnVCcgZm9yIGltcGxpY2l0IChhdXRvY29tbWl0KQorCQkgKiB0cmFuc2FjdGlvbnMuIFdp
dGggRmx1c2gsIHRoZSBpbXBsaWNpdCB0cmFuc2FjdGlvbiBvcGVuZWQgYnkgdGhlCisJCSAq
IGJhY2tlbmQgYXJvdW5kIHRoaXMgUGFyc2UvQmluZC9FeGVjdXRlIGlzIG5ldmVyIGNsb3Nl
ZCwgbGVhdmluZworCQkgKiB0aGUgc2VydmVyIGNvbm5lY3Rpb24gImlkbGUgaW4gdHJhbnNh
Y3Rpb24iIGFmdGVyIGRvX3F1ZXJ5KCkKKwkJICogcmV0dXJucy4gVGhpcyBpcyBvYnNlcnZh
YmxlIHdpdGggY2xpZW50cyB0aGF0IHVzZSB0aGUgZXh0ZW5kZWQKKwkJICogcHJvdG9jb2wg
d2l0aCBpbXBsaWNpdCB0cmFuc2FjdGlvbnMgKGUuZy4gUXVhcmt1cy9BZ3JvYWwpIGJlaGlu
ZAorCQkgKiBwZ2JvdW5jZXIsIGFuZCBvbmx5IHdoZW4gbWVtb3J5X2NhY2hlX2VuYWJsZWQg
PSBvbiwgYmVjYXVzZSB0aGF0CisJCSAqIGlzIHdoYXQgbWFrZXMgcGdwb29sIGlzc3VlIHRo
ZXNlIGludGVybmFsIGNhdGFsb2cgbG9va3VwcyB2aWEKKwkJICogZG9fcXVlcnkoKSBvdXRz
aWRlIG9mIGFuIGV4cGxpY2l0IHRyYW5zYWN0aW9uLiBTeW5jIGNsb3NlcyB0aGUKKwkJICog
aW1wbGljaXQgdHJhbnNhY3Rpb247IHRoZSBuYW1lZCBzdGF0ZW1lbnQvcG9ydGFsIHdlIHVz
ZSBoZXJlCisJCSAqICgicGdwb29sPFBJRD4iKSBpcyB1bmFmZmVjdGVkLCBhbmQgdGhlIHVu
bmFtZWQgcG9ydGFsIGlzIHJlYnVpbHQKKwkJICogYnkgdGhlIG5leHQgdXNlciBQYXJzZSBh
bnl3YXkuCiAJCSAqLwotCQlpZiAoYmFja2VuZC0+dHN0YXRlID09ICdUJykKLQkJCXBvb2xf
d3JpdGUoYmFja2VuZCwgIlMiLCAxKTsJLyogc2VuZCAic3luYyIgbWVzc2FnZSAqLwotCQll
bHNlCi0JCQlwb29sX3dyaXRlKGJhY2tlbmQsICJIIiwgMSk7CS8qIHNlbmQgImZsdXNoIiBt
ZXNzYWdlICovCisJCXBvb2xfd3JpdGUoYmFja2VuZCwgIlMiLCAxKTsJCS8qIHNlbmQgInN5
bmMiIG1lc3NhZ2UgKi8KKwkJc2VudF9zeW5jID0gdHJ1ZTsKIAkJbGVuID0gaHRvbmwoc2l6
ZW9mKGxlbikpOwogCQlwb29sX3dyaXRlX2FuZF9mbHVzaChiYWNrZW5kLCAmbGVuLCBzaXpl
b2YobGVuKSk7CiAJfQpAQCAtMjIyMCw3ICsyMjMyLDcgQEAKIAkJCQkJcmV0dXJuOwogCiAJ
CQkJLyogSWYgInN5bmMiIG1lc3NhZ2Ugd2FzIGlzc3VlZCwgJ1onIGlzIGV4cGVjdGVkLiAq
LwotCQkJCWlmIChkb2luZ19leHRlbmRlZCAmJiBiYWNrZW5kLT50c3RhdGUgPT0gJ1QnKQor
CQkJCWlmIChkb2luZ19leHRlbmRlZCAmJiBzZW50X3N5bmMpCiAJCQkJCXN0YXRlIHw9IENP
TU1BTkRfQ09NUExFVEVfUkVDRUlWRUQ7CiAJCQkJYnJlYWs7CiAKQEAgLTIyMzIsNyArMjI0
NCw3IEBACiAJCQkJICogSWYgInN5bmMiIG1lc3NhZ2Ugd2FzIGlzc3VlZCwgJ1onIGlzIGV4
cGVjdGVkLCBlbHNlIHdlIGFyZQogCQkJCSAqIGRvbmUgd2l0aCAnQycuCiAJCQkJICovCi0J
CQkJaWYgKCFkb2luZ19leHRlbmRlZCB8fCBiYWNrZW5kLT50c3RhdGUgIT0gJ1QnKQorCQkJ
CWlmICghZG9pbmdfZXh0ZW5kZWQgfHwgIXNlbnRfc3luYykKIAkJCQkJc3RhdGUgfD0gQ09N
TUFORF9DT01QTEVURV9SRUNFSVZFRDsKIAogCQkJCS8qCg==

--------------eULXfu6k0wVw43IcimLf6Sl5--