pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrus <kobruleht2@hot.ee>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: WAL contains references to invalid pages in hot standby
Date: Sat, 26 Nov 2022 18:06:05 +0200
Message-ID: <fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee> (raw)

Hi!

WAL playback in hot standby server crashes  with "WAL contains 
references to invalid pages" error :

2022-11-26 17:48:12.889 EET [497] LOG:  restored log file 
"000000010000057900000064" from archive
2022-11-26 17:48:20.897 EET [497] LOG:  restored log file 
"000000010000057900000065" from archive
2022-11-26 17:48:26.564 EET [497] LOG:  restored log file 
"000000010000057900000066" from archive
2022-11-26 17:48:32.019 EET [497] LOG:  consistent recovery state 
reached at 579/66954858
2022-11-26 17:48:32.019 EET [495] LOG:  database system is ready to 
accept read only connections
2022-11-26 17:48:32.019 EET [497] WARNING:  page 11 of relation 
base/54455050/83221012 is uninitialized
2022-11-26 17:48:32.019 EET [497] CONTEXT:  WAL redo at 579/66967DB0 for 
Heap2/VISIBLE: cutoff xid 167913422 flags 0x01
2022-11-26 17:48:32.019 EET [497] PANIC:  WAL contains references to 
invalid pages
2022-11-26 17:48:32.019 EET [497] CONTEXT:  WAL redo at 579/66967DB0 for 
Heap2/VISIBLE: cutoff xid 167913422 flags 0x01
2022-11-26 17:48:34.315 EET [495] LOG:  startup process (PID 497) was 
terminated by signal 6: Aborted
2022-11-26 17:48:34.315 EET [495] LOG:  terminating any other active 
server processes
2022-11-26 17:48:34.330 EET [495] LOG:  database system is shut down

It looks like file 000000010000057900000067 is corrupted. I looked into 
this file and it contains data like other WAL files.

How to fix this error so that Wal playback can continue?

Master server is in Postgres 12 in Debian 10.3

Hot standby in Postgres 12 in WSL Debian 11.5

Can Debian version 10.3/11.5 difference cause this exception?

Andrus.

view thread (6+ messages)

Message-ID: <fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee>
Permalink:  ../fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee/
Also on:    postgresql.org/message-id/fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: kobruleht2@hot.ee
  Subject: Re: WAL contains references to invalid pages in hot standby
  In-Reply-To: <fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee>
  References: <fb553fae-2cb9-9daa-139c-b306afd76d86@hot.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox