Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2A1F99F926B for ; Wed, 19 Sep 2007 12:56:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43119-05 for ; Wed, 19 Sep 2007 12:55:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from cdptpa-omtalb.mail.rr.com (cdptpa-omtalb.mail.rr.com [75.180.132.121]) by postgresql.org (Postfix) with ESMTP id 1C9969FA015 for ; Wed, 19 Sep 2007 12:55:59 -0300 (ADT) Received: from [192.168.10.103] (really [69.134.97.109]) by cdptpa-omta01.mail.rr.com with ESMTP id <20070919155559.KFZB4058.cdptpa-omta01.mail.rr.com@[192.168.10.103]>; Wed, 19 Sep 2007 15:55:59 +0000 Message-ID: <46F1468F.1080903@dunslane.net> Date: Wed, 19 Sep 2007 11:55:59 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.8.0.12) Gecko/20070719 Fedora/1.0.9-2.fc6 pango-text SeaMonkey/1.0.9 MIME-Version: 1.0 To: Tom Lane CC: Stefan Kaltenbrunner , 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> In-Reply-To: <20616.1190214860@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/791 X-Sequence-Number: 107943 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 (4 rows) cheers andrew