<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
text-align:right;
direction:rtl;
unicode-bidi:embed;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
text-align:right;
direction:rtl;
unicode-bidi:embed;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
text-align:left;
direction:ltr;
unicode-bidi:embed;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="color:#1F497D">Yes, I changed the white function list and then restarted pgpool. This list needs quotes. I have two pgpools with watchdog between them. When I modify
the file do I need to bring both pgpools down? Can I modify one and restart it and then modify the second?
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="color:#1F497D"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><b><span style="color:windowtext">From:</span></b><span style="color:windowtext"> pgpool-general-bounces@pgpool.net [mailto:pgpool-general-bounces@pgpool.net]
<b>On Behalf Of </b>Tema Zelikin<br>
<b>Sent:</b> Tuesday, October 25, 2016 4:41 PM<br>
<b>To:</b> pgpool-general@pgpool.net<br>
<b>Subject:</b> [pgpool-general: 5073] Re: "/tmp/.s.PGPOOLWD_CMD.9000" failed with reason: "Address already in use"<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<p style="text-align:left;direction:ltr;unicode-bidi:embed">Hi.<span style="font-size:12.0pt"><o:p></o:p></span></p>
<p style="text-align:left;direction:ltr;unicode-bidi:embed">I've had that issue. Have you recently modified pgpool config files? Last time it was when i wrote backend_weight0 value with a quotes.<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><o:p> </o:p></p>
<div>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">25.10.2016 16:26, Avi Weinberg пишет:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">Hi all,<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"> <o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">The latest version of pgpool is giving me this error frequently. What might be causing it?
<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"> <o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194501: LOG: waiting for watchdog to initialize<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: LOG: setting the local watchdog node name to "Linux_postgres_server2_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: LOG: watchdog cluster configured with 1 remote nodes<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: LOG: watchdog remote node:0 on 172.18.255.42:9000<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: LOG: interface monitoring is disabled in watchdog<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: LOG: IPC socket path: "/tmp/.s.PGPOOLWD_CMD.9000"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: FATAL: failed to create watchdog command server socket<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194503: DETAIL: bind on "/tmp/.s.PGPOOLWD_CMD.9000" failed with reason: "Address already in use"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194501: LOG: watchdog child process with pid: 194503 exits with status 768<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194501: FATAL: watchdog child process exit with fatal error. exiting pgpool-II<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: setting the local watchdog node name to "Linux_postgres_server2_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: watchdog cluster configured with 1 remote nodes<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: watchdog remote node:0 on 172.18.255.42:9000<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: interface monitoring is disabled in watchdog<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: IPC socket path: "/tmp/.s.PGPOOLWD_CMD.9000"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: watchdog node state changed from [DEAD] to [LOADING]<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: new watchdog node connection is received from "172.18.255.42:64491"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: new outbond connection to 172.18.255.42:9000<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: watchdog node state changed from [LOADING] to [INITIALIZING]<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-10-25 13:02:50: pid 194504: LOG: Watchdog is shutting down<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information
which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
<br>
<br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>pgpool-general mailing list<o:p></o:p></pre>
<pre><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><o:p></o:p></pre>
<pre><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p> </o:p></span></p>
</div>
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you
should not copy or use this e-mail for any purpose nor disclose its contents to any person.
</body>
</html>