Hi all,

The eror that comes is:
ERROR: duplicate key value voilates unique constraint "XXXXXX_pkey"

Another observation, I try adding the same insert statement 2-3 times, it gives the above error and after some 2-3 times it succeeds. The same insert statement !!!

Is it something to do with wait for event.. I do not have a wait for event after a switch over. wait for event(origin=$fromnode, confirmed=$tonode);

If I enable the wait for event I get the following error:
No admin conninfo provided for node -1

Thanks.

------------------------------

Message: 3
Date: Fri, 12 Jun 2009 09:54:12 -0400
From: Andrew Sullivan <ajs at crankycanuck.ca>
Subject: Re: [Slony1-general] Switchover issue.
To: slony1-general at lists.slony.info
Message-ID: <20090612135412.GA36147 at shinkuro.com>
Content-Type: text/plain; charset=us-ascii

On Fri, Jun 12, 2009 at 01:20:56PM +0530, Nagaraja, Madhukar (Madhukar) wrote:

> switchover from the GUI, evrything seems quite ok. But when we trying
> adding new entries from the GUI, we get a very vague PSQL exception -
> duplicate entry primary key voilation.

That doesn't sound vague to me.  It sounds like a perfectly clear message.  My bet is that you're tripping over a sequence value that is set too low or something like that.  But without seeing the actual exception message, instead of your vague description of it, I can't say more.

A


--
Andrew Sullivan
ajs at crankycanuck.ca


------------------------------

Message: 4
Date: Fri, 12 Jun 2009 11:36:44 -0700
From: David Rees <drees76 at gmail.com>
Subject: Re: [Slony1-general] Switchover issue.
To: slony1-general at lists.slony.info
Message-ID:
        <72dbd3150906121136r3e2bfc4dt6b68312424de4788 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

On Fri, Jun 12, 2009 at 6:54 AM, Andrew Sullivan<ajs at crankycanuck.ca> wrote:
> On Fri, Jun 12, 2009 at 01:20:56PM +0530, Nagaraja, Madhukar (Madhukar) wrote:
>
>> switchover from the GUI, evrything seems quite ok. But when we
>> trying adding new entries from the GUI, we get a very vague PSQL
>> exception - duplicate entry primary key voilation.
>
> That doesn't sound vague to me. ?It sounds like a perfectly clear
> message. ?My bet is that you're tripping over a sequence value that
> is set too low or something like that. ?But without seeing the actual
> exception message, instead of your vague description of it, I can't
> say more.

I would guess that a sequence isn't getting replicated and should be,
which is why you run in to the duplicate key issues after switching
nodes.

-Dave