Date: Thu, 28 Nov 2019 16:14:50 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: checkpointer: PANIC: could not fsync file: No such file or
 directory
Message-ID: <20191128221450.GE16647@telsasoft.com>
References: <20191119115759.GI30362@telsasoft.com>
 <CA+hUKG+cTv=SujoL6wW7YH_vVkVOYJ14+9w+AxYBnRLdVSf-YQ@mail.gmail.com>
 <20191119224910.GU30362@telsasoft.com>
 <20191120012226.GW30362@telsasoft.com>
 <20191121010703.GF30362@telsasoft.com>
 <20191125212436.GA20096@telsasoft.com>
 <CA+hUKGKNsD4ygN6k2VB0cv=gKMfnCuJVwAxrhg0vYYJN5MH40A@mail.gmail.com>
 <20191127065313.GU16647@telsasoft.com>
 <CA+hUKGLPAab-5nVDP97nh1jaOpXL5Zm1XpgG8W=NgaOW9_0aYA@mail.gmail.com>
 <CA+hUKGLw0RnKguqVvyWsJJR+2KHR9AyBqhbOuzdHjq9_XPokzA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+hUKGLw0RnKguqVvyWsJJR+2KHR9AyBqhbOuzdHjq9_XPokzA@mail.gmail.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk

On Fri, Nov 29, 2019 at 10:50:36AM +1300, Thomas Munro wrote:
> On Fri, Nov 29, 2019 at 3:13 AM Thomas Munro <thomas.munro@gmail.com> wrote:
> > On Wed, Nov 27, 2019 at 7:53 PM Justin Pryzby <pryzby@telsasoft.com> wrote:
> > >  2019-11-26 23:41:50.009-05 | could not fsync file "pg_tblspc/16401/PG_12_201909212/16460/973123799.10": No such file or directory
> >
> > I managed to reproduce this (see below).  I think I know what the
> 
> Here is a patch that fixes the problem by sending all the
> SYNC_FORGET_REQUEST messages up front.

I managed to reproduce it too, but my recipe is crummy enough that I'm not even
going to send it..

I confirmed that patch also seems to work for my worse recipe.

Thanks,
Justin