<div dir="ltr">Hi Joshi,<div><br></div><div>Does this "<span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">authentication</span><span style="font-size:12.8px"> </span><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">timeout" happens randomly or it starts happening after some watchdog event/pcp command.</span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">Also please share the pgpool.conf file you are using.</span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px"><br></span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">Thanks</span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">Best Regards</span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px">Muhammad Usama</span></div><div><span class="gmail-il" style="background-color:rgb(255,255,255);font-size:12.8px"><br></span></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 16, 2018 at 2:55 PM, Pankaj Joshi <span dir="ltr"><<a href="mailto:pankajjo02@gmail.com" target="_blank">pankajjo02@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello Team ,<br><br>I am using pgpool-II version 3.6.5 (subaruboshi)
with postgres 9.6.4 as backend , our setup uses watchdog as well and
have 2 nodes in which the postgres runs . recently <br>have started to see lot of authentication timeout in pgpool logs . <br><br>like <br><br>Jan 16 00:05:20 servername pgpool[23096]: [10091-1] 2018-01-16 00:05:20: pid 23096: LOG: authentication timeout<br>Jan
16 00:05:20 servername pgpool[7393]: [10117-1] 2018-01-16 00:05:20: pid
7393: LOG: child process with pid: 23096 exits with status 256<br>Jan 16 00:05:20 servername pgpool[7393]: [10118-1] 2018-01-16 00:05:20: pid 7393: LOG: fork a new child process with pid: 3865<br>Jan 16 00:05:20 servername pgpool[21532]: [9711-1] 2018-01-16 00:05:20: pid 21532: LOG: authentication timeout<br>Jan
16 00:05:20 servername pgpool[7393]: [10119-1] 2018-01-16 00:05:20: pid
7393: LOG: child process with pid: 21532 exits with status 256<br>Jan 16 00:05:20 servername pgpool[7393]: [10120-1] 2018-01-16 00:05:20: pid 7393: LOG: fork a new child process with pid: 3866<br>Jan 16 00:05:21 servername pgpool[10125]: [10108-1] 2018-01-16 00:05:21: pid 10125: LOG: authentication timeout<br>Jan
16 00:05:21 servername pgpool[7393]: [10121-1] 2018-01-16 00:05:21: pid
7393: LOG: child process with pid: 10125 exits with status 256<br>Jan 16 00:05:21 servername pgpool[7393]: [10122-1] 2018-01-16 00:05:21: pid 7393: LOG: fork a new child process with pid: 3965<br>Jan 16 00:05:22 servername pgpool[7782]: [10013-1] 2018-01-16 00:05:22: pid 7782: LOG: authentication timeout<br>Jan
16 00:05:22 servername pgpool[7393]: [10123-1] 2018-01-16 00:05:22: pid
7393: LOG: child process with pid: 7782 exits with status 256<br>Jan 16 00:05:22 servername pgpool[7393]: [10124-1] 2018-01-16 00:05:22: pid 7393: LOG: fork a new child process with pid: 4033<br>Jan 16 00:05:27 servername pgpool[7626]: [10053-1] 2018-01-16 00:05:27: pid 7626: LOG: authentication timeout<br>Jan
16 00:05:27 servername pgpool[7393]: [10125-1] 2018-01-16 00:05:27: pid
7393: LOG: child process with pid: 7626 exits with status 256<br>Jan 16 00:05:27 servername pgpool[7393]: [10126-1] 2018-01-16 00:05:27: pid 7393: LOG: fork a new child process with pid: 4383<br>Jan 16 00:05:37 servername pgpool[30028]: [10009-1] 2018-01-16 00:05:37: pid 30028: LOG: authentication timeout<br>Jan
16 00:05:37 servername pgpool[7393]: [10127-1] 2018-01-16 00:05:37: pid
7393: LOG: child process with pid: 30028 exits with status 256<br>Jan 16 00:05:37 servername pgpool[7393]: [10128-1] 2018-01-16 00:05:37: pid 7393: LOG: fork a new child process with pid: 5059<br>Jan 16 00:05:41 servername pgpool[23825]: [10007-1] 2018-01-16 00:05:41: pid 23825: LOG: authentication timeout<br>Jan
16 00:05:41 servername pgpool[7393]: [10129-1] 2018-01-16 00:05:41: pid
7393: LOG: child process with pid: 23825 exits with status 256<br>Jan 16 00:05:41 servername pgpool[7393]: [10130-1] 2018-01-16 00:05:41: pid 7393: LOG: fork a new child process with pid: 5306<br>Jan 16 00:05:41 servername pgpool[9805]: [10104-1] 2018-01-16 00:05:41: pid 9805: LOG: authentication timeout<br>Jan
16 00:05:41 servername pgpool[7393]: [10131-1] 2018-01-16 00:05:41: pid
7393: LOG: child process with pid: 9805 exits with status 256<br><br><br>when I check postgres logs I do not see any logs pertaining to the connection failures or timeouts.<br><br>This pattern mostly goes till next 2-3 mins and then becomes normal, the occurrence is random .<br><br>I am not sure if its pgpool issue or postgres is having some issues .<br><br>let me know the information which I shoud be providing to be able to identify /fix it.<br><br><br>Thanks<span class="HOEnZb"><font color="#888888"><br>Pankaj Joshi<br></font></span></div>
<br>______________________________<wbr>_________________<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/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>