Re: BUG #15667: "could not truncate file" error caused deleted rowsto become visible - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #15667: "could not truncate file" error caused deleted rowsto become visible
Date
Msg-id 20190306030459.coyyy2uymbfipm4g@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #15667: "could not truncate file" error caused deleted rowsto become visible  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #15667: "could not truncate file" error caused deleted rows to become visible  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi,

On 2019-03-06 11:56:26 +0900, Michael Paquier wrote:
> Windows is not concurrent safe by default when it comes to handle
> writes, and Postgres uses a wrapper for open() which makes use of some
> concurrent-safe options when handling files to avoid such problems.

I don't think this has anything to do with the problem. Isn't this the
known problem around truncation that Tom has recently talked about fixing?

[1] https://www.postgresql.org/message-id/2348.1544474335%40sss.pgh.pa.us

Greetings,

Andres Freund


pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #15667: "could not truncate file" error caused deleted rowsto become visible
Next
From: Tom Lane
Date:
Subject: Re: BUG #15667: "could not truncate file" error caused deleted rows to become visible