Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 88CEE6335A9 for ; Thu, 18 Mar 2010 18:02:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 17826-07 for ; Thu, 18 Mar 2010 21:02:37 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id D0A09632277 for ; Thu, 18 Mar 2010 18:02:41 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Thu, 18 Mar 2010 16:02:39 -0500 Message-Id: <4BA24E99020000250002FF13@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Thu, 18 Mar 2010 16:02:33 -0500 From: "Kevin Grittner" To: "Danny Abraham" , "pgsql-admin@postgresql.org" Subject: Re: WHo is locking me? References: <2C0926ABD16BB641A8E2F11A54920042142DE2F599@PHXCCRPRD01.adprod.bmc.com> In-Reply-To: <2C0926ABD16BB641A8E2F11A54920042142DE2F599@PHXCCRPRD01.adprod.bmc.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.458 tagged_above=-10 required=5 tests=AWL=0.141, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/128 X-Sequence-Number: 33927 "Abraham, Danny" wrote: > procpid | current_query > ---------+--------------------------------------------------------------------- > 25936 | in transaction <== This is the locker > - What exactly is the locker doing? At the time you ran that, it wasn't doing anything in the database, but it had not committed or rolled back the transaction it had previously started. > - Can I retrieve the Client PID somewhere (then by process name I > will dive into the code). If you're on Linux and this is a TCP connection, netstat should make that easy. Are you? -Kevin