Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows
Date
Msg-id 20191004204929.blahclqxouf5il7y@alap3.anarazel.de
Whole thread Raw
In response to Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows  (Andres Freund <andres@anarazel.de>)
Responses AW: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows
List pgsql-bugs
Hi Hans,

On 2019-10-04 13:06:05 -0700, Andres Freund wrote:
> On 2019-10-04 19:28:28 +0000, PG Bug reporting form wrote:
> > CPS PRD 2019-10-04 19:10:07 CEST  XX000  2:> PANIC:  could not fsync file
> > "pg_replslot/sam_repli_3/state": Bad file descriptor
> > CPS PRD 2019-10-04 19:10:07 CEST  00000  6:> LOG:  startup process (PID
> > 4028) was terminated by exception 0xC0000409

Thanks again for the report! I've committed the fix. Unfortunately,
unless you can compile yourself, you'll have to wait until the next
minor release for the fix.  Given this is the .0 release of 12, and that
we already have a number of bugs to fix, I'm sure that won't be too far
away however.

If you want to work around the problem, you can, but it's not entirely
unproblematic: If, just when restarting, you set fsync to false, you'll
avoid the problem. But then you'd have to immediately re-enable
afterwards, and there's still a small data loss window.  If however all
you want is to continue testing, fsync=off might be a reasonable
workaround.

Greetings,

Andres Freund



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan
Next
From: Andres Freund
Date:
Subject: Re: BUG #16036: Segmentation fault while doing an update