Hackers,

I noticed while debugging a user issue that the checkpoint logged in

"Latest checkpoint is at %X/%X on timeline %u, but in the history of the requested timeline, the server forked off from that timeline at %X/%X."

is being pulled from the value stored in the control file rather than the value read from backup_label (in the case where there is a backup_label). This only affects logging since the timeline check is done against the checkpoint/TLI as read from backup_label.

This patch updates the checkpoint and TLI to (what I believe are) the correct values for logging.

I think this should also be back-patched.

Regards,
-David
From f14e30b18cde216131bd3e069ee8ecd5da3301b0 Mon Sep 17 00:00:00 2001
From: David Steele <da...@pgmasters.net>
Date: Fri, 20 Dec 2024 15:13:59 +0000
Subject: Fix logging for invalid recovery timeline.

If the requested recovery timeline is not reachable the logged checkpoint and
TLI should to be the values read from backup_label when backup_label is
present.
---
 src/backend/access/transam/xlogrecovery.c | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/backend/access/transam/xlogrecovery.c 
b/src/backend/access/transam/xlogrecovery.c
index c6994b78282..99afd01bf38 100644
--- a/src/backend/access/transam/xlogrecovery.c
+++ b/src/backend/access/transam/xlogrecovery.c
@@ -844,13 +844,13 @@ InitWalRecovery(ControlFileData *ControlFile, bool 
*wasShutdown_ptr,
                 * tliSwitchPoint will throw an error if the checkpoint's 
timeline is
                 * not in expectedTLEs at all.
                 */
-               switchpoint = 
tliSwitchPoint(ControlFile->checkPointCopy.ThisTimeLineID, expectedTLEs, NULL);
+               switchpoint = tliSwitchPoint(CheckPointTLI, expectedTLEs, NULL);
                ereport(FATAL,
                                (errmsg("requested timeline %u is not a child 
of this server's history",
                                                recoveryTargetTLI),
                                 errdetail("Latest checkpoint is at %X/%X on 
timeline %u, but in the history of the requested timeline, the server forked 
off from that timeline at %X/%X.",
-                                                  
LSN_FORMAT_ARGS(ControlFile->checkPoint),
-                                                  
ControlFile->checkPointCopy.ThisTimeLineID,
+                                                  
LSN_FORMAT_ARGS(CheckPointLoc),
+                                                  CheckPointTLI,
                                                   
LSN_FORMAT_ARGS(switchpoint))));
        }
 
-- 
2.34.1

Reply via email to