X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A5B433A5050 for ; Sat, 22 Jan 2005 23:45:53 +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 23684-06 for ; Sat, 22 Jan 2005 23:45:41 +0000 (GMT) Received: from openvistas.net (heinlein.openvistas.net [12.10.247.92]) by svr1.postgresql.org (Postfix) with SMTP id 64B2C3A4F60 for ; Sat, 22 Jan 2005 23:45:42 +0000 (GMT) Received: (qmail 687 invoked by uid 1000); 22 Jan 2005 23:45:41 -0000 Received: from [192.168.1.9] (rand.openvistas.net [12.10.247.87]) by heinlein.openvistas.net (tmda-ofmipd) with ESMTP; Sat, 22 Jan 2005 16:45:14 -0700 (MST) Mime-Version: 1.0 (Apple Message framework v619) In-Reply-To: <200501222301.j0MN1BD09511@candle.pha.pa.us> References: <200501222301.j0MN1BD09511@candle.pha.pa.us> Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: Content-Transfer-Encoding: 7bit Subject: 8.0.0 on disk fails regress test, but on ram disk it is fine... Date: Sat, 22 Jan 2005 16:45:33 -0700 To: pgsql-bugs@postgresql.org X-Mailer: Apple Mail (2.619) From: Jeff Ross X-Delivery-Agent: TMDA/1.0 (Cannonade) X-Primary-Address: jross@openvistas.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.312 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200501/280 X-Sequence-Number: 10713 I'm preparing to upgrade our PostgreSQL installation from 7.3.5 to 8.0.0. I downloaded, configured, compiled, and did gmake check and much to my surprise, 26 of the 96 tests failed. Examination of regression.diffs shows that 1 of the failures is random (and it is ignored) but 23 of the 26 errors are: ! psql: could not send startup packet: Broken pipe Interestingly enough, if I load the source code onto a 1GB ram disk and configure, compile and check it there, all 96 tests pass. Hardware is RAID 1 using 2 disks with one additional disk as a hot spare, dual 2.66 GHz Xeon processors with 2 GB of RAM. Operating system is OpenBSD 3.6. I'm a little leary of upgrading my PostgreSQL installation with those kind of failure rates. I'd appreciate any insight as to why so many tests would fail when run on disk and pass when run in ram. Thanks, Jeff Ross