Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows
Дата
Msg-id 20191004204929.blahclqxouf5il7y@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows  (Andres Freund <andres@anarazel.de>)
Ответы AW: BUG #16039: PANIC when activating replication slots in Postgres12.0 64bit under Windows  (Hans Buschmann <buschmann@nidsa.net>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16040: PL/PGSQL RETURN QUERY statement never uses a parallel plan
Следующее
От: Andres Freund
Дата:
Сообщение: Re: BUG #16036: Segmentation fault while doing an update