Re: Spontaneous PITR standby activiation - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Spontaneous PITR standby activiation
Date
Msg-id 4B0E2D97.6070004@enterprisedb.com
Whole thread Raw
In response to Spontaneous PITR standby activiation  (David Christensen <david@endpoint.com>)
Responses Re: Spontaneous PITR standby activiation
List pgsql-hackers
David Christensen wrote:
> 1) is there a hard limit of the number of times the archive_command will
> attempt?  I didn't see anything documented about this in the PITR or
> config docs, so I'm guessing the 10 failures I saw in the log were just
> coincidental.

There's no limit. It will try forever.

> 2) are the archive_command failures in the master's log responsible for
> the redo records?

No, archive_command failures shouldn't affect the standby.

> 3) would a Pg forced shutdown cause issues with the generated WAL when
> replaying?

No.

> 4) at first I thought it had to do with a bug/failure in pg_standby, but
> I'm wondering if it has to do with the "record with zero length"
> referenced in the standby's logs.  Thoughts?

That basically means that WAL replay reached end of WAL. The rest of the
WAL file is probably full of zeros. It's quite normal in crash recovery,
for example. But I have no explanation for why such a WAL file was archived.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: [PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION
Next
From: Jeff Davis
Date:
Subject: Re: [PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION