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 192258B9E95 for ; Thu, 17 Feb 2005 15:37:24 +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 40198-08 for ; Thu, 17 Feb 2005 15:37:18 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3D9B18B9E04 for ; Thu, 17 Feb 2005 15:37:22 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1HFbGP6007233; Thu, 17 Feb 2005 10:37:16 -0500 (EST) To: Gourish Singbal Cc: PostgreSQL Admin Subject: Re: ERROR: 40P01: In-reply-to: <674d1f8a0502170354692cca73@mail.gmail.com> References: <674d1f8a0502170354692cca73@mail.gmail.com> Comments: In-reply-to Gourish Singbal message dated "Thu, 17 Feb 2005 17:24:10 +0530" Date: Thu, 17 Feb 2005 10:37:16 -0500 Message-ID: <7232.1108654636@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/156 X-Sequence-Number: 16324 Gourish Singbal writes: > 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 You seem to have suppressed the DETAIL part of that message. It should have reported something like DETAIL: Process 7205 waits for AccessExclusiveLock on relation 1096910 of database 994178; blocked by process 7199. Process 7199 waits for AccessExclusiveLock on relation 1100110 of database 994178; blocked by process 7205. regards, tom lane