Re: Quartz Scheduler + pgpool + PostgreSQL 12 = issues - Mailing list pgsql-admin

From Doug Reynolds
Subject Re: Quartz Scheduler + pgpool + PostgreSQL 12 = issues
Date
Msg-id 01000181b6f26940-f565d242-ccf8-4931-b5c2-081f7930f7cb-000000@email.amazonses.com
Whole thread Raw
In response to Quartz Scheduler + pgpool + PostgreSQL 12 = issues  (Sbob <sbob@quadratum-braccas.com>)
List pgsql-admin
Your developers need to fix the connection leaking in their Quartz scheduler code. Most likely, they aren’t releasing
theconnection. 

Sent from my iPhone

> On Jun 30, 2022, at 7:19 PM, Sbob <sbob@quadratum-braccas.com> wrote:
>
> All;
>
>
> I have a client that was using pgbouncer and PostgreSQL 12 relatively issue free, they recently deployed the quartz
schedulerand now the db is running out of max_connections on a regular basis. I have an outage scheduled to increase
max_connectionsbut I am concerned that quartz will simply use them up. 
>
>
> Has anyone else run into this? know of any fixes?
>
>
> Thanks in advance
>
>
>
>




pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Quartz Scheduler + pgpool + PostgreSQL 12 = issues
Next
From: Nikhil Shetty
Date:
Subject: Re: Long running backup preventing auto vacuum