Re: WAL replay issue from 9.6.8 to 9.6.10

Hi,

2018-08-29 6:02 GMT+02:00 Dave Peticolas <dave(at)krondo(dot)com>:
> Hello, I'm seeing some issues with WAL replay on a test server running
> 9.6.10 using WAL archived from a 9.6.8 primary server. It reliably PANICs
> during replay with messages like so:
>
> WARNING: page 1209270272 of relation base/16422/47496599 does not exist
> CONTEXT: xlog redo at 4810/C84F8A0 for Btree/DELETE: 88 items
> PANIC: WAL contains references to invalid pages

it looks like you are hitting pretty much the same problem as I:
https://www.postgresql.org/message-id/flat/153492341830.1368.3936905691758473953%40wrigleys.postgresql.org
The only major difference, you are restoring from the backup, while in
my case the host running replica has crashed.
Also in my case, the primary was already running 9.6.10.

In my case, it also panics during "Btree/DELETE: XYZ items" and page
number of relation is insanely huge.