Re: Getting stuck in transactions

On Tue, Mar 10, 2009 at 5:10 PM, Tom Davis wrote: > I have a command-line script that uses Django's ORM. For reasons > beyond my comprehension, it has a tendency to get "stuck" in > transactions. When I check the postgre server status, it simply shows > a connection that is

Re: Getting stuck in transactions

Hi, here some thoughts how to debug this: In postgres enable the logging of the executed statements. On my system they go to /var/log/messsages. Which statement is the last? Are there any other db clients which access the database? Or are you connecting from the same python script? Which

Getting stuck in transactions

I have a command-line script that uses Django's ORM. For reasons beyond my comprehension, it has a tendency to get "stuck" in transactions. When I check the postgre server status, it simply shows a connection that is "idle in transaction" and never completes. The script ends up hitting this wall