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

From Andres Freund
Subject Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes
Date
Msg-id 20131128095341.GO31748@awork2.anarazel.de
Whole thread Raw
In response to BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (strahinjak@nordeus.com)
Responses Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes  (Strahinja Kustudić <strahinjak@nordeus.com>)
List pgsql-bugs
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: Tomonari Katsumata
Date:
Subject: Re: BUG #8434: Why does dead lock occur many times ?
Next
From: Andres Freund
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes