Re: Hot Standby startup with overflowed snapshots

Chris Redekop <chris@replicon.com>

From: Chris Redekop <chris@replicon.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-11-02T14:44:17Z
Lists: pgsql-hackers

Attachments

oops....reply-to-all

---------- Forwarded message ----------
From: Chris Redekop <chris@replicon.com>
Date: Wed, Nov 2, 2011 at 8:41 AM
Subject: Re: [HACKERS] Hot Standby startup with overflowed snapshots
To: Simon Riggs <simon@2ndquadrant.com>


Sure, I've got quite a few logs lying around - I've attached 3 of 'em...let
me know if there are any specific things you'd like me to do or look for
next time it happens....


On Wed, Nov 2, 2011 at 2:59 AM, Simon Riggs <simon@2ndquadrant.com> wrote:

> On Fri, Oct 28, 2011 at 3:42 AM, Chris Redekop <chris@replicon.com> wrote:
>
> > On a side note I am sporadically seeing another error on hotstandby
> startup.
> >  I'm not terribly concerned about it as it is pretty rare and it will
> work
> > on a retry so it's not a big deal.  The error is "FATAL:  out-of-order
> XID
> > insertion in KnownAssignedXids".  If you think it might be a bug and are
> > interested in hunting it down let me know and I'll help any way I
> can...but
> > if you're not too worried about it then neither am I :)
>
> I'd be interested to see further details of this if you see it again,
> or have access to previous logs.
>
> --
>  Simon Riggs                   http://www.2ndQuadrant.com/
>  PostgreSQL Development, 24x7 Support, Training & Services
>