| From: | Ray Stell <stellr(at)vt(dot)edu> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: uninitialized page in standby recovery |
| Date: | 2018-02-05 15:11:08 |
| Message-ID: | b1480e0c-b43c-e50e-a3f0-dd06e99190b8@vt.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On 2/5/18 9:06 AM, Ray Stell wrote:
> 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.
>
looks like bug 13822, discussed here:
https://www.postgresql.org/message-id/20151217125025.6916.26898%40wrigleys.postgresql.org
This discuss is in 9.4.5, how can I follow the thread? Is there a bug
db to query?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ray Stell | 2018-02-05 19:42:28 | Re: uninitialized page in standby recovery |
| Previous Message | Ray Stell | 2018-02-05 14:06:58 | uninitialized page in standby recovery |