SV: Error 500 - Failed to connect to reporting database. Data source rejected establishment of connection, message from server: "Too many connections"

book

Article ID: 209038

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

 


Regarding the error “Error 500 - Failed to connect to reporting database. Data source rejected establishment of connection, message from server: "Too many connections"”

One more thing I notice even after increasing the connection to 600 we see the error reason being the Registry DB is taking up all the threads and they are in SLEEP status.

The Registry DB has only 7 monitors running every 30mins. Not sure why so many connections is taken up. Even if I kill the process after a second there will be a process with Calisa_registry DB. Even reducing the interactive_timeout is not effective because as soon a process is killed calisa_registry would create one more.

Cause

N/A

Environment

Release : 10.5

Component : CA Service Virtualization

Resolution

 

Open a support case and refer to defect DE465805.

Additional Information

patch_DE465805_10.5.0_GA.jar