AnsweredAssumed Answered

Alfresco 4.1 with Oracle database: tens of sessions executing UPDATE ALF_NODE are waiting on "enq: TX - row lock contention". What's wrong?

Question asked by riccardohp on Sep 25, 2018
Latest reply on Sep 26, 2018 by riccardohp

This is the UPDATE being executed:

 

SQL Details: 1jx8qmjafqffj: PROD.gruppoitas.local_PROD2 (Database Instance) - Oracle Enterprise Manager

update alf_node set
version = :1



, transaction_id = :2

, audit_creator = :3
, audit_created = :4
, audit_modifier = :5
, audit_modified = :6
, audit_accessed = :7

where
id = :8

and version = (:9 - 1)

Outcomes