<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hey Wes,<div class=""><br class=""></div><div class="">I have the same issue where if pgpool doesn’t shutdown properly, it leaves the socket files trailing around and it prevents a proper startup. I’m using CentOS 7, so no init.d/pgpool-II scripts for me. I did try adding something to systemd files to remove the socket files, but no success. It remains an issue for me also. I have skipped this issue for now as I am not overly concerned about it. Nagios checks should let me know if anything is amiss.<br class=""><div class=""><br class="webkit-block-placeholder"></div><div class=""><span style="orphans: 2; text-align: -webkit-auto; widows: 2;" class="">Cheers,</span></div><div apple-content-edited="true" class=""><div style="color: rgb(0, 0, 0); font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;">Gervais</span></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">On May 18, 2015, at 9:10 PM, Wes Mitchell <<a href="mailto:wes.mitchell@ericsson.com" class="">wes.mitchell@ericsson.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Hi Gervais, </div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">I have solved this particular problem; I had opened udp ports on the firewall for both the heartbeat and the watchdog traffic, not realizing the watchdog traffic was tcp. Now both pgpool instances initialize properly, and failover even works!</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">However, now I have a different issue: if I use the service command to stop/restart pgpool, sometimes Unix domain socket files are left dangling (and sometimes they are cleaned up properly), preventing the restart from succeeding.</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Is this a known issue? Should I pre-emptively remove the socket files, perhaps in the init.d/pgpool-II script? Or, can I avoid the issue altogether by some magic in pool_hba.conf?</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">I find it difficult to search the archives. Is there full-text search capability somewhere for the list?</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Here are my settings. I have a non-root user with sudo privileges only for ifconfig and arping, which is why the paths don’t look right (but it works!)</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">use_watchdog = 'on'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">wd_hostname = 'pgpool1'<o:p class=""></o:p></span></div><p class="Note" style="margin: 12pt 0in 0.0001pt 127.6pt; font-size: 10pt; font-family: Arial; color: rgb(152, 72, 6); font-style: italic;">Note: 'pgpool2' on second machine<o:p class=""></o:p></p><p class="code" style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';"><span lang="EN-GB" class=""> </span></p><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">wd_port = 19000<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">delegate_IP =<span class="Apple-converted-space"> </span><i class="">'your virtual IP'<o:p class=""></o:p></i></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">if_up_cmd = 'sudo ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">ifconfig_path = '/usr/bin'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">if_down_cmd = 'sudo ifconfig eth0:0 down'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">arping_path = '/usr/bin'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">arping_cmd = 'sudo arping -U $_IP_$ -w 1<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">wd_interval = 3<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">wd_heartbeat_port = 19464<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">heartbeat_destination_port0 = 19464<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">other_pgpool_port0 = 15432<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">other_wd_port0 = 19000<o:p class=""></o:p></span></div><p class="Note" style="margin: 12pt 0in 0.0001pt 127.6pt; font-size: 10pt; font-family: Arial; color: rgb(152, 72, 6); font-style: italic;">Note: these lines must be different on the different hosts. On host pgpool1, use<o:p class=""></o:p></p><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">heartbeat_destination0 = 'pgpool2'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">other_pgpool_hostname0 = 'pgpool2'<o:p class=""></o:p></span></div><p class="code" style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';"><span lang="EN-GB" class=""> </span></p><p class="Note" style="margin: 12pt 0in 0.0001pt 127.6pt; font-size: 10pt; font-family: Arial; color: rgb(152, 72, 6); font-style: italic;">On host pgpool2, use<o:p class=""></o:p></p><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">heartbeat_destination0 = 'pgpool1'<o:p class=""></o:p></span></div><div style="margin: 0in 0in 0.0001pt 127.6pt; font-size: 11pt; font-family: 'Courier New';" class=""><span lang="EN-GB" class="">other_pgpool_hostname0 = 'pgpool1'<o:p class=""></o:p></span></div></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Thanks for your response,</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">Wes</div><div style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><span id="OLK_SRC_BODY_SECTION" style="font-family: Calibri, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><div style="font-family: Calibri; font-size: 11pt; text-align: left; border-width: 1pt medium medium; border-style: solid none none; padding: 3pt 0in 0in; border-top-color: rgb(181, 196, 223);" class=""><span style="font-weight: bold;" class="">From:<span class="Apple-converted-space"> </span></span>Gervais de Montbrun <<a href="mailto:gervais@silverorange.com" class="">gervais@silverorange.com</a>><br class=""><span style="font-weight: bold;" class="">Date:<span class="Apple-converted-space"> </span></span>Monday, May 18, 2015 at 3:13 PM<br class=""><span style="font-weight: bold;" class="">To:<span class="Apple-converted-space"> </span></span>Wes Mitchell <<a href="mailto:wes.mitchell@ericsson.com" class="">wes.mitchell@ericsson.com</a>><br class=""><span style="font-weight: bold;" class="">Cc:<span class="Apple-converted-space"> </span></span>"<a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a>" <<a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a>><br class=""><span style="font-weight: bold;" class="">Subject:<span class="Apple-converted-space"> </span></span>Re: [pgpool-general: 3721] Questions about watchdog<br class=""></div><div class=""><br class=""></div><div class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Wes,<div class=""><br class=""></div><div class="">Something must be awry with your configs. Can you share the watchdog relevant settings of your configs?</div><div class="" style="orphans: 2; widows: 2;">Perhaps your <span class="" style="color: rgb(245, 245, 245); font-family: Monaco; background-color: rgb(0, 0, 0);">heartbeat_destination0</span><span class="" style="orphans: 2; text-align: -webkit-auto; widows: 2;"> and </span><span class="" style="color: rgb(245, 245, 245); font-family: Monaco; background-color: rgb(0, 0, 0);">other_pgpool_hostname0</span><span class="" style="orphans: 2; text-align: -webkit-auto; widows: 2;"> are not set. Just a hunch. Make sure that the first is the hostname of the server you are running on and the “other” points to the other pgpool server.</span></div><div class=""><div apple-content-edited="true" class=""><div class="" style="font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><br class=""></span></div><div class="" style="font-variant: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;">Cheers,<br class="">Gervais</span></div></div><br class=""><div class=""><blockquote type="cite" class=""><div class="">On May 18, 2015, at 5:30 PM, Wes Mitchell <<a href="mailto:wes.mitchell@ericsson.com" class="">wes.mitchell@ericsson.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="" style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; font-size: 14px; font-family: Calibri, sans-serif;"><div class="">Hi,</div><div class=""><br class=""></div><div class="">I am trying to configure pgpool-II for HA using watchdog.</div><div class="">I am running into the following issue: if I specify the delegate_IP parameter on both pgpool hosts, then whichever one is brought up second fails:</div><div class=""><br class=""></div><div class=""><div class="">2015-05-18 16:11:44: pid 26948: LOCATION: wd_ping.c:309</div><div class="">2015-05-18 16:11:44: pid 26948: FATAL: failed to initialize watchdog, delegate_IP "10.61.156.162" already exists</div></div><div class=""><br class=""></div><div class="">And all processes then terminate.</div><div class=""><br class=""></div><div class="">Please help me understand the proper configuration. I am setting</div><div class=""><span class="Apple-tab-span" style="white-space: pre;"></span>delegate_IP = ’10.61.156.162’</div><div class=""><br class=""></div><div class="">I see that the interface is brought up and bound to that IP on the first instance, using ifconfig:</div><div class=""><div class="">eth0:0 Link encap:Ethernet HWaddr 00:0C:29:39:17:DF</div><div class=""> inet addr:10.61.156.162 Bcast:10.61.156.255 Mask:255.255.255.0</div></div><div class=""><br class=""></div><div class="">Is there some setting to tell pgpool process that it is master or standby? How do I set delegate_IP so that failover will bring up the IP on the promoted machine?</div><div class=""><br class=""></div><div class="">If you could also reply directly, I would appreciate it.</div><div class=""><br class=""></div><div class="">Thanks,</div><div class="">//w</div></div>_______________________________________________<br class="">pgpool-general mailing list<br class=""><a href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a><br class=""><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" class="">http://www.pgpool.net/mailman/listinfo/pgpool-general</a></div></blockquote></div></div></div></div></span></div></blockquote></div><br class=""></div></body></html>