<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi!<br>
<br>
In my case it helped a bit when the /tmp folder was mounted as
tmpfs. In Centos 7 it was on HDD by default. When rebooting the
old contents was preserved. Now with tmpfs /tmp is clean after
reboot. Surely it helps only if the whole system is restarted, not
only pgpool...<br>
<br>
Cheers,<br>
J.<br>
<br>
On 19.05.2015 14:53, Gervais de Montbrun wrote:<br>
</div>
<blockquote
cite="mid:39D9CBD1-34E6-4238-B816-B229DCE93C88@silverorange.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
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
moz-do-not-send="true"
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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB"> </span></p>
<div style="margin: 0in 0in 0.0001pt 127.6pt; font-size:
11pt; font-family: 'Courier New';" class=""><span
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB">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
class="" lang="EN-GB"> </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
class="" lang="EN-GB">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
class="" lang="EN-GB">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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:pgpool-general@pgpool.net" class="">pgpool-general@pgpool.net</a>"
<<a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:pgpool-general@pgpool.net"
class="">pgpool-general@pgpool.net</a><br
class="">
<a moz-do-not-send="true"
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>
</blockquote>
<br>
</body>
</html>