Re: [Bug Fix]standby may crash when switching-over in certain special cases - Mailing list pgsql-hackers

From Yugo NAGATA
Subject Re: [Bug Fix]standby may crash when switching-over in certain special cases
Date
Msg-id 20240930144708.c3ad9999f6032bc2e80d0a54@sraoss.co.jp
Whole thread Raw
In response to Re: [Bug Fix]standby may crash when switching-over in certain special cases  (px shi <spxlyy123@gmail.com>)
Responses Re: [Bug Fix]standby may crash when switching-over in certain special cases
List pgsql-hackers
On Wed, 21 Aug 2024 09:11:03 +0800
px shi <spxlyy123@gmail.com> wrote:

> Yugo Nagata <nagata@sraoss.co.jp> 于2024年8月21日周三 00:49写道:
> 
> >
> >
> > > Is s1 a cascading standby of s2? If otherwise s1 and s2 is the standbys
> > of
> > > the primary server respectively, it is not surprising that s2 has
> > progressed
> > > far than s1 when the primary fails. I believe that this is the case you
> > should
> > > use pg_rewind. Even if flushedUpto is reset as proposed in your patch,
> > s2 might
> > > already have applied a WAL record that s1 has not processed yet, and
> > there
> > > would be no gurantee that subsecuent applys suceed.
> >
> >
>  Thank you for your response. In my scenario, s1 and s2 is the standbys of
> the primary server respectively, and s1 a synchronous standby and s2 is an
> asynchronous standby. You mentioned that if s2's replay progress is ahead
> of s1, pg_rewind should be used. However, what I'm trying to address is an
> issue where s2 crashes during replay after s1 has been promoted to primary,
> even though s2's progress hasn't surpassed s1.

I understood your point. It is odd that the standby server crashes when
replication fails because the standby would keep retrying to get the
next record even in such case.

Regards,
Yugo Nagata

> 
> Regards,
> Pixian Shi


-- 
Yugo NAGATA <nagata@sraoss.co.jp>



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Conflict Detection and Resolution
Next
From: btsugieyuusuke
Date:
Subject: pg_walsummary, Character-not-present-in-option