[pgpool-general: 5863] pgpool frequnet authentication timeout

Pankaj Joshi pankajjo02 at gmail.com
Tue Jan 16 18:55:15 JST 2018


Hello Team ,

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
have started to see lot of authentication timeout in pgpool logs .

like

Jan 16 00:05:20 servername pgpool[23096]: [10091-1] 2018-01-16 00:05:20:
pid 23096: LOG:  authentication timeout
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
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
Jan 16 00:05:20 servername pgpool[21532]: [9711-1] 2018-01-16 00:05:20: pid
21532: LOG:  authentication timeout
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
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
Jan 16 00:05:21 servername pgpool[10125]: [10108-1] 2018-01-16 00:05:21:
pid 10125: LOG:  authentication timeout
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
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
Jan 16 00:05:22 servername pgpool[7782]: [10013-1] 2018-01-16 00:05:22: pid
7782: LOG:  authentication timeout
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
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
Jan 16 00:05:27 servername pgpool[7626]: [10053-1] 2018-01-16 00:05:27: pid
7626: LOG:  authentication timeout
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
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
Jan 16 00:05:37 servername pgpool[30028]: [10009-1] 2018-01-16 00:05:37:
pid 30028: LOG:  authentication timeout
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
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
Jan 16 00:05:41 servername pgpool[23825]: [10007-1] 2018-01-16 00:05:41:
pid 23825: LOG:  authentication timeout
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
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
Jan 16 00:05:41 servername pgpool[9805]: [10104-1] 2018-01-16 00:05:41: pid
9805: LOG:  authentication timeout
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


when I check postgres logs I do not see any logs pertaining to the
connection failures or timeouts.

This pattern mostly goes till next 2-3 mins and then becomes normal, the
occurrence is random .

I am not sure if its pgpool issue or postgres is having some issues .

let me know the information which I shoud be providing to be able to
identify /fix it.


Thanks
Pankaj Joshi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180116/121220f7/attachment.html>


More information about the pgpool-general mailing list