Re: Re: [bug fix] Cascading standby cannot catch up and get stuck emitting the same message repeatedly - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: Re: [bug fix] Cascading standby cannot catch up and get stuck emitting the same message repeatedly
Date
Msg-id CAA4eK1LTve7TU13gBk-YN5KJUA8EMii7_UcpUCPQMwxG8ij2PA@mail.gmail.com
Whole thread Raw
In response to Re: Re: [bug fix] Cascading standby cannot catch up and get stuck emitting the same message repeatedly  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Responses Re: Re: [bug fix] Cascading standby cannot catch up and get stuck emitting the same message repeatedly  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
List pgsql-hackers
On Tue, Nov 22, 2016 at 8:48 AM, Tsunakawa, Takayuki
<tsunakawa.takay@jp.fujitsu.com> wrote:
> From: pgsql-hackers-owner@postgresql.org
>
> If the problem occurs, the following pair of lines appear in the server log of the cascading standby.  Could you
checkit? 
>
> LOG:  restored log file "000000020000000000000003" from archive
> LOG:  out-of-sequence timeline ID 1 (after 2) in log file 0, segment 3, offset 0
>

Thanks for the clarification, I could reproduce the issue and confirms
that patch has fixed it.  Find logs of cascading standby at  PG9.2
Head and Patch attached (I have truncated few lines at end of server
log generated in Head as those were repetitive).  I think the way you
have directly explained the bug steps in code comments is not right
(think if we start writing bug steps for each bug fix, how the code
will look like).  So I have modified the comment to explain the
situation and reason of check,  see if you find that as okay?


--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com

Attachment

pgsql-hackers by date:

Previous
From: amul sul
Date:
Subject: pg_background contrib module proposal
Next
From: Ashutosh Bapat
Date:
Subject: Re: Calculation of param_source_rels in add_paths_to_joinrel