X-Original-To: pgsql-bugs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BE19C474E4F for ; Fri, 21 Mar 2003 23:17:55 -0500 (EST) Received: from stone.congenomics.com (stone.congenomics.com [65.160.254.44]) by postgresql.org (Postfix) with ESMTP id 0AB02474E42 for ; Fri, 21 Mar 2003 23:17:55 -0500 (EST) Received: from stone.congenomics.com (localhost [127.0.0.1]) by stone.congenomics.com (SGI-8.12.5/8.12.5) with ESMTP id h2M4P42W003651; Fri, 21 Mar 2003 23:25:04 -0500 (EST) Received: (from bruc@localhost) by stone.congenomics.com (SGI-8.12.5/8.12.5/Submit) id h2M4OrWl003648; Fri, 21 Mar 2003 23:24:53 -0500 (EST) From: "Robert E. Bruccoleri" Message-Id: <200303220424.h2M4OrWl003648@stone.congenomics.com> Subject: Re: Bug report To: tgl@sss.pgh.pa.us (Tom Lane) Date: Fri, 21 Mar 2003 23:24:53 -0500 (EST) Cc: bruc@acm.org, pgsql-bugs@postgresql.org Reply-To: bruc@acm.org In-Reply-To: <10123.1048224874@sss.pgh.pa.us> from "Tom Lane" at Mar 21, 3 00:34:34 am X-Mailer: ELM [version 2.4 PL25 ME8b] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-19.5 required=5.0 tests=EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REPLY_WITH_QUOTES autolearn=ham version=2.50-cvs X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50-cvs (1.172-2003-02-14-exp) X-Archive-Number: 200303/137 X-Sequence-Number: 5697 Dear Tom, > > > "Robert E. Bruccoleri" writes: > > The PostgreSQL backend core dumps reproducibly with a set of LOCK commands that > > would normally deadlock. > > Can't duplicate that here, using either 7.3 branch or CVS tip. You sure > you have a clean build? Oh yes, the regression tests all pass, and we've been using the system heavily. What's different about this case in our shop is the heavy use of constraints. If I gave you access to an SGI running PostgreSQL 7.3.2, would you be willing to log in and explore the problem "live"? If so, I will set this up for you. Regards, Bob +-----------------------------+------------------------------------+ | Robert E. Bruccoleri, Ph.D. | email: bruc@acm.org | | President, Congenomics Inc. | URL: http://www.congen.com/~bruc | | P.O. Box 314 | Phone: 609 818 7251 | | Pennington, NJ 08534 | | +-----------------------------+------------------------------------+