public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrien Obernesser (OBA) <[email protected]>
To: Durgamahesh Manne <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: pgbouncer transaction pool mode issue for prepared statements
Date: Mon, 16 Feb 2026 13:36:59 +0000
Message-ID: <ZRAP278MB020501725B91B175D8300AC0C46CA@ZRAP278MB0205.CHEP278.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <CAJCZkoJr=Az5PMDj15O5ekzK+vK454WzoWZdQ9XUfTkTWtCQGw@mail.gmail.com>
References: <CAJCZkoJr=Az5PMDj15O5ekzK+vK454WzoWZdQ9XUfTkTWtCQGw@mail.gmail.com>
Hi,
It looks like you have the issue of a query that is referencing the prepared statements of another session. This is expected in transaction pooling mode. Since you are using this version of pgbouncer
try to look into the max_prepared_statements parameter, I am not quite sure with the unnamed aspect though, this would need testing on your config.
Cordialement, Kind Regards,
Adrien OBERNESSER
________________________________
From: Durgamahesh Manne <[email protected]>
Sent: Monday, February 16, 2026 2:24 PM
To: pgsql-general <[email protected]>
Subject: pgbouncer transaction pool mode issue for prepared statements
Hi PGDG Team
We’re currently facing an issue with PgBouncer transaction pooling mode, where prepared statements are failing, and we are unable to modify the application code to disable or change how prepared statements are used.
Switching to session pooling mode is not feasible for us because we have a very high number of connections that we cannot fully control. Environment details: PgBouncer version: 1.25.1 PostgreSQL version: 16.11
The specific error we’re seeing is:
bind message has 43 result formats but query has 47 columns
ERROR: unnamed prepared statement does not exist Repeatedly logs
Has anyone encountered this issue with transaction pooling and prepared statements? Are there any PgBouncer parameters or settings we can use to mitigate this problem without requiring application‑level changes? Any guidance or solutions would be greatly appreciated.
Regards
Durga Mahesh
view thread (4+ messages) latest in thread
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 transaction pool mode issue for prepared statements
In-Reply-To: <ZRAP278MB020501725B91B175D8300AC0C46CA@ZRAP278MB0205.CHEP278.PROD.OUTLOOK.COM>
* 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