Re: "Stuck" query - Mailing list pgsql-general

From Tommy Gildseth
Subject Re: "Stuck" query
Date
Msg-id 48C8BF72.80704@usit.uio.no
Whole thread Raw
In response to Re: "Stuck" query  (Erik Jones <ejones@engineyard.com>)
List pgsql-general
Erik Jones wrote:
>
> On Sep 10, 2008, at 5:57 AM, Tommy Gildseth wrote:
>
>> Tom Lane wrote:
>>> Tommy Gildseth <tommy.gildseth@usit.uio.no> writes:
>>>> Richard Huxton wrote:
>
> For what it's worth, I've run into a situation similar to this with a
> client a couple time in the last week or two (I can't say identical as I
> don't know all of the details about the client end of your connection).
> Using the client port # you can use lsof in addition to netstat (lsof -i
> tcp:49004) to track down the client process.  In our case, the client
> process was a connection made via an ssh tunnel and was sitting in
> FIN_WAIT2 status.  Killing the client process individually made
> everything go away nicely without any kind of extra downtime necessary.


Thanks, I'll keep that in mind if/when it happens again.


--
Tommy Gildseth

pgsql-general by date:

Previous
From: "Tobias Anstett"
Date:
Subject: How to check if an array is empty
Next
From: "Dave Page"
Date:
Subject: Re: postgres user account on OSX