Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id AC1B5632C5B for ; Tue, 4 May 2010 13:09:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 55591-02 for ; Tue, 4 May 2010 16:09:24 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web39702.mail.mud.yahoo.com (web39702.mail.mud.yahoo.com [209.191.106.48]) by mail.postgresql.org (Postfix) with SMTP id 067BC633392 for ; Tue, 4 May 2010 13:09:23 -0300 (ADT) Received: (qmail 37484 invoked by uid 60001); 4 May 2010 16:09:22 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1272989362; bh=4WZx43XvWQ5INx4V+AhFE1OTJmJ0ktEUY/FNiU3Dq1U=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=s34yHe3Ab2q5UilWPAbGH2q00wGIZ+VOzX6HQhqzD39LuNtHgF9sfjzY6YjgJPh6oGqevlKkgUQyNEQuIIxxLyKF+kwvj5P/QSJcqTqNKPNHreF1Cop4bPEEbNRkz43q3b1fAa7QIfrGLQf9XL/T8mJlQfliNmvNbhzMJ4gFLCA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=s4VUwOphIojJ29YH+SqeC1fGygavTysrgVBHRAJajfZCcVjf+g11W9aC24hUuIM+2ck3jeZPfZeNCtyeyj5/q73We9OyCKLjjPxOmve39AP6MWw5erKhi6h+nGqADXxZkpsIMHc/u5oG0/Bc1kec0I2iPbRuFEx7/p5hAcJDSbM=; Message-ID: <612199.37100.qm@web39702.mail.mud.yahoo.com> X-YMail-OSG: heZ4XukVM1lPcyxOT8Oyxdf4xvgPbIOKK_4Y09W785ED164 ieH9fO8Sj Received: from [64.126.29.122] by web39702.mail.mud.yahoo.com via HTTP; Tue, 04 May 2010 09:09:22 PDT X-Mailer: YahooMailClassic/10.1.11 YahooMailWebService/0.8.103.269680 Date: Tue, 4 May 2010 09:09:22 -0700 (PDT) From: Bob Lunney Subject: Re: Runaway Locks To: pgsql-admin@postgresql.org, Kamcheung Sham In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/41 X-Sequence-Number: 34514 If you're using Tomcat or some other Java container that does connection ma= nagement restart it and the lock should go away.=0A=0ABob Lunney=0A=0A--- O= n Fri, 4/30/10, Kamcheung Sham wrote:=0A=0A> From: Kam= cheung Sham =0A> Subject: [ADMIN] Runaway Locks=0A> To:= pgsql-admin@postgresql.org=0A> Date: Friday, April 30, 2010, 9:03 AM=0A> = =0A> I was connecting to Postgres 8.3 through JDBC. During my=0A> unit test= s, something when wrong and now leaving with the=0A> following locks in the= db:=0A> =0A> arc_dev=3D# select locktype, mode, relname,=0A> virtualtransa= ction, pid from pg_locks l join pg_class c on=0A> l.relation =3D c.oid;=A0 = =A0 =A0 =A0 =A0 =A0=0A> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=0A> =A0 =A0 =A0 =A0= =A0 =A0 =A0 =A0 =0A> locktype |=A0 =A0 =A0=A0=A0mode=A0 =A0=0A> =A0=A0=A0|= =A0 =A0 =A0 =A0 =A0=0A> relname=A0 =A0 =A0 =A0 =A0=A0=A0|=0A> virtualtransa= ction | pid=A0 =0A> ----------+------------------+-------------------------= ---+--------------------+------=0A> =0A> relation | AccessShareLock=A0 | pg= _locks=A0 =A0=0A> =A0 =A0 =A0 =A0 =A0 =A0=0A> =A0=A0=A0| 1/38=A0 =A0 =A0 = =A0 =A0=0A> =A0 =A0=A0=A0| 1816 =0A> relation | RowShareLock=A0 =A0=A0=A0|= =0A> hibernate_sequences=A0 =A0 =A0 =A0 |=0A> -1/2091555=A0 =A0 =A0 =A0=A0= =A0|=A0=0A> =A0 =A0 =0A> relation | RowExclusiveLock | hibernate_sequences= =A0=0A> =A0 =A0 =A0 | -1/2091555=A0 =A0 =A0=0A> =A0=A0=A0|=A0 =A0 =A0 =0A> = relation | AccessShareLock=A0 | pg_class_oid_index=A0=0A> =A0 =A0 =A0=A0=A0= | 1/38=A0 =A0 =A0=0A> =A0 =A0 =A0 =A0=A0=A0| 1816 =0A> relation | AccessSha= reLock=A0 |=0A> pg_class_relname_nsp_index | 1/38=A0 =A0 =A0 =A0=0A> =A0 = =A0 =A0=A0=A0| 1816 =0A> relation | AccessShareLock=A0 | pg_class=A0 =A0=0A= > =A0 =A0 =A0 =A0 =A0 =A0=0A> =A0=A0=A0| 1/38=A0 =A0 =A0 =A0 =A0=0A> =A0 = =A0=A0=A0| 1816=0A> (6 rows)arc_dev=3D# =0A> =0A> The locks on 'hibernate_s= equences' is causing any update to=0A> the locked row to hang. There is cur= rently no running=0A> database client process anymore (as I've restarted by= server=0A> a few times).=0A> =0A> My question is how do i kill the virtual= transaction and=0A> have the locks released?=0A> =0A> Thanks,=0A> kam=0A> = -- =0A> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)=0A> = To make changes to your subscription:=0A> http://www.postgresql.org/mailpre= f/pgsql-admin=0A> =0A=0A=0A