Skip site navigation (1) Skip section navigation (2)

Re: Very long "<IDLE> in transaction" query

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu>
Cc: <pgsql-admin(at)postgresql(dot)org>, "'Albe Laurenz'" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Subject: Re: Very long "<IDLE> in transaction" query
Date: 2012-05-04 13:57:08
Message-ID: 4FA399E40200002500047870@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
"ktm(at)rice(dot)edu" <ktm(at)rice(dot)edu> wrote:
 
> You may also want to consider setting a statement_timeout to
> prevent this until you can find the problem with the application.
 
How would a statement timeout help close a transaction on an idle
connection?  It's idle because no statements are being run.
 
-Kevin

In response to

Responses

pgsql-admin by date

Next:From: ktm@rice.eduDate: 2012-05-04 15:05:53
Subject: Re: Very long "<IDLE> in transaction" query
Previous:From: Thomas KellererDate: 2012-05-04 13:50:06
Subject: Re: Getting "ident" to work in Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group