Devtest registry maxing out connections to the database

Products

• Service Virtualization

Issue/Introduction

Inactive sessions spiking up on the DevtTest Registry DB server, and leading to spike in the process utilization.

Environment

DevTest server Registry database environment

Cause

Database connection pool configuration caused the issue.

Resolution

Making the below changes on DevTest servers will resolve the issue:

1. Stop all the running DevTest Services

2. Quit workstation.

3. On all servers: Delete the file "HikariCP-java7-2.4.13.jar" from LISA_HOME/lib/shared folder.NO NEED TO BACKUP THIS JAR FILE. IF YOU STILL WANT TO, THEN MOVE THIS FILE OUTSIDE LISA_HOME.

4. On Registry server: Edit site.properties file. There will be a set of DB connection properties that already exist in this file. Update some of those properties and add the new ones as shown below and save the file.

lisadb.pool.common.minPoolSize=1

lisadb.pool.common.initialPoolSize=0

lisadb.pool.common.maxPoolSize=10

lisadb.pool.common.acquireIncrement=1

lisadb.pool.common.maxIdleTime=1800

lisadb.pool.common.idleConnectionTestPeriod=300

lisadb.pool.common.maxIdleTimeExcessConnections=240

lisadb.pool.common.testConnectionOnCheckin=true

5.Start all the DevTest Services That were stopped in Step 1.