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

Products

• Service Virtualization

Issue/Introduction

 

Sometimes get this error from the Portal:

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

 

Environment

All Supported DevTest releases.

Databases running on MySQL 5.7.29

Cause

Max connections to the MySQL database was exceeded,

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

Information on this issue from link:

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