Frequent deadlocks are observed in app-ca.logs and slowness with queries getting blocked in the database.
SQL error code: 0
Error message: ERROR: deadlock detected
Detail: Process 12632 waits for ExclusiveLock on tuple (384284,3) of relation 50436696 of database 50431660; blocked by process 14294.
Process 14294 waits for ShareLock on transaction 2562081638; blocked by process 17775.
Process 17775 waits for ExclusiveLock on tuple (1972,13) of relation 50436495 of database 50431660; blocked by process 13272.
Process 13272 waits for ShareLock on transaction 2560437388; blocked by process 12632.
Hint: See server log for query details.
set percentage = (CASE WHEN COALESCE(?,0) = 0 THEN NULL ELSE total_cost / ? END)
,LAST_UPDATED_DATE = ?
,LAST_UPDATED_BY = ?
where FIN_COST_PLAN_DETAILS.plan_id = ?
Since the introduction of SQL Curve a few defects are observed including this defect DE60813
Release : 15.9.1, 15.9.2 , 15.9.3
Fixed in upcoming release 16.0 as DE60813