<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Does anyone have any thought on this?<br>
<br>
Thanks,<br>
Sean<br>
<br>
On 14-09-02 10:07 AM, Sean Hogan wrote:<br>
</div>
<blockquote cite="mid:5405BA0B.6080903@compusult.net" type="cite">Hi,
<br>
<br>
Recently during a test event we had an unexpected node
degeneration, and I need to provide some reasonable explanation of
why it happened. Our system is two pgpool-II 3.3.3 nodes fronting
two PostgreSQL 9.2.7 nodes.
<br>
<br>
We selected a table in pgAdmin3 and ran VACUUM with the ANALYZE
option. Auto-vacuum is enabled on the database so the manual
vacuum is a bit nonsensical, but I still didn't expect a failure.
<br>
<br>
The logging tells the story:
<br>
<br>
2014-08-19 13:56:53 LOG: pid 7375: pool_send_and_wait: Error or
notice message from backend: : DB node id: 0 backend pid: 7404
statement: VACUUM VERBOSE ANALYZE sch.tbl message: vacuuming
"sch.tbl"
<br>
2014-08-19 13:56:53 LOG: pid 7375: pool_send_and_wait: Error or
notice message from backend: : DB node id: 1 backend pid: 314
statement: VACUUM VERBOSE ANALYZE sch.tbl message: vacuuming
"sch.tbl"
<br>
2014-08-19 13:56:53 ERROR: pid 7375: read_kind_from_backend: 1 th
kind C does not match with master or majority connection kind N
<br>
2014-08-19 13:56:53 ERROR: pid 7375: kind mismatch among backends.
Possible last query was: "VACUUM VERBOSE ANALYZE sch.tbl" kind
details are: 0[N: "pg_toast_170592198": found 0 removable, 0
nonremovable row versions in 0 out of 0 pages] 1[C]
<br>
2014-08-19 13:56:53 LOG: pid 7375: degenerate_backend_set: 1
fail over request from pid 7375
<br>
<br>
Web searches for potential causes were not helpful. Any ideas why
node 1 would just say "command completed" without all the other
information garbage that came from node 0?
<br>
<br>
Thanks for any assistance,
<br>
<br>
Sean
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</body>
</html>