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

[Ger Apeldoorn]

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.