DevPlanetScaleabout 19 hours ago
Poisoned Postgres connection pools
5 min read
PgBouncer connection pools can become poisoned when a client leaves session state like default_transaction_read_only set, causing future queries to fail with error 25006. The quick fix is executing DISCARD ALL on every pooled connection, then fixing the application code that leaks session state.
Level
Hype check
Tap to vote and see what everyone thinks.
Summary by ByteBrief
