From: Nathan Bossart <nathandbossart@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: USE_BARRIER_SMGRRELEASE on Linux?
Date: Tue, 15 Feb 2022 22:14:04 -0800
Message-ID: <20220216061404.GA2813338@nathanxps13> (raw)
In-Reply-To: <20220216050645.7u3nguccykpqaw7p@alap3.anarazel.de>
References: <20220215235845.GA2665318@nathanxps13>
<CA+hUKGJxb5ug=sBL=S8WMsFg4mojccy8p1VWqXYEz4MSre_vGA@mail.gmail.com>
<CA+hUKG+Ye6kBWkm9kjMhvAvO0gyrEy=q3rm05XSmZ2ah6auQNw@mail.gmail.com>
<20220216045911.GA2791824@nathanxps13>
<20220216050645.7u3nguccykpqaw7p@alap3.anarazel.de>
On Tue, Feb 15, 2022 at 09:06:45PM -0800, Andres Freund wrote:
> On 2022-02-15 20:59:11 -0800, Nathan Bossart wrote:
>> On Wed, Feb 16, 2022 at 03:34:08PM +1300, Thomas Munro wrote:
>> > So it's not getting unlinked until the *next* checkpoint cycle. I
>> > don't know why.
>>
>> On my machine (5.11.0-43), it looks like the test starts failing after
>> cc50080. That commit adjusted some regression tests, so I'm assuming it's
>> not the root cause.
>
> That makes some sense. Before that we didn't create database objects before
> tablespace.sql. A scheduling like this that could make some pre-existing
> issues much more visible.
>
> I think we also saw the windows drop tablespace issues less commonly than
> recently (outside the aio tree at least)...
It looks like register_unlink_segment() is called prior to the checkpoint,
but the checkpointer is not calling RememberSyncRequest() until after
SyncPreCheckpoint(). This means that the requests are registered with the
next checkpoint cycle count, so they aren't processed until the next
checkpoint.
--
Nathan Bossart
Amazon Web Services: https://aws.amazon.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: nathandbossart@gmail.com, andres@anarazel.de, thomas.munro@gmail.com
Subject: Re: USE_BARRIER_SMGRRELEASE on Linux?
In-Reply-To: <20220216061404.GA2813338@nathanxps13>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox