From: | Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Cc: | Achilleas Mantzios <itdev(at)gatewaynet(dot)com> |
Subject: | Migrating from 10 -> 16, PreparedStatements disabled in JDBC and pgbouncer, I am getting : bind <unnamed>/C_5 |
Date: | 2024-10-18 10:11:28 |
Message-ID: | b661cc9f-da73-4c41-aba8-0bd680a6085c@cloud.gatewaynet.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All
We have disabled prepared statements in the JDBC settings
(prepareThreshold=0) and in pgbouncer (max_prepared_statements=0).
I have noticed in the pgsql 16.4 logs some lines with this pattern :
10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.260 EEST
SMA amantzio(at)dynacom line:35 LOG: duration: 0.166 ms parse <unnamed>:
SELECT work_status FROM company_stuff WHERE ldap_cn = $
1
10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.261 EEST
SMA amantzio(at)dynacom line:36 LOG: duration: 0.553 ms bind
<unnamed>/C_5: SELECT work_status FROM company_stuff WHERE ldap_cn
= $1
10.9.0.110(45201) [4079203] 67122b3b.3e3e63 2024-10-18 12:32:44.261 EEST
SMA amantzio(at)dynacom line:38 LOG: duration: 0.036 ms execute
<unnamed>/C_5: SELECT work_status FROM company_stuff WHERE ldap_
cn = $1
So the parse is done on an unnamed prepared statement, however the bind
and the execute show this : /C_5 after<unnamed>. We haven't got any log
entries with this /C_* pattern on the "parse" phase, only on "bind" and
"execute". I am curious what those represent.
Thank you
From | Date | Subject | |
---|---|---|---|
Next Message | Domen Šetar | 2024-10-18 11:29:22 | LDAP authentication problem |
Previous Message | Tom Lane | 2024-10-17 21:17:29 | Re: [EXT] Re: 101 Grants and Access Right Table/View |