NetOps Portal Services crashing

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration

Issue/Introduction

The NetOps Portal Services  is crashing. 

Environment

Component: Dat Aggregator

Cause

The cause of these crashes was due to having too many connections to the mysql database and causing java exceptions and errors. Below are the exceptions and errors seen: 

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fail

The last packet successfully received from the server was 21,250 milliseconds ago. The last packet sent successfully to the server was 17 milliseconds ago. 

ERROR | wrapper | 2017/08/30 14:23:48 | Shutdown failed: Timed out waiting for the JVM to terminate. 

ERROR | wrapper | 2017/08/30 14:23:48 | JVM did not exit on request, termination requested. 

STATUS | wrapper | 2017/08/30 14:23:48 | JVM received a signal SIGKILL (9). 

STATUS | wrapper | 2017/08/30 14:23:48 | JVM process is gone. 

STATUS | wrapper | 2017/08/30 14:23:48 | JVM exited after being requested to terminate. 

 

Resolution

In the file  /opt/CA/PerformanceCenter/PC/webapps/pc/WEB-INF/cfg/portal.console.properties increase the variable dbMaxActive in increments of 20, testing to validate between each raise to ID the correct value.