MIME-Version: 1.0
References: 
 <CAJk5AtZ2vh02kbYq9+WZRfXFMtHvvzwq4sHZ5oC17C29OxQsmA@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtZ2vh02kbYq9+WZRfXFMtHvvzwq4sHZ5oC17C29OxQsmA@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 11 Apr 2026 12:30:02 -0700
Message-ID: 
 <CAKFQuwbaP1RNZe0eFrj=euKL7snDfKxM6Zt-UEVBrkstqmmd2Q@mail.gmail.com>
Subject: Re: Pgbouncer error
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e5dfa1064f3448f8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwbaP1RNZe0eFrj%3DeuKL7snDfKxM6Zt-UEVBrkstqmmd2Q%40mail.gmail.com>
Precedence: bulk

--000000000000e5dfa1064f3448f8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Apr 11, 2026 at 12:16=E2=80=AFPM 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.

--000000000000e5dfa1064f3448f8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, Apr 11, 2026 at 12:16=E2=80=AFPM Raj &lt;<a href=
=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt;=
 wrote:</span></div></div><div class=3D"gmail_quote gmail_quote_container">=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto">I see e=
rror in pgbouncer saying &#39;server conn crashed&#39;. Could it be possibl=
e that because I set idle_session_timeout to 30min.=C2=A0</div></blockquote=
><div><br></div><div class=3D"gmail_default" style=3D"font-family:arial,hel=
vetica,sans-serif">Seems like a reasonable scenario.</div><div class=3D"gma=
il_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left=
:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D=
"auto"><br></div><div dir=3D"auto">Also application team getting an error, =
duplicate values violate constraint&#39;s. Is this error possible because o=
f pgbouncer lag ? Or sequences or pure application side issue?</div></div><=
/blockquote><div><br></div><div class=3D"gmail_default" style=3D"font-famil=
y:arial,helvetica,sans-serif">This requires actually debugging your system,=
 not generalities.=C2=A0 But &#39;pgbouncer lag&#39; doesn&#39;t really see=
m like a thing.=C2=A0 Concurrency timing issues are a thing to be aware of =
though.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvet=
ica,sans-serif"><br></div><div class=3D"gmail_default" style=3D"font-family=
:arial,helvetica,sans-serif">David J.</div><div class=3D"gmail_default" sty=
le=3D"font-family:arial,helvetica,sans-serif"><br></div></div></div>

--000000000000e5dfa1064f3448f8--