Re: Redux: Re: [Exim] Memory issues with pgsql interface

Top Page
Delete this message
Reply to this message
Author: bazyar
Date:  
To: exim-users
Subject: Re: Redux: Re: [Exim] Memory issues with pgsql interface
Philip,

Ok, I'm running 3.16.

This mysql connection thing - would a connection be made (and not closed)
once per sub process? If just once, I don't see how that could cause the
exim process in question to grow to 250M.

Last night I worked around the problem by using the "exim -bs" trick and
breaking the delivery of the list up into 100-user chunks. That has other
benefits besides avoiding the mysql memory issue.

Jawaid

--

On Thu, 11 Jul 2002, Philip Hazel wrote:

> On Thu, 11 Jul 2002 Jawaid.Bazyar@??? wrote:
>
> > No, however I have come across the same behavior with the mysql interface
> > and a mailing list of similar size.
> >
> > My investigation indicated that it was only when the queue runner tried to
> > do a delivery attempt on that specific message that the problem occurred.
> >
> > Was this investigated? Is there a fix?
>
> Which release of Exim?
>
> > On Fri, 19 Oct 2001, Gavin Sherry wrote:
>
> Can't have been later than 3.33. There was this fix for 3.32, which
> could be relevant:
>
> 6. If a delivery in a subprocess (local or remote) opened a connection to (for
> example) an MySQL server, that connection never got properly closed because the
> cleanup function was called only in the main process. Calls to the tidyup
> function have been added to the subprocesses.


--
 Jawaid Bazyar                 |   Affordable WWW & Internet Solutions
 foreThought.net               |   for Small Business
 jawaid.bazyar@??? |   910 16th Street, #1220  (303) 228-0070
 --The Future is Now!--        |   Denver, CO 80202        (303) 228-0077 fax