Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goHSF-0000BX-Om for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jan 2019 00:40:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1goHSE-00027h-He for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Jan 2019 00:40:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goHSE-00026o-7H for pgsql-hackers@lists.postgresql.org; Tue, 29 Jan 2019 00:40:42 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1goHSB-0002Ut-Vx for pgsql-hackers@postgresql.org; Tue, 29 Jan 2019 00:40:41 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 2DB3922269; Mon, 28 Jan 2019 19:40:39 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute5.internal (MEProxy); Mon, 28 Jan 2019 19:40:39 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm3; bh=SsrSDyvQXagi+XXa8J151qhF0LA ynubs5z/uZc5q0Us=; b=S+8jQJ+OPI1IjS4+E6s70KuA2xFpCEBxdyZAcZIRW9t vMJFHFzoadUlF2cfWjSiGBs/hCNCXwBHIgw+IF3/SkOanxe7ARjScC9pU9sImgBp eylErZ/9QGvt5vtFI+4Ln+3rUsX5YilMLWDGn8gNfhlojQLc0iuXaO2Gj7deLX6M 1IcSr53A9KY2wPSJp4M3/FjKrFeIu/Mf35qEPfMzELin+FPQgpFBF0XCr6qEvP1q HweSvUoxvIgYU0z5xZfeiv/rCOszWkI2cgmN+u32GkATmPBncBd9XJC+LNJiqFVW GtZc4rw/g2E6t/QAZ3KRL6bPHTqCRCnsVJY9NMXcXAw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=SsrSDy vQXagi+XXa8J151qhF0LAynubs5z/uZc5q0Us=; b=qAVV98FQOTeRDzq2N7/nYz nzmeGoKldad/L19puVh/g0aAtesH1N5DKStjkGUSnaKYSuCCwXSDkgF1IY7cF+i5 vT1pfpJH6ZE9aKFIDfQVp1nyGHUbr1SFV//SXjPEidHpTfP5mOsp20/5hYBUG5Ax +2cANvRihNlyQcaouecAz5tsUd5dgXBpfJ7zJUcnyii6ASWjwHXMXo1Ghedn6pOl SI9CSR03BuoF0HRj8L6NJVrT9aYEHP6Pp33urHEhQuYq6hA2A7lYMJYzapizxgdV /pdccVLPrYgNkbll+U1pEyhK230/bM+2xEyVdCuJI4XINO+GuoWnD59ANQA+0kxQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedtledrjedugddvhecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfhuthenuceurghilhhouhhtmecufedt tdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujfgurhepfffhvffukfhfgg gtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgvshcuhfhrvghunhguuceorghn ughrvghssegrnhgrrhgriigvlhdruggvqeenucfkphepleekrddvuddtrddugedtrdduje dunecurfgrrhgrmhepmhgrihhlfhhrohhmpegrnhgurhgvshesrghnrghrrgiivghlrdgu vgenucevlhhushhtvghrufhiiigvpedt X-ME-Proxy: Received: from intern.anarazel.de (c-98-210-140-171.hsd1.ca.comcast.net [98.210.140.171]) by mail.messagingengine.com (Postfix) with ESMTPA id 46E21100BB; Mon, 28 Jan 2019 19:40:38 -0500 (EST) Date: Mon, 28 Jan 2019 16:40:36 -0800 From: Andres Freund To: Tom Lane Cc: Robert Haas , "pgsql-hackers@postgresql.org" , Amit Kapila Subject: Re: Why are we PageInit'ing buffers in RelationAddExtraBlocks()? Message-ID: <20190129004036.c2cf3fxoescf2rvf@alap3.anarazel.de> References: <13071.1545266373@sss.pgh.pa.us> <20181220005636.cowkudhiu666mhdi@alap3.anarazel.de> <20181220230411.zzwioucrg7d3ld2m@alap3.anarazel.de> <20190115204428.kpqmk3ix6cenr7gi@alap3.anarazel.de> <11587.1547591721@sss.pgh.pa.us> <20190128213346.ie6zbwiddgnfd37l@alap3.anarazel.de> <20190128221055.nddkrusu3u5263qo@alap3.anarazel.de> <20190128222259.zhi7ovzgtkft6em6@alap3.anarazel.de> <26263.1548716939@sss.pgh.pa.us> <20190128234933.ioateictsk3qmsuf@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20190128234933.ioateictsk3qmsuf@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, On 2019-01-28 15:49:33 -0800, Andres Freund wrote: > On 2019-01-28 18:08:59 -0500, Tom Lane wrote: > > Andres Freund writes: > > > I'm inclined to put back the > > > LockBuffer(buf, BUFFER_LOCK_UNLOCK); > > > LockRelationForExtension(onerel, ExclusiveLock); > > > UnlockRelationForExtension(onerel, ExclusiveLock); > > > LockBufferForCleanup(buf); > > > if (PageIsNew(page)) > > > dance regardless, just to get the buildfarm to green? > > > > The buildfarm's got half a dozen reports now of a failure of this ilk, > > so you'd better do something. > > Yea, I was working on a patch. Was trying to come up with an explanation > of how this can be realistically hit on the BF, but failed. I've pushed > something now, let's see whether that fixes it. It has not. Given that I don't understand what's happening here I'm going to revert both commits unless I figure it out in the next ~30min. Greetings, Andres Freund