public inbox for [email protected]
help / color / mirror / Atom feedFrom: Achilleas Mantzios <[email protected]>
To: KK CHN <[email protected]>
To: [email protected]
Subject: Re: PgBouncer Prepared Statement ERROR
Date: Wed, 23 Jul 2025 09:06:24 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKgGyB8PvfvuSMEBLhTCHiJphouKS84-BQSg1iD9dWkzmiXdJQ@mail.gmail.com>
References: <CAKgGyB8PvfvuSMEBLhTCHiJphouKS84-BQSg1iD9dWkzmiXdJQ@mail.gmail.com>
On 7/18/25 13:52, KK CHN wrote:
> 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 ?
>
>
Before you start considering prepared statements, via pgbouncer, and
testing them to see if you benefit from them, you may at first disable
them all together.
Just set prepareThreshold=0 in the connection url, or params.
> Any hints most welcome,
> Krishane
>
>
> config as follows
> [root@pgbouncer ~]# grep ^[^';;;'] /usr/local/etc/pgbouncer.ini
> [databases]
> transaction_db = host=dbmain.erss.in <http://dbmain.erss.in; port=5444
> dbname= transaction_db
> mgt_db = host=dbmain.erss.in <http://dbmain.erss.in; port=5444
> dbname=mgt_db
> ....................................
> tsp_db = host=dbmain.erss.in <http://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 ~]#
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: PgBouncer Prepared Statement ERROR
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox