On 2014-01-31 11:09:14 +0000, Greg Stark wrote: > On Sun, Jan 26, 2014 at 5:45 PM, Andres Freund <and...@2ndquadrant.com> wrote: > > > >> We're also seeing log entries about "wal contains reference to invalid > >> pages" but these errors seem only vaguely correlated. Sometimes we get > >> the errors but the tables don't grow noticeably and sometimes we don't > >> get the errors and the tables are much larger. > > > > Uhm. I am a bit confused. You see those in the standby's log? At !debug > > log levels? That'd imply that the standby is dead and needed to be > > recloned, no? How do you continue after that?
> So in chatting with Heikki last night we came up with a scenario where > this check is insufficient. The slightly more likely explanation for transient errors is that you hit the vacuum bug (061b079f89800929a863a692b952207cadf15886). That had only taken effect if HS has already assembled a snapshot, which can make such an error vanish after a restart... Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers