Skip to Content.
Sympa Menu

en - Re: [sympa-users] DB Conections not being closed

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Glen Eustace <address@concealed>
  • To: Glen Eustace <address@concealed>
  • Cc: address@concealed
  • Subject: Re: [sympa-users] DB Conections not being closed
  • Date: Thu, 23 Mar 2017 09:19:23 +1300


> On 23/03/2017, at 9:11 AM, Glen Eustace (via sympa-users Mailing List)
> <address@concealed> wrote:
>
> I upgraded over the weekend to sympa-6.2.16-1.20170301.svn12976.RHEL6.x86_64
>
> Now sympa is consuming all of the postgresql connections on our DB server.
> It would appear that it is not closing connections related to lists that
> are sourced from the DB.
>
> For us this is quite serious as it takes the DB server out when the
> available connections are exhausted which then effects other services.

Looking in the DB activity table, the last query run on the connections is a
SELECT from subscriber_table returning bouncing users.

If that might help.

Glen.





Archive powered by MHonArc 2.6.19+.

Top of Page