Re: Idle in transaction help

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Scot Kreienkamp <SKreien(at)la-z-boy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Idle in transaction help
Date: 2009-07-10 23:02:16
Message-ID: dcc563d10907101602y61c5000av6548e9251d199d9d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 10, 2009 at 4:40 PM, Scot Kreienkamp<SKreien(at)la-z-boy(dot)com> wrote:
> Thanks scott, but I wrote a cgi to combine all of the process info and allow
> me to kill errant queries. So I know how to track down the pid. Thanks for
> trying to help though. :-)

So, what are you looking for, a stack trace dump from java to look
through maybe? (the one that kill -1 or whatever generates? It's been
a few years.) That'll usually give you the context to find out which
thread is where. P.s. no need to pat me on the head like the doggie.
:)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Janet Jacobsen 2009-07-10 23:05:17 Re: change location of postmaster.pid file?
Previous Message James B. Byrne 2009-07-10 22:58:48 Re: BR/