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 CADKbJJVcstVdrhQMGZJTsF6oMEwY7De2S5FV=3tUOf4JzbDaww@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
Could you please tell me do I need to reinitialize the hot standby server after I upgrade to the latest version? In the release logs it says a fresh base backup is only needed if the version is 9.1.10, but I had 9.1.9 and still had a related issue. I didn't power off Postgres on the stand by after I made a new fresh base backup.

We also have a hot standby server running 9.2.4 which shouldn't be affected and which was never powered of from first start, so I guess that server doesn't need to be reinitialized?


Strahinja Kustudić | Lead System Engineer | Nordeus


On Thu, Nov 28, 2013 at 5:17 PM, Andres Freund <andres@2ndquadrant.com> wrote:
On 2013-11-28 11:13:22 -0500, Bruce Momjian wrote:
> > > > No, it's actually not - the (buggy) bug fix for the issue you're having
> > > > caused the problem in 9.1.10. So 9.1.11 will contain the corrected
> > > > version...
> > >
> > > I believe all the issues are summarized here:
> > >
> > >   https://wiki.postgresql.org/wiki/Nov2013ReplicationIssue
> >
> > Note that the OP is not hitting the bug that can cause actual corruption
> > in the standby that's discussed on that page.
>
> Oh, that's interesting.

He's hitting the issue that was the raison d'etre for the buggy fix that
caused the issue discussed on that page... As explained in the message
you replied to ;)

Greetings,

Andres Freund

--
 Andres Freund                     http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: BUG #8659: Broken dependencies on RHEL6 for 9.2.6 RPMs
Next
From: Andres Freund
Date:
Subject: Re: BUG #8632: file "pg_subtrans/CEC0" doesn't exist, reading as zeroes