Re: streaming replication question - Mailing list pgsql-general

From Rajesh Kumar Mallah
Subject Re: streaming replication question
Date
Msg-id AANLkTimpVju+U=c3mAYB_DXTNovjphzrajNv41J6p6rb@mail.gmail.com
Whole thread Raw
In response to Re: streaming replication question  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
Dear Riggs,
I am so sorry that i am not able to replicate it this time. May be i did something really stupid that day .
I remember at one point of time i ran the standy  without any recorvery.conf even.
If i ever get that again i will surely try to replicate it and inform.

Regds
Rajesh Kumar Mallah.

On Tue, Oct 5, 2010 at 5:08 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
On Sat, 2010-10-02 at 12:02 -0400, Rajesh Kumar Mallah wrote:
> FATAL:  too many KnownAssignedXids

That's a bug.

I've a few guesses about that, but I'll put some better instrumentation
in to see if we can prove what's causing it.

Can you reproduce that again, or was that failure isolated to that
particular point in the WAL stream? You can try turning HS off, then
turning it back on again later.

If you suspect a bug in Hot Standby, please set
       trace_recovery_messages = DEBUG2
in postgresql.conf and repeat the action

Always useful to know
* max_connections
* current number of sessions
* whether we have two phase commits happening

Thanks

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services


pgsql-general by date:

Previous
From: Thomas Guettler
Date:
Subject: Re: Trying to figure out why these queries are so slow
Next
From: Thom Brown
Date:
Subject: Re: Trying to figure out why these queries are so slow