Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fv7Ex-0000XJ-Qz for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Aug 2018 20:38:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fv7Ew-0007F5-5N for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Aug 2018 20:38:58 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fv7Ev-0007Es-Ma for pgsql-hackers@lists.postgresql.org; Wed, 29 Aug 2018 20:38:57 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fv7Es-0006bj-Mx for pgsql-hackers@lists.postgresql.org; Wed, 29 Aug 2018 20:38:56 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id w7TKcnWO032049; Wed, 29 Aug 2018 16:38:49 -0400 From: Tom Lane To: Andres Freund cc: Tomas Vondra , Peter Geoghegan , PostgreSQL Hackers Subject: Re: buildfarm: could not read block 3 in file "base/16384/2662": read only 0 of 8192 bytes In-reply-to: <20180829194527.ohfvlswk2g3fkma7@alap3.anarazel.de> References: <20180811140823.gyxqbtjbr5uitgsf@alap3.anarazel.de> <20180828075213.yqyl3w2gpd5heopd@alap3.anarazel.de> <20180829025658.brk3hfdczo3f73al@alap3.anarazel.de> <6970.1535512705@sss.pgh.pa.us> <20180829032714.6yu3bxdywcvyj2li@alap3.anarazel.de> <20180829032908.o46wdjmti6c6dfep@alap3.anarazel.de> <20180829083730.n645apqhb2gyih3g@alap3.anarazel.de> <17825.1535556627@sss.pgh.pa.us> <22112.1535561767@sss.pgh.pa.us> <20180829194527.ohfvlswk2g3fkma7@alap3.anarazel.de> Comments: In-reply-to Andres Freund message dated "Wed, 29 Aug 2018 12:45:27 -0700" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <32047.1535575129.1@sss.pgh.pa.us> Date: Wed, 29 Aug 2018 16:38:49 -0400 Message-ID: <32048.1535575129@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Andres Freund writes: > On 2018-08-29 12:56:07 -0400, Tom Lane wrote: >> BTW, I now have a theory for why we suddenly started seeing this problem >> in mid-June: commits a54e1f158 et al added a ScanPgRelation call where >> there had been none before (in RelationReloadNailed, for non-index rels). >> That didn't create the problem, but it probably increased the odds of >> seeing it happen. > Yea. Doesn't explain why it's only really visible on the BF in > 11/master though :/ Probably we changed around the tests that run in parallel with vacuum.sql enough during v11 to make it happen with noticeable probability. I think this is sufficient evidence that it's happening now in the back branches: https://www.postgresql.org/message-id/20180829140149.GO23024@telsasoft.com regards, tom lane