Re: Hot Standby startup with overflowed snapshots - Mailing list pgsql-hackers

From Chris Redekop
Subject Re: Hot Standby startup with overflowed snapshots
Date
Msg-id CAC2SuR+K3NoMj_QV9bwCFaQ+-b8Tzdha-dW9N3Y9EUSzje94SQ@mail.gmail.com
Whole thread Raw
In response to Re: Hot Standby startup with overflowed snapshots  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pg_upgrade if 'postgres' database is dropped
Next
From: pasman pasmański
Date:
Subject: Compile file_fdw with Mingw Developer Studio