public inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: David G. Johnston <david.g.johnston@gmail.com>
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Pgbouncer error
Date: Sat, 11 Apr 2026 12:30:02 -0700
Message-ID: <CAKFQuwbaP1RNZe0eFrj=euKL7snDfKxM6Zt-UEVBrkstqmmd2Q@mail.gmail.com> (raw)
In-Reply-To: <CAJk5AtZ2vh02kbYq9+WZRfXFMtHvvzwq4sHZ5oC17C29OxQsmA@mail.gmail.com>
References: <CAJk5AtZ2vh02kbYq9+WZRfXFMtHvvzwq4sHZ5oC17C29OxQsmA@mail.gmail.com>

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.

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: pgsql-admin@postgresql.org
  Cc: david.g.johnston@gmail.com, rajeshkumar.dba09@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Pgbouncer error
  In-Reply-To: <CAKFQuwbaP1RNZe0eFrj=euKL7snDfKxM6Zt-UEVBrkstqmmd2Q@mail.gmail.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