pcp commands do not tell DB nodes are in out-of-sync status. So I'm not sure what he is expecting here but I think it might be better to trigger failover in this case (ERROR: pgpool detected difference of the number of inserted, updated or deleted tuples). Opinions? -- Tatsuo Ishii SRA OSS, Inc. Japan
> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
