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
Max connections to the MySQL database was exceeded,
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
Needed to increase the number of max connections on the MySQL database from 151 to 512.
Resolved the issue on the Portal.
I found information on this issue from link:
https://www.thegeekdiary.com/mysql-error-too-many-connections-and-how-to-resolve-it/