ERROR: prepared statement "s1" already exists (PgBouncer transaction mode)
Named prepared statements collided — typically because PgBouncer in transaction pooling mode hands connections between clients.
prepared statement already existsprepared statement does not exist Meaning
In transaction mode, a client’s next transaction may run on a different server connection where its prepared statements don’t exist (or another client’s do). PgBouncer 1.21+ supports prepared statements with max_prepared_statements.
Common causes
- PgBouncer transaction pooling with drivers using named prepared statements
- Supabase/Neon poolers in transaction mode
⚡ Quick fix
- Upgrade PgBouncer and set max_prepared_statements
- Disable prepared statements in the driver (Prisma: ?pgbouncer=true; JDBC: prepareThreshold=0)
- Use session pooling for that client
Detailed fix by platform
PostgreSQL
postgresql://…@pooler:6543/db?pgbouncer=true
How to diagnose
- Pooler — Transaction mode?
- Driver — Uses named statements?
🔧 Still not fixed?
Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:
Similar errors
Most viewed in PostgreSQL
- 23505 PostgreSQL: ERROR: duplicate key value violates unique constraint
- incompatible data directory FATAL: database files are incompatible with server — The data directory was initialized by PostgreSQL version 15, which is not compatible with this version 16
- postmaster.pid FATAL: lock file "postmaster.pid" already exists — Is another postmaster running in data directory?
Other ways to find it
Where this error sits
Origin: Data. Errors that are often confused with or caused by this one (click to open):
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
💬 What worked for others
No tips yet — did something else fix this for you?
Share what worked for you
Tips are checked by an editor before they appear. Links are removed.
Report a correction or suggest an improvement
Last updated 13 Oct 2026