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

Sean Hogan sean at compusult.net
Fri Aug 30 00:38:39 JST 2013


On 13-08-28 08:13 PM, Tatsuo Ishii wrote:
>> 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.

Unfortunately no, that table exists on all the nodes.  I'll keep an eye 
out for this happening again.

Sean
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sean.vcf
Type: text/x-vcard
Size: 275 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130829/c206366d/attachment.vcf>


More information about the pgpool-general mailing list