Kenneth Gonsalves wrote:
> 
> On 30-Mar-07, at 9:28 PM, John Hampton wrote:
> 
>> Christian Boos wrote:
>>> Kenneth Gonsalves wrote:
>>>> hi,
>>>> i have been running trac .10 with postgres on a debian sarge box  
>>>> with
>>>> apache2 and mod_python. My box is freezing and i am finding hundreds
>>>> of processes or postgres idle in transaction from the trac database.
>>>> Is this a trac problem? any clues as what to do?
>> The other option is to set poolable = False in the
>> trac/db/postgres_backend.py.  Just look for the line that says  
>> poolable
>> =True and switch it to False.  Then restart your server.  That cleared
>> up the 'idle in transaction' processes for me.
> 
> w00t - it is working - thanks
> 

Cool.  Please note that even after I set poolable = False I would still get
the error on occasion.  I have yet to update my PROD server with Christian's
fix for multiple sync's, and when I do, hopefully the issue goes away forever.

BA

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to