timeline problem when recovery

Started by Fabrice Chapuisabout 1 year ago1 messages
#1Fabrice Chapuis
fabrice636861@gmail.com

Hi, I got this message on a standby after a FO of PG14 cluster with 3 nodes.

user=,db=,client=,application= LOG: new timeline 20 forked off current
database system timeline 19 before current recovery point CC8/164E9350

this message come from xlog.c rescanLatestTimeLine function:

if (currentTle->end < EndRecPtr)
{
ereport(LOG,
(errmsg("new timeline %u forked off current database system timeline %u
before current recovery point %X/%X",
newtarget,
ThisTimeLineID,
LSN_FORMAT_ARGS(EndRecPtr))));
return false;
}

To complete recovery of standby, rewind was used to come back to the fork.
Is that means that standby by was before hand compare to the new primary
(new TL) and potentially loosing data on this primary.

Regards,

Fabrice