X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 365ED8BA26C for ; Mon, 21 Feb 2005 15:49:17 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11799-06 for ; Mon, 21 Feb 2005 15:49:03 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.195]) by svr1.postgresql.org (Postfix) with ESMTP id 6282A8BAFD8 for ; Mon, 21 Feb 2005 15:49:06 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id j1so300354rnf for ; Mon, 21 Feb 2005 07:49:07 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=MnKQolpVZPB26DyjP9tXXyy463rC+LvJPSZA3LC15PRdbT+IvaLe3nAlk1ucmGXGHxvo5LEN34wVKMl8Y+Vrx49CiAi1KV/WsOUVp872E2zC/VR6gFvVUklRXUSY5cJ2E9O2KE0ZBg5bkNKFFKzr7t+KIcNVulKv6SA1DnTRB/Q= Received: by 10.38.92.1 with SMTP id p1mr43913rnb; Mon, 21 Feb 2005 07:49:07 -0800 (PST) Received: by 10.38.97.43 with HTTP; Mon, 21 Feb 2005 07:49:06 -0800 (PST) Message-ID: <674d1f8a0502210749f113d7a@mail.gmail.com> Date: Mon, 21 Feb 2005 21:19:06 +0530 From: Gourish Singbal Reply-To: Gourish Singbal To: Michael Fuhr Subject: Re: ERROR: 40P01: Cc: PostgreSQL Admin In-Reply-To: <20050217155138.GA26078@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <674d1f8a0502170354692cca73@mail.gmail.com> <20050217155138.GA26078@winnie.fuhr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.077 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/191 X-Sequence-Number: 16359 The DETAIL part is:- DETAIL: Process 17593 waits for AccessExclusiveLock on relation 1571110842 of database 917916301; blocked by process 17868. DETAIL: Process 25284 waits for AccessShareLock on relation 1613149934 of database 917916301; blocked by process 25010. the deadlock was from the application end. How can we release such locks?. regards gourish On Thu, 17 Feb 2005 08:51:38 -0700, Michael Fuhr wrote: > On Thu, Feb 17, 2005 at 05:24:10PM +0530, Gourish Singbal wrote: > > > I got the below ERROR in my log file. Where can i get more info no > > what exactly caused this ERROR and how to debug it?. > > > > 2005-02-17 02:23:09 ERROR: 40P01: deadlock detected > > 2005-02-17 02:23:09 ERROR: 25P02: current transaction is aborted, > > commands ignored until end of transaction block > > Application code must be failing somewhere -- aren't you seeing > those problems? Or do the applications not perform enough error > checking and reporting? > > On the server side, if you're running 7.3 or later then you could > use log_min_error_statement. See the "Run-time Configuration" > section in the "Server Run-time Environment" chapter of the > documentation, in particular "Error Reporting and Logging" (or > "Logging and Debugging," depending on the version). > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > -- Best, Gourish Singbal