Re: BUG #7883: "PANIC: WAL contains references to invalid pages" on replica recovery

On 15.02.2013 03:49, maciek(at)heroku(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7883
> Logged by: Maciek Sakrejda
> Email address: maciek(at)heroku(dot)com
> PostgreSQL version: 9.1.8
> Operating system: Ubuntu 12.04 64-bit
> Description:
>
> We ran into a customer database giving us the error above when replicating
> from 9.1.7 to 9.1.8 and attempting to fail over to the 9.1.8. I noticed
> several fixes to WAL replay in 9.1.8--could this be a factor in this case?
> ...
> Feb 15 00:49:16 [1305-1] [COPPER] LOG: archive recovery complete
> Feb 15 00:49:16 [1306-1] [COPPER] WARNING: page 37956 of relation
> base/16385/16430 was uninitialized
> Feb 15 00:49:16 [1307-1] [COPPER] PANIC: WAL contains references to
> invalid pages

Hmm, that sure looks like the same issue Kyotaro HORIGUCHI reported
(http://www.postgresql.org/message-id/20121206.130458.170549097.horiguchi.kyotaro@lab.ntt.co.jp)
but that was fixed in 9.1.8. Maybe there's some corner case where it's
still not working.

Did you keep a copy of the WAL involved? Any chance of running xlogdump
on it, and posting the results, or just sending over the WAL files so I
could take a look?

- Heikki