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.92) (envelope-from ) id 1j6GDS-0004kz-7z for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2020 16:04:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j6GCT-0000qr-29 for pgsql-hackers@arkaria.postgresql.org; Mon, 24 Feb 2020 16:03:17 +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 1j6GCS-0000qA-1l for pgsql-hackers@lists.postgresql.org; Mon, 24 Feb 2020 16:03:16 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j6GCM-0001am-Bj for pgsql-hackers@postgresql.org; Mon, 24 Feb 2020 16:03:14 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 42D3221470; Mon, 24 Feb 2020 11:03:09 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute7.internal (MEProxy); Mon, 24 Feb 2020 11:03:09 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding: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=fm2; bh=G4YnVttcsAehqvHY8dI/Kkzppkm+z5i0cDxrRaAhO Dw=; b=aBOdOhNoJoZVXgFiK7FdD7jr3Ul6/S5TlPGB1SHOcjGHuJHYiLKAY8ikz /6SDNjZVY88YAMprgsMZMeJXJc/NnMiFNmsKK2uveUI3JJFTVlkLvesvNz+Ky999 o1nYL6+++Ek/4aXTD+k2PTQS9Cp2DZbTgZB5M02ZjZLSTkP9KJG+0ARZBY6tZ8q3 wAfyY1zQBiOyrRFrxzA8Z+A6PlFuasGvEoNMp0KeBpk/KPSQliVMflXMCGtDESRu HYEmWY79jSGNz9dxgZk7luZzvswB8A9qxVc9iWK7BdtSlpzF4Vnj6uD1aYA9cqop dddbyQKrSg2xs9dWWz851mK8TyQiQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrledtgdekgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefuvfhfhfhokffffgggjggtgfesthejredttdefheenucfhrhhomheprfgvthgv rhcugfhishgvnhhtrhgruhhtuceophgvthgvrhdrvghishgvnhhtrhgruhhtsedvnhguqh hurggurhgrnhhtrdgtohhmqeenucffohhmrghinhepvdhnughquhgrughrrghnthdrtgho mhenucfkphepleefrddvgeefrdduheeirdduledunecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhdrvghishgvnhhtrhgruhhtsedv nhguqhhurggurhgrnhhtrdgtohhm X-ME-Proxy: Received: from april.pezone.net (p5df39cbf.dip0.t-ipconnect.de [93.243.156.191]) by mail.messagingengine.com (Postfix) with ESMTPA id 96825328005E; Mon, 24 Feb 2020 11:03:08 -0500 (EST) Subject: Re: client-side fsync() error handling To: Michael Paquier References: <20200212052819.GD1464@paquier.xyz> <0412a2fb-cbde-08c6-9ff2-cfab5c27a3b8@2ndquadrant.com> <20200213115245.GM1520@paquier.xyz> <4c1fb761-936c-056d-a542-fa37678465a9@2ndquadrant.com> <20200221041800.GC3260@paquier.xyz> Cc: pgsql-hackers From: Peter Eisentraut Organization: 2ndQuadrant Message-ID: Date: Mon, 24 Feb 2020 17:03:07 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <20200221041800.GC3260@paquier.xyz> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2020-02-21 05:18, Michael Paquier wrote: > On Thu, Feb 20, 2020 at 10:10:11AM +0100, Peter Eisentraut wrote: >> OK, added in new patch. > > Thanks, that looks good. committed >> The frontends do neither right now, or at least the error handling is very >> inconsistent and inscrutable. It would be possible in theory to add a retry >> option, but that would be a very different patch, and given what we have >> learned about fsync(), it probably wouldn't be widely useful. > > Perhaps. Let's have this discussion later if there are drawbacks > about changing things the way your patch does. If we don't do that, > we'll never know about it either and this patch makes things safer. yup -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services