public inbox for pgsql-admin@postgresql.orghelp / color / mirror / Atom feed
Pgbouncer error 2+ messages / 2 participants [nested] [flat]
* Pgbouncer error @ 2026-04-11 19:16 Raj <rajeshkumar.dba09@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Raj @ 2026-04-11 19:16 UTC (permalink / raw) To: Pgsql-admin <pgsql-admin@lists.postgresql.org> I see error in pgbouncer saying 'server conn crashed'. Could it be possible that because I set idle_session_timeout to 30min. Also application team getting an error, duplicate values violate constraint's. Is this error possible because of pgbouncer lag ? Or sequences or pure application side issue? ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Pgbouncer error @ 2026-04-11 19:30 David G. Johnston <david.g.johnston@gmail.com> parent: Raj <rajeshkumar.dba09@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: David G. Johnston @ 2026-04-11 19:30 UTC (permalink / raw) To: Raj <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org> On Sat, Apr 11, 2026 at 12:16 PM Raj <rajeshkumar.dba09@gmail.com> wrote: > I see error in pgbouncer saying 'server conn crashed'. Could it be > possible that because I set idle_session_timeout to 30min. > Seems like a reasonable scenario. > Also application team getting an error, duplicate values violate > constraint's. Is this error possible because of pgbouncer lag ? Or > sequences or pure application side issue? > This requires actually debugging your system, not generalities. But 'pgbouncer lag' doesn't really seem like a thing. Concurrency timing issues are a thing to be aware of though. David J. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-04-11 19:30 UTC | newest] Thread overview: 2+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-04-11 19:16 Pgbouncer error Raj <rajeshkumar.dba09@gmail.com> 2026-04-11 19:30 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox