[pgpool-general: 7378] Re: Watchdog New Primary & Standby shutdown when Node 0 Fails

[Joe Madden]

Hi Tatsuo, Muhammad

Great, thanks for the information and clarifications. I'm just happy that I know its a bug and not an issue with my configuration.

An early release would appreciated it would save us having to build from the source but its not the end of the world if we need to wait.

Thanks for your time and help!

Happy holidays,

Joe.

________________________________
From: Tatsuo Ishii <ishii at sraoss.co.jp>
Sent: 19 December 2020 12:10
To: m.usama at gmail.com <m.usama at gmail.com>
Cc: Joe Madden <Joe.Madden at mottmac.com>; pgpool-general at pgpool.net <pgpool-general at pgpool.net>
Subject: Re: [pgpool-general: 7372] Re: Watchdog New Primary & Standby shutdown when Node 0 Fails

> On Sat, Dec 19, 2020 at 5:48 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> Ok, let me clarify. You think that 4.2.0's watchdog code has a problem
>> here:
>>
>> https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fpgpool%2Fpgpool2%2Fblob%2FV4_2_0_RPM%2Fsrc%2Fwatchdog%2Fwatchdog.c%23L2244&data=04%7C01%7CJoe.Madden%40mottmac.com%7C1f2adca36a984f527b4108d8a41709b1%7Ca2bed0c459574f73b0c2a811407590fb%7C0%7C0%7C637439766143269994%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Z2tXRbm8derU2xpuOaxOUJykIT0UrBaRGDe1vg1jwVQ%3D&reserved=0
>> and you think it causes your issue (node 0 dead).
>>
>> So you wonder if commit 70e0b2b93715094823102c9b1879e83fa75c7913
>> would solve the issue.
>>
>
> Yes, that's correct. this commit should solve the mentioned issue.
>
>>
>> I am not sure because according to the commit message, it was intended
>> to fix the problem of wd_cli command (which is new in 4.2). Probably
>> you'd better ask the commit author (Muhammad Usama).  I have added his
>> email address in the Cc: field.
>
>
> Both wd_cli and the lifecheck mechanism uses the same path and commit
> messages
> only mentions the wd_cli.
> Looking at the email I think it's a very critical issue and we should do a
> point
> release for 4.2
> The issue was caused by an oversight by the "simplifying watchdog
> configuration" feature
> which was introduced in 4.2, so the older versions should not have the same
> problem.
>
> Thanks
> Best regards
> Muhammad Usama

Thank you for the explanation. Next scheduled minor release is
February 18th, 2021 and it's a long way off. I am going to discuss
with Pengbo about this.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2Findex_en.php&data=04%7C01%7CJoe.Madden%40mottmac.com%7C1f2adca36a984f527b4108d8a41709b1%7Ca2bed0c459574f73b0c2a811407590fb%7C0%7C0%7C637439766143279947%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=eHVXIi0YSDHjw9BD5UxmWUNDlISuhGQYb6S%2BVeVLxeE%3D&reserved=0
Japanese:https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sraoss.co.jp%2F&data=04%7C01%7CJoe.Madden%40mottmac.com%7C1f2adca36a984f527b4108d8a41709b1%7Ca2bed0c459574f73b0c2a811407590fb%7C0%7C0%7C637439766143279947%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=brRjZ98QROAwtMOuNQU9K%2B5tgRXQX%2FeZmL701a495Yw%3D&reserved=0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20201219/30736603/attachment.htm>