[Pgpool-general] Problem with replication mode!!!
Lazaro Ruben Garcia Martinez
lgarciam at estudiantes.uci.cu
Fri Nov 5 16:59:31 UTC 2010
Hello every one.
I have this problem.
I have one database in two nodes, I use Pgpool-II version 2.3.3.
This database has one table, in the first node (master) there is a table with one record and in the other node this table there isn't any record, but when I execute a Select or Update over this table, the secondary node is never degenerate (failover is not perform).
I tested this problem in Pgpool-II version 3.0.1 and I have the same situation.
pgpool.conf of Pgpool-II version 2.3.3.
replication_stop_on_mismatch = true
pgpool.conf of Pgpool-II version 2.3.3.
replication_stop_on_mismatch = true
failover_if_affected_tuples_mismatch = true
The documentation of pgpool says:
failover_if_affected_tuples_mismatch
When set to true, if a backend returns number of affected tuples by INSERT/UPDATE/DELETE different between the backends, the backends that differ from most frequent result set are degenerated. If set to false, the session is terminated and the backends are not degenerated. Default is false. replication_stop_on_mismatch
When set to true, if a backend returns packet kind different between the backends, the backends that differ from most frequent result set are degenerated. Typical use case is the SELECT statement is part of a transaction and replicate_select is set to true, and SELECT returns diffrent number of rows among backends. Other than SELECT statement might trigger this though. For example, a backend succeeded in an UPDATE, while others failed. Also please note that pgpool does NOT examine content of records returned from SELECT. If set to false, the session is terminated and the backends are not degenerated. Default is false.
Anyone knows why is it?
Regards.
Thank you very much for your time.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101105/61e71acc/attachment.html>
More information about the Pgpool-general
mailing list