Postgres Pro
Downloads
Home   >   mailing lists

Re: Switching timeline over streaming replication - Mailing list pgsql-hackers

From Thom Brown
Subject Re: Switching timeline over streaming replication
Date
Msg-id CAA-aLv79wuJDZCG+F-mO_Ap__VKUqiO2GQ-dEAS=ohFeU5SbNg@mail.gmail.com
Whole thread Raw
In response to Re: Switching timeline over streaming replication  (Heikki Linnakangas <hlinnakangas@vmware.com>)
List pgsql-hackers
Tree view
On 21 December 2012 18:13, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
On 21.12.2012 01:50, Thom Brown wrote:
Now I'm getting this on all standbys after promoting the first standby in a
chain.
> ...

> TRAP: FailedAssertion("!(((sentPtr)<= (SendRqstPtr)))", File:
> "walsender.c", Line: 1425)

Sigh. I'm sounding like a broken record, but I just committed another fix for this, should work now.

Thanks Heikki.  Just quickly retested with a new set of 120 standbys and all looks fine as far as the logs are concerned:

LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 1
LOG:  record with zero length at 0/37902A0
LOG:  fetching timeline history file for timeline 2 from primary server
LOG:  restarted WAL streaming at 0/3000000 on timeline 1
LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 1
LOG:  new target timeline is 2
LOG:  restarted WAL streaming at 0/3000000 on timeline 2
LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 2
LOG:  record with zero length at 0/643E248
LOG:  fetching timeline history file for timeline 3 from primary server
LOG:  restarted WAL streaming at 0/6000000 on timeline 2
LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 2
LOG:  new target timeline is 3
LOG:  restarted WAL streaming at 0/6000000 on timeline 3
LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 3
LOG:  record with zero length at 0/6BB13A8
LOG:  fetching timeline history file for timeline 4 from primary server
LOG:  restarted WAL streaming at 0/6000000 on timeline 3
LOG:  replication terminated by primary server
DETAIL:  End of WAL reached on timeline 3
LOG:  new target timeline is 4
LOG:  restarted WAL streaming at 0/6000000 on timeline 4

--
Thom

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Feature Request: pg_replication_master()
Next
From: Simon Riggs
Date:
Subject: Re: Feature Request: pg_replication_master()