<div dir="ltr">Hi<div><br></div><div><div class="gmail_extra">This is the bug in the latest version pgpool-II 3.5. The fix for it is already pushed in the repository and you can pull the latest code if you are building the pgpool form the source. See the pgpool-general thread for more details<div><br></div><div><a href="http://www.pgpool.net/pipermail/pgpool-general/2016-March/004586.html">http://www.pgpool.net/pipermail/pgpool-general/2016-March/004586.html<br></a></div><div><br></div><div>Regards</div><div>Muhammad Usama</div><div><br></div><div class="gmail_quote">On Fri, Mar 11, 2016 at 11:28 PM, Lucas Luengas <span dir="ltr"><<a href="mailto:lucasluengas@gmail.com" target="_blank">lucasluengas@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><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"><div><div class="h5">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></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div><div class="h5">
<div link="#0563C1" vlink="#954F72" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<p style="background:white"><span style="font-family:Calibri,sans-serif;color:rgb(31,73,125)">Hi all<u></u><u></u></span></p>
<p style="background:white"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p style="background:white"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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:rgb(31,73,125)">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:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p style="background:white"><span style="font-size:11pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">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:12pt;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></div></div>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">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>
<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></div></div>