[pgpool-general: 8177] Re: Unable to acquire JDBC Connection

Bo Peng pengbo at sraoss.co.jp
Wed May 25 15:15:56 JST 2022


> Hello,
> 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 
> Pgpool:
> "Could not open JPA EntityManager for transaction; nested exception is 
> org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC 
> Connection"
> 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.
> -- 
> Regards,
>    Nikola
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan

More information about the pgpool-general mailing list