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
