pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
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
Date: Thu, 28 Nov 2019 16:14:50 -0600
Message-ID: <20191128221450.GE16647@telsasoft.com> (raw)
In-Reply-To: <CA+hUKGLw0RnKguqVvyWsJJR+2KHR9AyBqhbOuzdHjq9_XPokzA@mail.gmail.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>

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





view thread (22+ messages)  latest in thread

Message-ID: <20191128221450.GE16647@telsasoft.com>
Permalink:  ../20191128221450.GE16647@telsasoft.com/
Also on:    postgresql.org/message-id/20191128221450.GE16647@telsasoft.com

 · 

reply
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: pryzby@telsasoft.com, thomas.munro@gmail.com
  Subject: Re: checkpointer: PANIC: could not fsync file: No such file or directory
  In-Reply-To: <20191128221450.GE16647@telsasoft.com>

* 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