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

[Gábriel Ákos]

On Mon, 04 Jun 2007 09:44:25 +0200
Karsten Nielsen <karsten at wwi.dk> wrote:

Yes and no :)
If you connect directly to one database and do the insert, it has to be
replicated to the other db by the replicator. AFAIK.

Rgds,
Akos

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