| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Raj <rajeshkumar(dot)dba09(at)gmail(dot)com> |
| Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Pgbouncer error |
| Date: | 2026-04-11 19:30:02 |
| Message-ID: | CAKFQuwbaP1RNZe0eFrj=euKL7snDfKxM6Zt-UEVBrkstqmmd2Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Apr 11, 2026 at 12:16 PM Raj <rajeshkumar(dot)dba09(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raj | 2026-04-13 12:55:48 | Slowness |
| Previous Message | Raj | 2026-04-11 19:16:22 | Pgbouncer error |