Deadlocks on ODF_UI_LIST_COLS when updating MUX Grid views with list columns

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

On a busy Clarity system when multiple users updating the views resulting in dead lock on table  ODF_UI_LIST_COLS

 

Steps to Reproduce:

1. Login to Clarity
2. Have around 100+ users update their views in mux

Expected Results: Updating views should be fast

Actual Results: Updating views takes longer and dead locks resulting in blocking sessions

ERROR 2023-12-15 10:07:28,603 [XXXXX] service.ListColumnInstanceClass (clarity:xxxxxxx:xxxx:PPM_REST_API) Exception occurred while updating removed sort column for the view: XXXX
com.niku.union.persistence.PersistenceDeadlockException:
SQL error code: 60
Error message: ORA-00060: deadlock detected while waiting for resource

 

Environment

Clarity 16.1.3, 16.2.0, 16.2.1

Resolution

DE79591, fixed in 16.2.2 and 16.1.3.4

Workaround: Pro-actively monitor the database for blocking and kill the master blocker