Opened 2 years ago

Closed 2 years ago

#2589 closed defect (fixed)

petascope - reduce number of active and idle connections for Tomcat JDBC

Reported by: Bang Pham Huu Owned by: Bang Pham Huu
Priority: major Milestone: 10.0
Component: petascope Version: 9.8
Keywords: Cc: Dimitar Misev
Complexity: Medium

Description

By default, postgresql supports only 100 connections, Tomcat JDBC connection pools also has default 100 maxActive and maxIdle settings.

They cause problem in petascope with 

Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
Caused by: Unable to acquire JDBC Connection
Caused by: FATAL: sorry, too many clients already

This needs to be fixed in petascope.properties to reduce number of connections in Tomcat JDBC pool.

Change History (1)

comment:1 by Dimitar Misev, 2 years ago

Resolution: → fixed
Status: assigned → closed
Note: See TracTickets for help on using tickets.