<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
<br>
I have a system with two pgpools (current master code from git) and
three database nodes. The user manual says this:<br>
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<br>
<dt id="difference_of_number" style="font-weight: bold; color:
rgb(0, 0, 0); font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11.818181991577148px; font-style: normal; font-variant:
normal; letter-spacing: normal; line-height: normal; orphans:
auto; text-align: start; text-indent: 0px; text-transform: none;
white-space: normal; widows: auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; background-color: rgb(255, 255,
255);">Pgpool detected difference of the number of inserted,
updated or deleted tuples</dt>
<dd style="margin-left: 0px; color: rgb(0, 0, 0); font-family:
Verdana, Arial, Helvetica, sans-serif; font-size:
11.818181991577148px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: normal;
orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255);">
<p style="margin: 3px 25px 3px 40px; text-indent: 0em; color:
black;">In replication mode, pgpool-II detects a different
number of INSERT/UPDATE/DELETE rows on affected nodes.</p>
<pre style="background-color: rgb(240, 240, 240); color: rgb(165, 42, 42); padding: 5px; margin-left: 40px; margin-right: 30px; word-wrap: break-word; word-break: break-all; overflow: auto;">2010-07-22 11:49:28 ERROR: pid 30710: pgpool detected difference of the number of inserted, updated or deleted tuples. Possible last query was: "update t1 set i = 1;"
2010-07-22 11:49:28 LOG: pid 30710: ReadyForQuery: Degenerate backends: 1
2010-07-22 11:49:28 LOG: pid 30710: ReadyForQuery: Affected tuples are: 0 1
</pre>
<p style="margin: 3px 25px 3px 40px; text-indent: 0em; color:
black;">In the example above, the returned number of updated
rows by "update t1 set i = 1" was different among DB nodes. The
next line indicates that DB 1 got degenerated (disconnected) as
a consequence, and that the number of affected rows for DB node
0 was 0, while for DB node 1 that was 1.</p>
<p style="margin: 3px 25px 3px 40px; text-indent: 0em; color:
black;">Stop the DB node which is suspected of having wrong data
and do an online recovery.</p>
</dd>
<br>
however that does not seem to be happening. I see this in the logs
instead:<br>
<br>
2013-07-31 12:33:38 ERROR: pid 30131: pgpool detected difference of
the number of inserted, updated or deleted tuples. Possible last
query was: " UPDATE ws_cached_searches SET status_type = $1,
status_message = $2, processed_results = $3, truncated_results = $4,
status_xml = $5 WHERE cached_search_id = $6 and (status_type !=
'ERROR' or status_type is null)"<br>
2013-07-31 12:33:38 LOG: pid 30131: CommandComplete: Number of
affected tuples are: 1 0 1<br>
<br>
and node1 (in this case) stays connected. Has this behaviour become
broken?<br>
<br>
Thanks,<br>
Sean<br>
</body>
</html>