<div dir="ltr"><div>Hello.<br><br></div>What does Pgpol log file say?<br><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Mar 10, 2016 at 4:01 PM, Avi Weinberg <span dir="ltr"><<a href="mailto:AviW@gilat.com" target="_blank">AviW@gilat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="#0563C1" vlink="#954F72" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<div>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:#1f497d">Hi all<u></u><u></u></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></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:<u></u><u></u></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></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 <u></u>
<u></u></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></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"><u></u><u></u></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p>
<p style="background:white"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks!<u></u><u></u></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></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 <u></u>
<u></u></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
<p style="background:white"><span style="font-family:"Calibri",sans-serif;color:black"><u></u> <u></u></span></p>
</div>
</div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>