public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tatsuo Ishii <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Re: Sudden increase in connections in pgpool usage environment
Date: Mon, 28 Jul 2025 19:55:22 +0900 (JST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

> Hello,
> Thank you for always providing the convenient pgpool service.
> We really appreciate it.
> *This email was created using automatic translation from Japanese.
> 
> At the moment, we have no idea what the cause might be,
> but we are experiencing a serious issue in the environment where
> pgpool is used—
> sudden spikes in the number of connections to PostgreSQL, which is
> causing us great trouble.
> 
> The environment is as follows:
> 
> Server 1: Tomcat / pgpool (4.2.1) / PostgreSQL (13.11)
> Server 2: PostgreSQL (13.11)
> 
> • A custom-built web system is running on Tomcat.
> • The number of connections from Tomcat to pgpool is capped at 300.
> • pgpool is used to provide redundancy between the PostgreSQL servers on
> • Server 1 and Server 2.
> • There is only one database running on PostgreSQL, and only one user
> • connects to it.
> 
> In this setup, the number of connections, which is usually around 25,
> suddenly increases to 100, 200, and even up to the maximum of 300 in
> just a few minutes.
> This phenomenon occurs irregularly.
> 
> We initially suspected an issue in our custom system and ran
> pg_stat_activity to check the "query" column.
> However, only a few queries appeared to be issued by our system.
> Most of the entries were in the "idle" state after executing a
> "DISCARD ALL" query.
> 
> We suspect that some setting might be triggering a mass reset of
> connection,
> but due to our limited knowledge, we are struggling with the
> investigation.
> We apologize for the trouble, but if you have any insights, we would
> greatly appreciate it.
> 
> 
> We apologize for the trouble, but if you have any idea what might be
> happening,
> we would greatly appreciate your insight.

First of all, Pgpool-II 4.2.1 is pretty old (released 5 years ago).
It has lots of bugs and even multiple vulnerabilities. I strongly
recommend you to upgrade to newer version of Pgpool-II.

> Server 1: Tomcat / pgpool (4.2.1) / PostgreSQL (13.11)

Is it possible Server1 overloaded? I am asking because on server1 3
kinds of servers are running. I suspect pgpool process are not enough
CPU being assigned, and cannot dispatch incoming new connections.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Sudden increase in connections in pgpool usage environment
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox