<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=us-ascii">
<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;}
/* 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;}
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@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 lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">Thanks for the fast reply to my previous IP bonding issue.
<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">I have a setup with two pgpools servers with pgpool failover capability enabled.<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">I do not know if this is also related to IP bonding, but when I write a shell script to constantly perform pgpool restart I very fast get the following "pgpool dead but subsys locked".
If I run the restart scrip on two terminals I get it in matter of seconds.<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"><o:p> </o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">[root@postgres_server1 ~]# service pgpool status<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">pgpool dead but subsys locked<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"><span lang="HE" dir="RTL" style="font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed"><span dir="LTR"></span><span dir="LTR"></span>2016-08-18 15:27:02: pid 61622: LOG: watchdog child process with pid: 61624 exits with status 768<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:02: pid 61622: 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-08-18 15:27:02: pid 61625: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:02: pid 61625: 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-08-18 15:27:02: pid 61625: 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-08-18 15:27:02: pid 61625: 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-08-18 15:27:04: pid 61644: FATAL: could not read pid file<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61685: LOG: reading status file: 1 th backend is set to down status<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61685: LOG: waiting for watchdog to initialize<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61687: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61687: 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-08-18 15:27:04: pid 61687: 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-08-18 15:27:04: pid 61687: 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-08-18 15:27:04: pid 61687: FATAL: failed to create watchdog receive socket<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61687: DETAIL: bind on "0.0.0.0:cslistener" 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-08-18 15:27:04: pid 61685: LOG: watchdog child process with pid: 61687 exits with status 768<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61685: 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-08-18 15:27:04: pid 61688: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:04: pid 61688: 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-08-18 15:27:04: pid 61688: 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-08-18 15:27:04: pid 61688: 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-08-18 15:27:05: pid 61708: FATAL: could not read pid file<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61748: LOG: reading status file: 1 th backend is set to down status<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61748: LOG: waiting for watchdog to initialize<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61750: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61750: 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-08-18 15:27:05: pid 61750: 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-08-18 15:27:05: pid 61750: 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-08-18 15:27:05: pid 61750: FATAL: failed to create watchdog receive socket<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61750: DETAIL: bind on "0.0.0.0:cslistener" 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-08-18 15:27:05: pid 61748: LOG: watchdog child process with pid: 61750 exits with status 768<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61748: 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-08-18 15:27:05: pid 61751: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:05: pid 61751: 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-08-18 15:27:05: pid 61751: 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-08-18 15:27:05: pid 61751: 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-08-18 15:27:06: pid 61770: FATAL: could not read pid file<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61810: LOG: reading status file: 1 th backend is set to down status<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61810: LOG: waiting for watchdog to initialize<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61812: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61812: 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-08-18 15:27:07: pid 61812: 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-08-18 15:27:07: pid 61812: 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-08-18 15:27:07: pid 61812: FATAL: failed to create watchdog receive socket<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61812: DETAIL: bind on "0.0.0.0:cslistener" 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-08-18 15:27:07: pid 61810: LOG: watchdog child process with pid: 61812 exits with status 768<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61810: 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-08-18 15:27:07: pid 61813: LOG: setting the local watchdog node name to "Linux_postgres_server1_9999"<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">2016-08-18 15:27:07: pid 61813: 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-08-18 15:27:07: pid 61813: 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-08-18 15:27:07: pid 61813: 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-08-18 15:27:35: pid 58439: LOG: watchdog: lifecheck started<o:p></o:p></p>
<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed">^C<o:p></o:p></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>