From: Ray Stell <stellr@vt.edu>
To: pgsql-admin@lists.postgresql.org
Subject: uninitialized page in standby recovery
Date: Mon, 5 Feb 2018 09:06:58 -0500
Message-ID: <b1fcef70-d8c5-689c-a3a8-b01e4f212c53@vt.edu> (raw)
I built a standby with 9.4.12 and about a day later the standby crashed
with this:
2018-02-02 16:20:44 EST,0, WARNING: page 1347460 of relation
base/16391/16414 is uninitialized
2018-02-02 16:20:44 EST,0, CONTEXT: xlog redo visible: rel
1663/16391/16414; blk 1347460
2018-02-02 16:20:44 EST,0, PANIC: WAL contains references to invalid pages
2018-02-02 16:20:44 EST,0, CONTEXT: xlog redo visible: rel
1663/16391/16414; blk 1347460
2018-02-02 16:20:44 EST,0, LOG: startup process (PID 24057) was
terminated by signal 6: Aborted
2018-02-02 16:20:44 EST,0, LOG: terminating any other active server
processes
Any hints to where the corruption begins? I don't see any disk i/o
issues. Not sure what to look for in the release notes,
but I'll try to patch asap, but that is difficult to get done politically.
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@vt.edu, pgsql-admin@lists.postgresql.org
Subject: Re: uninitialized page in standby recovery
In-Reply-To: <b1fcef70-d8c5-689c-a3a8-b01e4f212c53@vt.edu>
* 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