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

[Gábriel Ákos]

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


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