public inbox for pgsql-admin@postgresql.org  
help / color / mirror / Atom feed
Pgbouncer error
2+ messages / 2 participants
[nested] [flat]

* Pgbouncer error
@ 2026-04-11 19:16 Raj <rajeshkumar.dba09@gmail.com>
  2026-04-11 19:30 ` Re: Pgbouncer error David G. Johnston <david.g.johnston@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:16 Pgbouncer error Raj <rajeshkumar.dba09@gmail.com>
@ 2026-04-11 19:30 ` David G. Johnston <david.g.johnston@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