[pgpool-general: 2084] Re: node degeneration while vacuuming

Tatsuo Ishii ishii at postgresql.org
Thu Aug 29 07:43:14 JST 2013


> Hi,
> 
> Using pgadmin3 I ran a VACUUM ANALYZE on my three-node cluster, and
> got this:
> 
> 2013-08-28 08:41:12 ERROR: pid 21493: kind mismatch among
> backends. Possible last query was: "VACUUM VERBOSE ANALYZE " kind
> details are: 0[N: "ws_dataset_filters": scanned 0 of 0 pages,
> containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated
> total rows] 1[C] 2[C]
> 2013-08-28 08:41:12 LOG: pid 21493: degenerate_backend_set: 0 fail
> over request from pid 21493
> 
> This doesn't seem to be repeatable.  Can you tell me why that response
> would cause a degeneration?

Looks like you have "ws_dataset_filters" table only on node 0. I don't
know why this happend though.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp


More information about the pgpool-general mailing list