timeline problem when recovery

From: Fabrice Chapuis <fabrice636861(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: timeline problem when recovery
Date: 2024-12-10 14:01:15
Message-ID: CAA5-nLDV5jRF1HWnL9UT+C4KyQyYg9fvQi9+N1EcBa7jk1et-g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2024-12-10 14:05:42 Re: Fix bank selection logic in SLRU
Previous Message Robert Haas 2024-12-10 14:00:07 Re: Fix bank selection logic in SLRU