On 15.02.2013 03:49, maciek@heroku.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7883
> Logged by: Maciek Sakrejda
> Email address: maciek@heroku.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