[pgpool-general: 7964] Antwort: Re: Antwort: Re: Re: Pgpool does not accept new connections (Tatsuo Ishii)
ehansmair at prompt-software.de
ehansmair at prompt-software.de
Mon Dec 27 17:10:52 JST 2021
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>
More information about the pgpool-general
mailing list