Re: [HACKERS] Re: Alter subscription..SET - NOTICE message is comingfor table which is already removed

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] Re: Alter subscription..SET - NOTICE message is comingfor table which is already removed
Дата
Msg-id 861d9b54-5a14-73c7-cac5-de2d2b0a80ff@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Re: Alter subscription..SET - NOTICE message is comingfor table which is already removed  (Masahiko Sawada <sawada.mshk@gmail.com>)
Ответы Re: [HACKERS] Re: Alter subscription..SET - NOTICE message is comingfor table which is already removed  (Masahiko Sawada <sawada.mshk@gmail.com>)
Список pgsql-hackers
On 5/30/17 13:25, Masahiko Sawada wrote:
> However there is one more problem here; if the relation status entry
> is deleted while corresponding table sync worker is waiting to be
> changed its status, the table sync worker can be orphaned in waiting
> status. In this case, should table sync worker check the relation
> status and exits if the relation status record gets removed? Or should
> ALTER SUBSCRIPTION update status of table sync worker to UNKNOWN?

I think this would be fixed with the attached patch.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] How to refer to resource files from UDFs written in C
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] Re: Alter subscription..SET - NOTICE message is comingfor table which is already removed