Re: Hot Standby startup with overflowed snapshots

From: Chris Redekop <chris(at)replicon(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hot Standby startup with overflowed snapshots
Date: 2011-11-02 14:44:17
Message-ID: CAC2SuR+K3NoMj_QV9bwCFaQ+-b8Tzdha-dW9N3Y9EUSzje94SQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

oops....reply-to-all

---------- Forwarded message ----------
From: Chris Redekop <chris(at)replicon(dot)com>
Date: Wed, Nov 2, 2011 at 8:41 AM
Subject: Re: [HACKERS] Hot Standby startup with overflowed snapshots
To: Simon Riggs <simon(at)2ndquadrant(dot)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(at)2ndquadrant(dot)com> wrote:

> On Fri, Oct 28, 2011 at 3:42 AM, Chris Redekop <chris(at)replicon(dot)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 Content-Type Size
postgresql-2011-10-27_202007.log application/octet-stream 6.0 KB
postgresql-2011-10-31_152925.log application/octet-stream 7.1 KB
postgresql-2011-11-01_094501.log application/octet-stream 7.2 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message pasman pasmański 2011-11-02 14:48:31 Compile file_fdw with Mingw Developer Studio
Previous Message Robert Haas 2011-11-02 14:30:22 Re: pg_upgrade if 'postgres' database is dropped