[pgpool-general: 7615] Re: Pgpool - ERROR: Sorry, too many clients already

[valsaraj pv]

Hi,

Pgpool-II version: pgpool-II version 4.2.2 (chichiriboshi)
pgpool.conf attached. Kindly check.

Thanks!


On Thu, Jul 1, 2021 at 1:46 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > Hi,
> >
> > After integrating pgpool with the app server, we tested by running load
> > tests with 25 concurrent users.
> > The following error comes multiple times while test running:
> >
> >> ERROR:  Sorry, too many clients already
> >> LOG:  backend [1]: WARNING: there is already a transaction in progress
> >
> >
> > Set the following in pgpool:
> > connection_cache=off
> > child_life_time = 5min
> > num_init_children=120
> > max_pool=1
> >
> > There are master-slave postgre DB servers with max_connections=250.
> > There are 2 appservers with XADatasource max pool size 60, pointing to
> the
> > Pgpool server.
> > The application connects to 4 databases but only one database is used
> 90%.
> >
> > When we point directly to the master DB server, all works fine. But when
> > connected via the Pgpool server, these errors come intermittently.
> >
> > Is it because Pgpool connections are not getting released and are all in
> > active state?
> > Is there any way the excess connection requests in the queue instead
> > of throwing errors so that it will be processed once existing connections
> > are released?
> > Anyone please help me identify the bottleneck.
>
> Can you share the exact Pgpool-II version and pgpool.conf?
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>


-- 
Life is like this: "Just when we get all the answers of life.... God
changes the question paper....

Valsaraj Viswanathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210701/9d3473e6/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 47077 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210701/9d3473e6/attachment.obj>