Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 76A6D9FBD9A for ; Wed, 9 May 2007 08:50:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 82764-01 for ; Wed, 9 May 2007 08:50:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from p15105778.pureserver.info (p15105778.pureserver.info [217.160.133.184]) by postgresql.org (Postfix) with ESMTP id EB5169FBDE1 for ; Wed, 9 May 2007 08:50:10 -0300 (ADT) Received: by p15105778.pureserver.info (Postfix, from userid 65534) id 4E648440D5; Wed, 9 May 2007 13:50:44 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by server1.proventis.net (Postfix) with ESMTP id 152E9C44291 for ; Wed, 9 May 2007 13:50:08 +0200 (CEST) Received: from server1.proventis.net ([127.0.0.1]) by localhost (server1.proventis.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24910-06 for ; Wed, 9 May 2007 13:50:07 +0200 (CEST) Received: from [192.168.22.130] (tmarkus.proventis.net [192.168.22.130]) by server1.proventis.net (Postfix) with ESMTP id B7C1EC44290 for ; Wed, 9 May 2007 13:50:07 +0200 (CEST) Message-ID: <4641B56F.3030906@proventis.net> Date: Wed, 09 May 2007 13:50:07 +0200 From: Thomas Markus Organization: proventis GmbH User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: infinite blocking statements in 8.2.3 References: <46384CEA.9080906@proventis.net> In-Reply-To: <46384CEA.9080906@proventis.net> Content-Type: multipart/mixed; boundary="------------080302040409050609060809" X-Virus-Scanned: by amavisd-new at proventis.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/71 X-Sequence-Number: 25391 This is a multi-part message in MIME format. --------------080302040409050609060809 Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit my problem is back :( ps shows a SELECT i tried to cancel that blocking statement with |pg_cancel_backend|(pid). after that ps show 'idle in transaction'. a simple kill doesn't help. i did a pg_ctl -m immediate stop. Postgres is away however the dead process is further present. I can stop these also only with kill -9. Does someone have an idea where the problem is and as I this to avoid can? thx Thomas Thomas Markus schrieb: > I'm running 8.2.3 on ubuntu 6.06 (2.6.15-26-server SMP i686) > > sometimes i have SELECTs that never ends. Normally I drop connections > by killing the connection process (kill ). But these hanging > connections (which blocks other statements infinitly) cant be killed. > the only way is a pg_ctl -m immediate stop or a brutal kill -9 --------------080302040409050609060809 Content-Type: text/x-vcard; charset=utf-8; name="t.markus.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="t.markus.vcf" begin:vcard fn:Thomas Markus n:Markus;Thomas org:proventis GmbH adr:;;Zimmerstr. 79-80;Berlin;Berlin;10117;Germany email;internet:t.markus@proventis.net tel;work:+49 30 29 36 399 22 x-mozilla-html:FALSE url:http://www.proventis.net version:2.1 end:vcard --------------080302040409050609060809--