[pgpool-hackers: 4110] Re: Long standing bug with pcp_node_info

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jan 31 13:28:10 JST 2022


> It appears that occasionally pcp_node_info shows backend_status field
> as "quarantine" when it should be "down". While pcp_node_info shows
> the status, first it checks the backend_status member in BackendInfo
> struct. If it is 3, then checks quarantine member. If it is other than
> 0, then the backend_status field is shown as "quarantine". So if
> garbage remains in quarantine member, it is shown as "quarantine". The
> BackendInfo struct is transferred from pcp_worker process to pcp
> frontend client. Unfortunately when the quarantine member was added by
> commit 54af632c, it was forgotten to modify pcp_worker.c and
> pcp_frontend.c so that the "quarantine" member is transferred.
> 
> Attached is the patch for master branch.
> 
> I am going to back patch to 3.7, when the "quarantine" member was
> first added.

Fix pushed from master to 3.4 stable branches.

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=6d513a1b21047c1d37f53051fb37b4d4b7f1a9f4

Best reagards,
--
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-hackers mailing list