Migrating from 10 -> 16, PreparedStatements disabled in JDBC and pgbouncer, I am getting : bind <unnamed>/C_5

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

Responses

Browse pgsql-admin by date

  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