search cancel

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

book

Article ID: 228235

calendar_today

Updated On:

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

 

 

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.

Environment

Release : 12.3

Component : CA DSERIES WORKLOAD AUTOMATION HIGH AVAILABILITY

Resolution

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