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

Karsten Nielsen karsten at wwi.dk
Mon Jun 4 07:19:41 UTC 2007


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
> 
> 


More information about the Pgcluster-general mailing list