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

book

Article ID: 208398

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

 

We sometimes get this error:

Environment:
***************************************
* DevTest 10.5.0
* All Server Components on Windows 2012 R2 24 GB RAM
* Databases running on MySQL 5.7.29-log
* No DevTest patches applied

Devtest components distribution:

04-- MySQL ,IAM, Enterprise Dashboard
03-- Registry, portal, Coordinator, Simulator, VSE
02-- Registry, portal, BrokerService , Coordinator, Simulator, VSE
01-- Registry, portal, BrokerService , Coordinator, Simulator, VSE

Current vmoptions starting memory:

Registry Service: 4g
Portal Service: 4g
Coordinator Service: 3g
Simulator Service: 4g

Cause

Max connections to the MySQL database was exceeded,

Environment

Release : 10.5

Component : CA Service Virtualization

 

Environment:
***************************************
* DevTest 10.5.0
* All Server Components on Windows 2012 R2 24 GB RAM
* Databases running on MySQL 5.7.29-log
* No DevTest patches applied

Resolution

Needed to increase the number of max connections on the MySQL database from 151 to 512.

Resolved the issue on the Portal.

Additional Information

I found information on this issue from link:

https://www.thegeekdiary.com/mysql-error-too-many-connections-and-how-to-resolve-it/