Re: Use of backup_label not noted in log - Mailing list pgsql-hackers

From David Steele
Subject Re: Use of backup_label not noted in log
Date
Msg-id ff9ceb77-e990-4020-b8be-20f1c32328f8@pgmasters.net
Whole thread Raw
In response to Re: Use of backup_label not noted in log  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers

On 1/25/24 20:52, Michael Paquier wrote:
> On Thu, Jan 25, 2024 at 08:56:52AM -0400, David Steele wrote:
>> I would still advocate for a back patch here. It is frustrating to get logs
>> from users that just say:
>>
>> LOG:  invalid checkpoint record
>> PANIC:  could not locate a valid checkpoint record
>>
>> It would be very helpful to know what the checkpoint record LSN was in this
>> case.
> 
> Yes, I've pested over this one in the past when debugging corruption
> issues.  To me, this would just mean to appens to the PANIC an "at
> %X/%X", but perhaps you have more in mind for these code paths?

I think adding the LSN to the panic message would be a good change for HEAD.

However, that still would not take the place of the additional messages 
in 1d35f705e showing that the LSN came from a backup_label.

Regards,
-David



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [EXTERNAL] Re: Add non-blocking version of PQcancel
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCH] Add native windows on arm64 support