[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,

> 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
http://www.sraoss.co.jp/



More information about the pgpool-general mailing list