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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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