Postgres Pro
Downloads
Home   >   mailing lists

Re: Fix primary crash continually with invalid checkpoint after promote - Mailing list pgsql-hackers

From Nathan Bossart
Subject Re: Fix primary crash continually with invalid checkpoint after promote
Date
Msg-id 20220426181629.GA3002456@nathanxps13
Whole thread Raw
In response to Fix primary crash continually with invalid checkpoint after promote  ("Zhao Rui" <875941708@qq.com>)
List pgsql-hackers
Tree view 
On Tue, Apr 26, 2022 at 03:16:13PM +0800, Zhao Rui wrote:
> In function CreateRestartPoint, control file is updated and old wals are removed. But in some situations, control
fileis not updated, old wals are still removed. Thus produces an invalid checkpoint with nonexistent wal. Crucial log:
"invalidprimary checkpoint record", "could not locate a valid checkpoint record".
 

I think this is the same issue tracked here: [0].

[0] https://postgr.es/m/20220316.102444.2193181487576617583.horikyota.ntt%40gmail.com

-- 
Nathan Bossart
Amazon Web Services: https://aws.amazon.com

pgsql-hackers by date:

Previous
From: David Christensen
Date:
Subject: Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL
Next
From: Nathan Bossart
Date:
Subject: Re: Possible corruption by CreateRestartPoint at promotion