Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes - Mailing list pgsql-bugs

From Strahinja Kustudić
Subject Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Date
Msg-id CADKbJJWJM1_vM6oSrN+Ox_5m2R1PwjpaonZR3k7-99BsCmxBHQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
Tree view
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@2ndquadrant.com> wrote:
Hi,

On 2013-11-26 13:01:52 +0000, strahinjak@nordeus.com wrote:
> Bug reference:      8632
> Logged by:          Strahinja Kustudic
> Email address:      strahinjak@nordeus.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

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Next
From: Andres Freund
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes