I'm also getting this exact behavior. Any clue? Thanks, Daniel
> -----Original Message----- > From: [email protected] [mailto:pgpool-general- > [email protected]] On Behalf Of Ger Apeldoorn > Sent: Thursday, January 14, 2010 2:56 AM > To: [email protected] > Subject: [Pgpool-general] Cannot trigger out-of-sync > > Hi, > > I want to trigger an out-of-sync for a pgpool cluster in our > test-environment, but am unable to do it. > > As I understood it, if pgpools get a different number of rows back from > a query, it should trigger an out of sync for one of the databases. > > This is what I did: > 1) Insert new record directly in the local postgres database: > psql -p5433 my_database -c "insert into users (id, name, description, > password, field) values (10000,'gap','Ger','hihaho', 1);" > > 2) Update this record through PGPool: > psql -p9999 my_database -c "update users set name = 'Harry' where id = > 10000;" > > This generates the following error: > ERROR: pgpool detected difference of the number of inserted, updated > or > deleted tuples. Possible last query was: "update users set name = > 'Harry' where id = 10000;" > HINT: check data consistency between master and other db node > > Unfortunately, no out-of-sync status is being set: > [r...@db3 ~]# pcp_node_info 30 node1 9898 pgpool fake_password 1 > node2 5433 2 1073741823.500000 > [r...@node2 ~]# pcp_node_info 30 node1 9898 pgpool fake_password 0 > node1 5433 2 1073741823.500000 > > How can this be? Is there another (better) way to trigger a failure? > > Thanks again, > Ger. > > > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
