Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id ED1819F99B7 for ; Wed, 19 Sep 2007 13:22:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 27223-03 for ; Wed, 19 Sep 2007 13:21:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cronos.madness.at (madness.at [217.196.146.217]) by postgresql.org (Postfix) with ESMTP id 1323B9F9B6B for ; Wed, 19 Sep 2007 13:21:49 -0300 (ADT) Received: from mastermind.kaltenbrunner.cc ([83.215.233.60]) by cronos.madness.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1IY2J2-0005Md-GW; Wed, 19 Sep 2007 18:21:46 +0200 Message-ID: <46F14C93.4040908@kaltenbrunner.cc> Date: Wed, 19 Sep 2007 18:21:39 +0200 From: Stefan Kaltenbrunner User-Agent: Icedove 1.5.0.12 (X11/20070607) MIME-Version: 1.0 To: Andrew Dunstan CC: Tom Lane , pgsql-hackers@postgreSQL.org Subject: Re: curious regression failures (was Re: [PATCHES] PL/TCL Patch to prevent postgres from becoming multithreaded) References: <200709141720.l8EHKwX13792@momjian.us> <87bqc5m90n.fsf@oxford.xeocode.com> <12919.1189792669@sss.pgh.pa.us> <46EADA0A.3040504@kaltenbrunner.cc> <12435.1189821208@sss.pgh.pa.us> <46EC07E7.9000100@kaltenbrunner.cc> <28630.1189875785@sss.pgh.pa.us> <46ED527A.4090108@kaltenbrunner.cc> <20616.1190214860@sss.pgh.pa.us> <46F1468F.1080903@dunslane.net> In-Reply-To: <46F1468F.1080903@dunslane.net> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/793 X-Sequence-Number: 107945 Andrew Dunstan wrote: > > > Tom Lane wrote: >> Stefan Kaltenbrunner writes: >> >>> Tom Lane wrote: >>> >>>> Stefan Kaltenbrunner writes: >>>> >>>>> ! ERROR: could not read block 2 of relation 1663/16384/2606: read >>>>> only 0 of 8192 bytes >>>>> >>>> Is that repeatable? What sort of filesystem are you testing on? >>>> (soft-mounted NFS by any chance?) >>>> >> >> >>> doesn't seem to be repeatable :-( >>> >> >> Hmm ... >> http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=luna_moth&dt=2007-09-19%2013:10:01 >> >> >> Exact same error --- is it at the same place in the tests where you >> saw it? >> >> Now that I think about it, there have been similar transient failures >> ("read only 0 of 8192 bytes") in the buildfarm before. It would be >> helpful to collect a list of exactly which build reports contain >> that string, but AFAIK there's no very easy way to do that; Andrew, >> any suggestions? >> >> >> > > pgbfprod=# select sysname, stage, snapshot from build_status where log ~ > $$read only \d+ of \d+ bytes$$; > sysname | stage | snapshot > -----------+--------------+--------------------- > zebra | InstallCheck | 2007-09-11 10:25:03 > wildebeest | InstallCheck | 2007-09-11 22:00:11 > baiji | InstallCheck | 2007-09-12 22:39:24 > luna_moth | InstallCheck | 2007-09-19 13:10:01 hmm all of those seem to fail the foreign key checks in a very similiar way and that are vastly different platforms (windows,solaris,openbsd and linux). Stefan