MIME-Version: 1.0
From: KK CHN <kkchn.in@gmail.com>
Date: Fri, 18 Jul 2025 18:22:55 +0530
Message-ID: <CAKgGyB8PvfvuSMEBLhTCHiJphouKS84-BQSg1iD9dWkzmiXdJQ@mail.gmail.com>
Subject: PgBouncer Prepared Statement ERROR
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000fdd84b063a338eda"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB8PvfvuSMEBLhTCHiJphouKS84-BQSg1iD9dWkzmiXdJQ%40mail.gmail.com>
Precedence: bulk

--000000000000fdd84b063a338eda
Content-Type: text/plain; charset="UTF-8"

Hi ,

I am getting error when using  PgBouncer(1.23.1 ) with  Postgres 16
(RedHAT 9.4)

2025-07-18 00:00:00 IST ERROR:  prepared statement "S_243" does not exist
2025-07-18 00:00:03 IST ERROR:  prepared statement "S_205" does not exist
2025-07-18 00:00:03 IST ERROR:  prepared statement "S_206" does not exist
2025-07-18 00:00:03 IST ERROR:  prepared statement "S_207" does not exist


How to avoid these prepared statement Errors ?


Any hints most welcome,
Krishane


config as follows
[root@pgbouncer ~]# grep ^[^';;;']  /usr/local/etc/pgbouncer.ini
[databases]
transaction_db = host=dbmain.erss.in port=5444 dbname= transaction_db
mgt_db = host=dbmain.erss.in port=5444 dbname=mgt_db
....................................
tsp_db = host=dbmain.erss.in port=5444 dbname=tsp_db
[users]
[pgbouncer]
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_addr = *
listen_port = 5444
auth_type = md5
auth_file = /usr/local/etc/pgbouncer.users
admin_users = myuser
stats_users =  status_user,
pool_mode = transaction
server_reset_query = DISCARD ALL
server_reset_query_always = 1
ignore_startup_parameters = extra_float_digits, options, statement_timeout,
idle_in_transaction_session_timeout
max_client_conn = 5000
default_pool_size = 20
min_pool_size = 10
reserve_pool_size = 10
reserve_pool_timeout = 5
max_db_connections = 900
max_user_connections = 800
server_lifetime = 3600
server_idle_timeout = 60000
[root@pgbouncer ~]#

--000000000000fdd84b063a338eda
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi ,<br><div><br></div><div>I am getting error when using=
=C2=A0 PgBouncer(1.23.1 ) with=C2=A0 Postgres 16=C2=A0 (RedHAT 9.4)</div><d=
iv><br></div><div>2025-07-18 00:00:00 IST ERROR: =C2=A0prepared statement &=
quot;S_243&quot; does not exist<br>2025-07-18 00:00:03 IST ERROR: =C2=A0pre=
pared statement &quot;S_205&quot; does not exist<br>2025-07-18 00:00:03 IST=
 ERROR: =C2=A0prepared statement &quot;S_206&quot; does not exist<br>2025-0=
7-18 00:00:03 IST ERROR: =C2=A0prepared statement &quot;S_207&quot; does no=
t exist<br><br></div><div><br></div><div>How to avoid these prepared statem=
ent Errors ?=C2=A0 =C2=A0</div><div><br></div><div><br></div><div>Any hints=
 most welcome,</div><div>Krishane</div><div><br></div><div>=C2=A0</div><div=
><br></div><div>config as follows</div><div>[root@pgbouncer ~]# grep ^[^=
9;;;;&#39;] =C2=A0/usr/local/etc/pgbouncer.ini<br>[databases]<br>transactio=
n_db =3D host=3D<a href=3D"http://dbmain.erss.in">dbmain.erss.in</a> port=
=3D5444 dbname=3D

transaction_db<br>mgt_db =3D host=3D<a href=3D"http://dbmain.erss.in">dbmai=
n.erss.in</a> port=3D5444 dbname=3Dmgt_db<br>..............................=
......</div><div>tsp_db =3D host=3D<a href=3D"http://dbmain.erss.in">dbmain=
.erss.in</a> port=3D5444 dbname=3Dtsp_db<br>[users]<br>[pgbouncer]<br>logfi=
le =3D /var/log/pgbouncer/pgbouncer.log<br>pidfile =3D /var/run/pgbouncer/p=
gbouncer.pid<br>listen_addr =3D *<br>listen_port =3D 5444<br>auth_type =3D =
md5<br>auth_file =3D /usr/local/etc/pgbouncer.users<br>admin_users =3D myus=
er<br>stats_users =3D=C2=A0 status_user,<br>pool_mode =3D transaction<br>se=
rver_reset_query =3D DISCARD ALL<br>server_reset_query_always =3D 1<br>igno=
re_startup_parameters =3D extra_float_digits, options, statement_timeout, i=
dle_in_transaction_session_timeout<br>max_client_conn =3D 5000<br>default_p=
ool_size =3D 20<br>min_pool_size =3D 10<br>reserve_pool_size =3D 10<br>rese=
rve_pool_timeout =3D 5<br>max_db_connections =3D 900<br>max_user_connection=
s =3D 800<br>server_lifetime =3D 3600<br>server_idle_timeout =3D 60000<br>[=
root@pgbouncer ~]#<br></div><div><br></div></div>

--000000000000fdd84b063a338eda--