<div dir="ltr"><div>Hi Ishii-San</div><br><div class="gmail_quote"><div dir="ltr">On Thu, Jan 10, 2019 at 11:52 AM Tatsuo Ishii &lt;<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>&gt; wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">It is pointed out that watchdog lifecheck method with query mode does<br>
not work since 4.0.<br>
<br>
<a href="https://www.pgpool.net/mantisbt/view.php?id=455" rel="noreferrer" target="_blank">https://www.pgpool.net/mantisbt/view.php?id=455</a><br>
<br>
The cause of this is using thread unsafe function<br>
get_pgpool_config_user_password(). Making it thread safe requires none<br>
trivial work. So I tend to agree that we disable using AES encrypted<br>
password for lifecheck method = &quot;query&quot;.<br>
<br></blockquote><div><br></div>Yes that&#39;s true, making get_pgpool_config_user_password thread safe would be lot of work.</div><div class="gmail_quote">I am thinking what if change the code and call get_pgpool_config_user_password() from outside the thread function before creating</div><div class="gmail_quote">the threads and pass in the password as the argument to the thread function. This way we can keep supporting the  AES encrypted<br>password for lifecheck method = &quot;query&quot;</div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">Thanks</div><div class="gmail_quote">Best Regards</div><div class="gmail_quote">Muhammad Usama</div><div class="gmail_quote"><br>











<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Any objection?<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net" target="_blank">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
</blockquote></div></div>