- For broker database, 25+ waiting sessions were detected
- Publishing activity was ongoing for broker environment.
- The waiting sessions had below SQL
delete from REFERENCE_ENTRIES where PUBLICATION_ID=:1 and REFERENCED_URI=:2
- The blocking session had below SQL. It had been inactive for 250+ minutes, and was an open/uncommitted transaction.
delete from COMPONENT_PRES_META_DATA where COMPONENT_TEMPLATE_ID=:1 and
PUBLICATION_ID=:2 and COMPONENT_REF_ID=:3
- Deployer's cd_storage_conf config file had an excessively high number of workers configured
<Location Path="<PATH>" WindowSize="40" Workers="20" Cleanup="true"
Interval="2s" RetriesInterval="10s"/>
- Deployer log had multiple occurrences such as the below
ERROR StorageManagerTransactionMonitor - Rolling back a stale transaction:
tcm:0-623128-66560, transaction was waiting for: 604957 ms.