<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;
font-size:12.0pt;
font-family:"Times New Roman",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;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.EmailStyle18
{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 lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<div id="divtagdefaultwrapper">
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:#1F497D">Hi all<o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Today I was unable to connect to pgpool virtual IP and port 9999 (version 3.5). I checked the running processes and got the following:<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">[root@pgpool pgpool-II-95]# ps -ef | grep pool<br>
root 5561 9837 0 Mar08 pts/1 00:00:16 pgpool -n -d -a pool_hba.conf<br>
root 5562 5561 0 Mar08 pts/1 00:00:08 pgpool: watchdog <br>
root 5563 5561 0 Mar08 pts/1 00:00:02 pgpool: lifecheck <br>
root 5567 5563 0 Mar08 pts/1 00:00:04 pgpool: heartbeat receiver <br>
root 5569 5563 0 Mar08 pts/1 00:00:05 pgpool: heartbeat sender <br>
root 12688 5561 0 10:31 pts/1 00:00:00 pgpool: PCP: wait for connection request<br>
root 12689 5561 0 10:31 pts/1 00:00:03 pgpool: worker process <o:p>
</o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black">After pgpool restart
</span><span style="font-family:"Calibri",sans-serif;color:#1F497D">I got a much larger list and I was able to connect. What might have caused the above situation that required me to reset pgpool?</span><span style="font-family:"Calibri",sans-serif;color:black"><o:p></o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Thanks!<o:p></o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="margin-bottom:12.0pt;background:white"><span style="font-family:"Calibri",sans-serif;color:black">[root@pgpool pgpool-II-95]# ps -ef | grep pool<br>
root 13629 9837 0 16:50 pts/1 00:00:00 pgpool -n -d -a pool_hba.conf<br>
root 13630 13629 0 16:50 pts/1 00:00:00 pgpool: watchdog <br>
root 13638 13629 0 16:50 pts/1 00:00:00 pgpool: lifecheck <br>
root 13639 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13641 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13642 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13643 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13644 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13645 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13646 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13647 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13649 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13650 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13651 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13652 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13653 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13654 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13655 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13656 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13657 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13658 13638 0 16:50 pts/1 00:00:00 pgpool: heartbeat receiver <br>
root 13659 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13660 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13661 13638 0 16:50 pts/1 00:00:00 pgpool: heartbeat sender <br>
root 13662 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13663 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13664 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13665 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13666 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13667 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13668 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13669 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13670 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13671 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13672 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13673 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13674 13629 0 16:50 pts/1 00:00:00 pgpool: wait for connection request<br>
root 13675 13629 0 16:50 pts/1 00:00:00 pgpool: PCP: wait for connection request<br>
root 13677 13629 0 16:50 pts/1 00:00:00 pgpool: worker process <o:p>
</o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><o:p> </o:p></span></p>
</div>
</div>
</body>
</html>