Re: Broken hint bits (freeze)

Bruce Momjian <bruce(at)momjian(dot)us> writes:

> On Fri, Jun 16, 2017 at 08:10:13PM +0530, Amit Kapila wrote:
> > On Fri, Jun 16, 2017 at 7:03 AM, Sergey Burladyan <eshkinkot(at)gmail(dot)com> wrote:
> > > Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > >
> > >> ! against the old primary and standby clusters. Verify that the
> > >> ! <quote>Latest checkpoint location</> values match in all clusters.
> > >
> > > For "Log-Shipping only" standby server this cannot be satisfied, because
> > > last WAL from master (with shutdown checkpoint) never archived.
> > >
> >
> > Yeah, we have ensured that all the transactions before shutdown
> > checkpoint got archived. It is done in commit
> > 2e6107cb621d003dcab0df53ac8673ea67c4e467. However, it is not clear to
> > me neither it is mentioned in comments why we have done it that way.
>
> Yes, I am confused why Sergey doesn't see that behavior.

I think this last new switched WAL with shutdown checkpoint record is
incomplete and it does not marked as *.ready in pg_xlog/archive_status/
and not archived.

--
Sergey Burladyan