Shutdown / Failover occurred in ESP dSereis (DE) due to DB connection reset (High Availability)

Products

• CA Workload Automation DE
• CA Workload Automation DE - Scheduler (dSeries)
• CA Workload Automation DE - Business Agents (dSeries)
• CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

The Primary DE server failed over.  Tracelog shows the following messages

2021XXXX 00:00:12.345 [relationaldatabase] [ERROR] DM.dm-timer-pop: [2021-xx-xx_00:00:12.345] Database Connection is NOT Valid. Removing from pool
java.sql.SQLRecoverableException: IO Error: Connection reset by peer
 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:821)
....

2021XXXX 00:00:12.345 [relationaldatabase] [ERROR] DM.dm-timer-pop: [2021-11-05_20:20:50.082] SQLCode: 17008 SQLState: 08003 Message: Closed Connection
2021XXXX 00:00:12.345 [relationaldatabase] [WARN] DM.dm-timer-pop: [2021-11-05_20:20:50.082] SQLException of SQLCode: 17008 SQLState: 08003 translated to TransientConnection

 

 

Environment

Release : 12.3

Component : CA DSERIES WORKLOAD AUTOMATION HIGH AVAILABILITY

Cause

The ESP dSeries (DE) server got a connection reset from the Database.  This will result in Primary shutting down.  If DE has high availability (HA) enabled, then Standby will take over.

Resolution

Check if there is network issue between DE and Database.  Check if there is an issue with the database