<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div>Hi Devrim,<br><br></div>I just checked the sources from the link you provided for the pgpool.init:<br><a href="http://svn.pgrpms.org/repo/rpm/redhat/9.3/pgpool-II/EL-6/pgpool.init">http://svn.pgrpms.org/repo/rpm/redhat/9.3/pgpool-II/EL-6/pgpool.init</a><br>
<br></div>And it's still version 2.3 over there. That doesn't account for the problems described here:<br><a href="http://www.sraoss.jp/pipermail/pgpool-hackers/2012-May/000068.html">http://www.sraoss.jp/pipermail/pgpool-hackers/2012-May/000068.html</a><br>
</div>and here:<br><a href="http://lists.pgfoundry.org/pipermail/pgpool-hackers/2010-November/000407.html">http://lists.pgfoundry.org/pipermail/pgpool-hackers/2010-November/000407.html</a><br><br></div>The problem seems to be also described in this bug ticket: <a href="http://www.pgpool.net/mantisbt/view.php?id=12">http://www.pgpool.net/mantisbt/view.php?id=12</a><br>
<br></div>I can consistently reproduce it. How to reproduce it:<br></div>* configure pgpool-II to use watchdog with two nodes<br></div>say delegate_IP is on the primary node<br></div>* then service pgpool stop on the primary node will bring down the delegate_IP interface and that would go to the secondary node, but it would not remove the /var/run/pgpool_status and both socket files (for pcp 9898 and pgpool 9999). Hence when you try to start it later it will fail with cannot bind to socket error.<br>
</div>That also makes 'service pgpool restart' fail on the node that has the delegate_IP assigned at the moment.<br><br></div>It works fine on the node that doesn't have delegate_IP assigned and also works fine on the primary node with delegate_IP BUT only when the secondary node is already down.<br>
<br></div>Looks like it can be traced to how the 'pgpool stop' calls killproc and only when watchdog with delegate_IP is configured (with ifconfig to bring the interface up/down).<br><div><div><div><div><div><div>
<br><div><div><div><div><br><br></div></div></div></div></div></div></div></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sun, Mar 16, 2014 at 4:53 PM, Devrim GÜNDÜZ <span dir="ltr"><<a href="mailto:devrim@gunduz.org" target="_blank">devrim@gunduz.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
Hi,<br>
<br>
Now we have the community RPM repository, RPMS are there:<br>
<br>
<a href="http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/repoview/pgpool-II-93.html" target="_blank">http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/repoview/pgpool-II-93.html</a><br>
<br>
This also includes the fixes there. Still, if you want to use the<br>
sources, and not the RPMs, then:<br>
<br>
<a href="http://svn.pgrpms.org/repo/rpm/redhat/9.3/pgpool-II/EL-6/" target="_blank">http://svn.pgrpms.org/repo/rpm/redhat/9.3/pgpool-II/EL-6/</a><br>
<br>
is the URL for the spec file and other patches we have.<br>
<br>
Regards, Devrim<br>
<div class="HOEnZb"><div class="h5"><br>
On Sat, 2014-03-15 at 22:23 -0700, Alexandru Cardaniuc wrote:<br>
><br>
><br>
> Was reading 2012 mailing list and saw a thread about issues with<br>
> redhat<br>
> pgpool.init script. But it doesn't look like any changes have been<br>
> made to<br>
> the checked-in pgpool.init script. The last version is still the one<br>
> from 4<br>
> years ago?:<br>
> # v2.2.5 Devrim GUNDUZ <devrim@CommandPrompt.com><br>
> # - Fix logging.<br>
><br>
> And that's the one checked-in the latest version of pgpool sources. I<br>
> get<br>
> it when I build using pgpool-II-3.3.2.tar.gz<br>
><br>
> Is there a newer version of the pgpool.init script that is for some<br>
> reason<br>
> not included in the latest sources tarball?<br>
<br>
<br>
--<br>
</div></div><span class="HOEnZb"><font color="#888888">Devrim GÜNDÜZ<br>
Principal Systems Engineer @ EnterpriseDB: <a href="http://www.enterprisedb.com" target="_blank">http://www.enterprisedb.com</a><br>
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer<br>
Twitter: @DevrimGunduz , @DevrimGunduzTR<br>
<br>
<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>Sincerely yours,<br>Alexandru Cardaniuc
</div>