That error means that you have a process that keeps the transaction open. I suppose you have connection pooling active?
The timeout can be caused by that but it is unlikely if you see it only sometimes ... It is more likely the other way around: you see that when a w2p thread blocks. Mic Il giorno 18/set/2011 13:30, "Bruno Rocha" <rochacbr...@gmail.com> ha scritto: > I realized a problem with postgres.. > > application sometimes goes in: > > postgres: rifarme rifarme 127.0.0.1(50602)* idle in transaction* > * > * > and keeps in this state for a long time even if I kill web2py application. > > Seems to me that at some place a commit or rollback could not be performed, > I just need to know where..