Re: logical replication: could not create file "state.tmp": Fileexists

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: logical replication: could not create file "state.tmp": Fileexists
Дата
Msg-id 20191211174011.qm7jfbtbli2gjibc@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: logical replication: could not create file "state.tmp": Fileexists  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-bugs
Hi,

On 2019-12-11 14:27:45 +0900, Michael Paquier wrote:
> On Mon, Dec 02, 2019 at 08:12:22AM -0800, Andres Freund wrote:
> > I'm very doubtful about this. I think it's a good safety measure to
> > ensure that there's no previous state file that we're somehow
> > overwriting.
>
> During the checkpoint of replication slots, SaveSlotToPath() would
> just *LOG* any failure while leaving around the state.tmp of a slot,
> and then any follow-up attempt to create state.tmp would just fail
> because of that, preventing the slot state file from being flushed
> continuously.  I think that's wrong.  Concurrency is not a concern
> either here as the slot's LWLock to track an I/O in progress is taken
> in exclusive lock.

I'm not clear on what you're saying? I don't see how I'm arguing for the
type of behaviour you seem to be describing?

Greetings,

Andres Freund



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Roman Cervenak
Дата:
Сообщение: Re: Memory leak (possibly connected to postgis) leading to server crash
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16161: pg_ctl stop fails sometimes (on Windows)