<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi all, <br>i use pgpoll II -3.1.4 with postgresql 9.1.4 and i have OTRS on this cluster. I have noticed in otrs logs (and postgresql) errors like this:<br>ERROR: portal "" does not exist, SQL: 'SELECT id, value_text, value_date, value_int<br><br>as described here :<br>http://www.pgpool.net/mantisbt/view.php?id=14<br>the issue was solved... <br><br>any ideea ? <br><br>Regards,<br>
Adrian Videanu<br><br>--- On <b>Wed, 9/12/12, Gurjeet Singh <i><singh.gurjeet@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Gurjeet Singh <singh.gurjeet@gmail.com><br>Subject: [pgpool-general: 981] Re: Enabling -D switch of pgpool by default<br>To: "PGPool-general" <pgpool-general@pgpool.net>, pgpool-hackers@pgpool.net<br>Date: Wednesday, September 12, 2012, 3:03 AM<br><br><div id="yiv1472535165"><div dir="ltr">Any thoughts on this?<br><br><div class="yiv1472535165gmail_quote">On Thu, Sep 6, 2012 at 9:55 AM, Gurjeet Singh <span dir="ltr"><<a rel="nofollow" ymailto="mailto:singh.gurjeet@gmail.com" target="_blank" href="/mc/compose?to=singh.gurjeet@gmail.com">singh.gurjeet@gmail.com</a>></span> wrote:<br>
<blockquote class="yiv1472535165gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr">Hi All,<br><br> I am considering adding the -D switch by default to the pgpool's initi script, so that pgpool ignores the last known state of a replica when pgpool was shutdown. I have seen situations where a replica goes down, and pgpool sets its state to 3 (CON_DOWN), and even if replica is brought back online, and pgpool restarted (without -D switch), pgpool does not recognize the replica as usable.<br>
<br> Adding -D switch to pgpool startup script solves the problem for me. SO I am wondering if it is a bad idea in some cases to use -D switch by default.<br clear="all"><br>Best regards,<span class="yiv1472535165HOEnZb"><font color="#888888"><br>
-- <br><div dir="ltr">Gurjeet Singh<br>
<br><a rel="nofollow" target="_blank" href="http://gurjeet.singh.im/">http://gurjeet.singh.im/</a><br></div><br>
</font></span></div>
</blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">Gurjeet Singh<br><br><a rel="nofollow" target="_blank" href="http://gurjeet.singh.im/">http://gurjeet.singh.im/</a><br></div><br>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>pgpool-general mailing list<br><a ymailto="mailto:pgpool-general@pgpool.net" href="/mc/compose?to=pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div></blockquote></td></tr></table>