[pgpool-general: 5896] Re: pgpool frequnet authentication timeout

Muhammad Usama m.usama at gmail.com
Thu Jan 25 23:39:24 JST 2018


Hi Joshi,

Does this "authentication timeout" happens randomly or it starts happening
after some watchdog event/pcp command.
Also please share the pgpool.conf file you are using.

Thanks
Best Regards
Muhammad Usama



On Tue, Jan 16, 2018 at 2:55 PM, Pankaj Joshi <pankajjo02 at gmail.com> wrote:

> 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
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180125/1f8b5487/attachment.html>


More information about the pgpool-general mailing list