[pgpool-general: 8177] Re: Unable to acquire JDBC Connection
pengbo at sraoss.co.jp
Wed May 25 15:15:56 JST 2022
> Our application use Pgpool in k8s with docker image pgpool/pgpool2, and
> our PostgreSQL nodes are on virtual machines.
> When we tried to perform load test our application, we have received a
> lot of errors of application services that connect to database through
> "Could not open JPA EntityManager for transaction; nested exception is
> org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC
> If application connects to database directly without Pgpool, this error
> does not appear.
The setting of num_init_children may cause this error.
Could you run ps command and check if there are processes in the "wait for connection request" status?
How many Pgopol-II replicas do you configured?
What are the values of num_init_children, max_pool and PostgreSQL's max_connections.
> Do you have any experience with such problem and could you tell why it
> occurs, i.e. why the service can't connect Pgpool and how to fix it?
> Thanks in advance.
> pgpool-general mailing list
> pgpool-general at pgpool.net
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general