Unable to remove hang release via JMX

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

Hello

We have a release blocked from a day. We tried to delete it and remove it even from the JMX console following the documentation. The JMX invocation to remove release fails with below error

Invocation successful
Result value:
 Release [891643] stopped successfully.
 Release [891643] removed from execution cache successfully.
 Failed removing release [891643] from DB: ObjectOptimisticLockingFailureException - Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1.

Environment

Release : 6.7

Component : CA RELEASE AUTOMATION CORE

Cause

There is an associated java process found pertaining to the release, which restricts the JMX from removing the release.

 

Resolution

1. Identify the associated java process related to the particular release and kill the process.
2. Post associated process is killed try to remove the release via JMX and it will be successful.

 

Additional Information

Knowledge Base

 How to remove hung release via JMX

In case if above resolution doesn't help please enable turnOnHibernateSQLLogging, turnOnHibernateBindParametersLogging as described in KB Hibernate Logging Plus and share the complete NAC logs with support on support ticket for assistance.