[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: WAL contains references to invalid pages in hot standby
From: Andrus <kobruleht2 () hot ! ee>
Date: 2022-11-26 15:59:26
Message-ID: fb553fae-2cb9-9daa-139c-b306afd76d86 () hot ! ee
[Download RAW message or body]
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.
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi!</p>
<p>WAL playback in hot standby server crashes with "WAL contains
references to invalid pages" error :<br>
</p>
<p>2022-11-26 17:48:12.889 EET [497] LOG: restored log file
"000000010000057900000064" from archive<br>
2022-11-26 17:48:20.897 EET [497] LOG: restored log file
"000000010000057900000065" from archive<br>
2022-11-26 17:48:26.564 EET [497] LOG: restored log file
"000000010000057900000066" from archive<br>
2022-11-26 17:48:32.019 EET [497] LOG: consistent recovery state
reached at 579/66954858<br>
2022-11-26 17:48:32.019 EET [495] LOG: database system is ready
to accept read only connections<br>
2022-11-26 17:48:32.019 EET [497] WARNING: page 11 of relation
base/54455050/83221012 is uninitialized<br>
2022-11-26 17:48:32.019 EET [497] CONTEXT: WAL redo at
579/66967DB0 for Heap2/VISIBLE: cutoff xid 167913422 flags 0x01<br>
2022-11-26 17:48:32.019 EET [497] PANIC: WAL contains references
to invalid pages<br>
2022-11-26 17:48:32.019 EET [497] CONTEXT: WAL redo at
579/66967DB0 for Heap2/VISIBLE: cutoff xid 167913422 flags 0x01<br>
2022-11-26 17:48:34.315 EET [495] LOG: startup process (PID 497)
was terminated by signal 6: Aborted<br>
2022-11-26 17:48:34.315 EET [495] LOG: terminating any other
active server processes<br>
2022-11-26 17:48:34.330 EET [495] LOG: database system is shut
down</p>
<p>It looks like file 000000010000057900000067 is corrupted. I
looked into this file and it contains data like other WAL files.</p>
<p>How to fix this error so that Wal playback can continue?<br>
</p>
<p>Master server is in Postgres 12 in Debian 10.3 <br>
</p>
<p>Hot standby in Postgres 12 in WSL Debian 11.5 </p>
<p>Can Debian version 10.3/11.5 difference cause this exception?</p>
<p>Andrus.<br>
</p>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic