postgres idle in transaction

[Kenneth Gonsalves]

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?

--
regards

Kenneth Gonsalves
Associate, NRC-FOSS
law...@au-kbc.org
http://nrcfosshelpline.in/web/

[Christian Boos]

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?
>

I was not able to reproduce those "postgres idle in transaction" issues
that were already reported (#4347, #4987), but the upcoming 0.10.4
features an improved repository resync scheme and the old resync scheme
that it replaces was possibly the reason for those "idle in transaction"
connections, so I think it would be worth checking if this fixes the
problem for you.

We could probably prepare a 0.10.4rc1 package, but in the meantime you
can also install from sources, see:
http://trac.edgewall.org/wiki/TracDownload#Tracstable

-- Christian

[John Hampton]

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.

-John

[Kenneth Gonsalves]

w00t - it is working - thanks

[Brad Anderson]

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