Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes

Hi Andres,

Thanks for the suggestion, but I already initialized a fresh stand by from
master, since I didn't have time to do more testing, so I can't try that
now. Is this the same bug which was announced a few days ago about possible
DB corruption on HS, because if I understood correctly only version 9.1.10
was problematic and not 9.1.9?

Strahinja Kustudić | Lead System Engineer | Nordeus

On Thu, Nov 28, 2013 at 10:53 AM, Andres Freund <andres(at)2ndquadrant(dot)com>wrote:

> Hi,
>
> On 2013-11-26 13:01:52 +0000, strahinjak(at)nordeus(dot)com wrote:
> > Bug reference: 8632
> > Logged by: Strahinja Kustudic
> > Email address: strahinjak(at)nordeus(dot)com
> > PostgreSQL version: 9.1.9
> > Operating system: Centos 6.4 x86
> > Description:
> >
> > 2013-11-26 12:24:57 CET [6393]: [93-1]LOG: file "pg_subtrans/CEC1"
> doesn't
> > exist, reading as zeroes
> > 2013-11-26 12:24:57 CET [6393]: [94-1]CONTEXT: xlog redo xid assignment
>
> This bug is hopefully fixed in the 9.1.11 release coming in a few
> days. As a workaround you can try starting the standby with
> hot_standby=off, let it replay a bit, then shut it down and try with
> hot_standby=on again.
>
> Greetings,
>
> Andres Freund
>
> --
> Andres Freund http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>