[Pgpool-general] Cannot trigger out-of-sync

[Daniel.Crespo at l-3com.com]

I'm also getting this exact behavior. Any clue?

Thanks,
Daniel

> -----Original Message-----
> From: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> bounces at pgfoundry.org] On Behalf Of Ger Apeldoorn
> Sent: Thursday, January 14, 2010 2:56 AM
> To: pgpool-general at pgfoundry.org
> 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:
> [root at db3 ~]# pcp_node_info 30 node1 9898 pgpool fake_password 1
> node2 5433 2 1073741823.500000
> [root at 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general