Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed
Date: 2017-06-09 13:52:00
Message-ID: 01b46645-b827-d3d3-6716-91f2111fbd93@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 6/9/17 02:07, Noah Misch wrote:
> On Tue, Jun 06, 2017 at 03:21:34PM -0400, Peter Eisentraut wrote:
>> On 6/3/17 01:04, Noah Misch wrote:
>>> On Wed, May 31, 2017 at 10:15:50PM -0400, Peter Eisentraut wrote:
>>>> On 5/30/17 13:25, Masahiko Sawada wrote:
>>>>> I think this cause is that the relation status entry could be deleted
>>>>> by ALTER SUBSCRIPTION REFRESH before corresponding table sync worker
>>>>> starting. Attached patch fixes issues reported on this thread so far.
>>>>
>>>> This looks like a reasonable change, but it conflicts with the change
>>>> discussed on "logical replication - still unstable after all these
>>>> months". I think I'll deal with that one first.
>>>
>>> The above-described topic is currently a PostgreSQL 10 open item. You own
>>> this open item. Please observe the policy on open item ownership and send a
>>> status update within three calendar days of this message. Include a date for
>>> your subsequent status update.
>>
>> I'm working on this now and will report back tomorrow.
>
> IMMEDIATE ATTENTION REQUIRED.

Work is ongoing and progress is being made. I will check back in on Monday.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2017-06-09 13:57:29 Re: Notes on testing Postgres 10b1
Previous Message Peter Eisentraut 2017-06-09 13:50:58 Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed