Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyxh3-0005Th-IZ for pgsql-general@arkaria.postgresql.org; Sat, 26 Nov 2022 16:06:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oyxh2-0003ZY-H0 for pgsql-general@arkaria.postgresql.org; Sat, 26 Nov 2022 16:06:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyxh2-0003ZP-53 for pgsql-general@lists.postgresql.org; Sat, 26 Nov 2022 16:06:16 +0000 Received: from portal-smtp-out.hot.ee ([194.126.101.125]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyxgx-0006IT-P5 for pgsql-general@postgresql.org; Sat, 26 Nov 2022 16:06:15 +0000 Received: from localhost (localhost [127.0.0.1]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 3272333CD for ; Sat, 26 Nov 2022 18:06:10 +0200 (EET) X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee Received: from portal-smtp-out.hot.ee ([127.0.0.1]) by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7ylmuwoihuQV for ; Sat, 26 Nov 2022 18:06:07 +0200 (EET) Received: from mail.hot.ee (hot-relayhost3.estpak.ee [213.180.2.81]) by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id BAFE333C7 for ; Sat, 26 Nov 2022 18:06:07 +0200 (EET) Content-Type: multipart/alternative; boundary="------------II4ahGkSIW08BW2TLZD9EbjV" Message-ID: Date: Sat, 26 Nov 2022 18:06:05 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Content-Language: et To: pgsql-general From: Andrus Subject: WAL contains references to invalid pages in hot standby List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------II4ahGkSIW08BW2TLZD9EbjV Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------II4ahGkSIW08BW2TLZD9EbjV Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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.

--------------II4ahGkSIW08BW2TLZD9EbjV--