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

[Karsten Nielsen]

That is not the way I have understod the termonoligy of the cluster.

The load balancer just destributes the connections to what ever database
is avaliable. So the connections to the database looks as if the client
is dircetly connected to it.

- Karsten

On Mon, 2007-06-04 at 09:49 +0200, Gábriel Ákos wrote:
> 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
> 
>