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

Gábriel Ákos akos.gabriel at i-logic.hu
Mon Jun 4 07:09:53 UTC 2007


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


-- 
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabriel at i-logic.hu|Web:  http://www.i-logic.hu =-
-=Tel/fax:+3612367353            |Mobil:+36209278894          =-


More information about the Pgcluster-general mailing list