[Pgcluster-general] Duplicate inserts, cluster node no recovering

[Karsten Nielsen]

Hi,

I have access to 64bit dual opteron system that is my setup.

If I do an insert through my lb the insert is executed on both
clusterdb's and that is the point og the cluster is it not?


-Karsten

On Mon, 2007-06-04 at 09:38 +0200, Gábriel Ákos wrote:
> On Mon, 04 Jun 2007 09:19:41 +0200
> Karsten Nielsen <karsten at wwi.dk> wrote:
> 
> You have 64bit platform? 
> 
> The reproduction of the bug is quite simple, see my earlier mail.
> 
> If you don't have access to 64 bit machine, drop me a mail and I'll
> organize access for you to our development dual-opteron system.
> 
> Rgds,
> Akos
> 
> 
> > Hi,
> > 
> > I am testing pgcluster 1.7.0rc7 and I do not see that problem ? 
> > How do you go about producing that error/bug ?
> > 
> > - Karsten
> > 
> > On Mon, 2007-06-04 at 09:09 +0200, Gábriel Ákos wrote:
> > > On Mon, 04 Jun 2007 08:37:56 +0200
> > > Karsten Nielsen <karsten at wwi.dk> wrote:
> > > 
> > > No, this will not help definitely.
> > > Anyway, I have to say thankyou to Raul, since he exactly reproduced
> > > my problem what noone else believed to exist. :)
> > > 
> > > It looks like the problem is related to the 64 bit platform?
> > > 
> > > Regards,
> > > Akos
> > > 
> > > 
> > > > Hi,
> > > > 
> > > > According to the
> > > > http://pgfoundry.org/frs/shownotes.php?group_id=1000072&release_id=883
> > > > you need to run PostgreSQL 8.2.4 with PGCluster 1.7.0rc7 patch. I
> > > > am not shure if that helps but that i a start.
> > > > 
> > > > - Karsten
> > > > 
> > > > On Mon, 2007-06-04 at 06:13 +0000, Raúl Alexis Betancor Santana
> > > > wrote:
> > > > > Hi all, I'm testing PostgreSQL 8.2.4 with PGCluster 1.7.0rc5
> > > > > patch.
> > > > > 
> > > > > My setup is 2 lb + 2 db node + 2 replicator
> > > > > 
> > > > > What happens to me is that if I connect to the first LB with
> > > > > client software, all insert queries are duplicated, so I ended
> > > > > with a messed database with duplicate rows on my tables.
> > > > > 
> > > > > I had tryied with lb1, db1, db2 and rep1 up, without rep2 and
> > > > > lb2 with the same results.
> > > > > 
> > > > > I have followed pgcluster.org examples for the conf files.
> > > > > 
> > > > > Testing platform is Debian Etch(64 bits version) on AMD64
> > > > > DualCore, 8Gb RAM
> > > > > 
> > > > > Any hints for debugging this .. ?
> > > > > 
> > > > _______________________________________________
> > > > Pgcluster-general mailing list
> > > > Pgcluster-general at pgfoundry.org
> > > > http://pgfoundry.org/mailman/listinfo/pgcluster-general
> > > 
> > > 
> > _______________________________________________
> > Pgcluster-general mailing list
> > Pgcluster-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgcluster-general
> 
>