Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse
Дата
Msg-id CAB7nPqQ6WWipoN3A3g-uWQM=JJcGWSKA8Bw-q3+jXOiuNd-iRw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #14228: replication slot catalog_xmin not cleared on slot reuse  (andrew@tao11.riddles.org.uk)
Ответы Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-bugs
Дерево обсуждения 
On Wed, Jul 6, 2016 at 2:35 AM,  <andrew@tao11.riddles.org.uk> wrote:
> When creating a physical replication slot, the catalog_xmin field of the new
> slot is not initialized. If the slot storage had previously been used for a
> logical slot, the old catalog_xmin will remain in place and interfere with
> vacuum.

Good catch! The same applies to confirmed_flush_lsn, which is used
only by logical decoding and should remain as NULL for physical slots.
So I propose the patch attached to address both problems.
--
Michael
Вложения

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: Too slow "Analyze" for the table with data in Thai language
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: BUG #14228: replication slot catalog_xmin not cleared on slot reuse