[pgpool-hackers: 3051] Re: Master watchdog sets quarantine state to primary node

[Tatsuo Ishii]

BTW, original discussion was on the Japanese Pgpool-II mailing list.

[pgpool-general-jp: 1504]
https://www.pgpool.net/pipermail/pgpool-general-jp/2018-March/001503.html

> Hi Usama,
> 
> Thank you for your great presentation in Pgpool-II Day Tokyo
> yesterday.  After the session Hiramitsu-san asked you about
> watchdog. I believe this is the thread he reffered to.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
> From: Muhammad Usama <m.usama at gmail.com>
> Subject: Re: Master watchdog sets quarantine state to primary node
> Date: Thu, 29 Mar 2018 22:40:31 +0800
> Message-ID: <CAEJvTzWn17qo__2tE628cQsXcD7dq=zZ_vtVZibRC31eScqgkg at mail.gmail.com>
> 
>> On Thu, Mar 29, 2018 at 10:10 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> 
>>> Usama,
>>>
>>> If the master watchdog sets primary node in quarantine state, no write
>>> query is possible because the query is routed to VIP -> master
>>> watchdog -> standby node. A user claimed that in this case the master
>>> watchdog should resign the master role so that another watchdog node
>>> can take over the role and continue to handle the write query.
>>>
>>> What do you think? For me the suggestion seems reasonable.
>>>
>> 
>> Yes seems like a good suggestion and solution.  I will take a look into
>> this and come up with the fix
>> 
>> Thanks
>> Best Regards
>> Muhammad Usama
>> 
>> 
>> 
>>>
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>>
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers