Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpointer: PANIC: could not fsync file: No such file ordirectory - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: checkpointer: PANIC: could not fsync file: No such file ordirectory
Date
Msg-id 20191128221450.GE16647@telsasoft.com
Whole thread Raw
In response to checkpointer: PANIC: could not fsync file: No such file or directory  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: checkpointer: PANIC: could not fsync file: No such file or directory  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
Tree view 
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
fileor 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

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: checkpointer: PANIC: could not fsync file: No such file or directory
Next
From: Tatsuo Ishii
Date:
Subject: Re: Implementing Incremental View Maintenance