[pgpool-general: 7964] Antwort: Re: Antwort: Re: Re: Pgpool does not accept new connections (Tatsuo Ishii)

[ehansmair at prompt-software.de]

Hi,

attached you will find the list of pgpool-Processes at the moment when the 
access to the database seems to freeze.

We the have tried serialize_accept  with on and off - the problem remains. 
Only the child process state changes. 

We have in our pgpool configuration

        num_init_children = 300 

At the  postgresql we tried   max_connection from 200 up to  800 - no 
difference.

So we see hundreds of pgpool childs waiting:

        pgpool: wait for accept lock







With Regards

Ernst Hansmair




Von:    "Tatsuo Ishii" <ishii at sraoss.co.jp>
An:     ehansmair at prompt-software.de
Kopie:  pgpool-general at pgpool.net
Datum:  18.12.2021 05:51
Betreff:        Re: Antwort: Re: [pgpool-general: 7941] Re: Pgpool does 
not accept new connections (Tatsuo Ishii)



> Hello,
> 
> I am sorry, we are using Pgpool 4.2.5. The pcp_proc_info of that Version 

> does not show the process status.

Ok. You can use standard ps command to know the process status.

  23669 pts/3    S      0:00 pgpool: wait for connection request

If you see some pgpool process in "wait for connection request" state,
then it means pgpool have room to accept connections from clients.

Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211227/77cb923a/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: xx.txt
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211227/77cb923a/attachment.txt>