Deadlock when computers are deleted

Products

• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Software Delivery

Issue/Introduction

When a computer is deleted, it could take long time and some locks are set in table usd_class_version

This could generate GUI performance problem or problem/error during creation of SD Job Container

 

Environment

Client Automation 14.5 - Any version

Resolution

Open a case at CA Broadcom Technical Support requesting the fix T5KP078

 

This fix delivers a new version of usd_trg_d_agent_usd_rel trigger of table ca_agent.

This new trigger reduce the time of lock in table usd_class_version and so minimize the risk to get a deadlock.