ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Database deadlock/slowness post upgrade to 15.9.1

book

Article ID: 219259

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Frequent deadlocks are observed in app-ca.logs and slowness with queries getting blocked in the database.

Some symptoms you may see:

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.
Executed:
update FIN_COST_PLAN_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 = ?

Cause

Since the introduction of SQL Curve a few defects are observed including this defect DE60813

Environment

Release : 15.9.1, 15.9.2 , 15.9.3 

Resolution

Fixed in upcoming release 16.0 as DE60813

  • SQL Curve feature has been optimized in 15.9.2 Patch 1 and recommended to apply and test
  • Post applying 15.9.2 Patch 1, if deadlocks continue on the Cost Plan, disable the SQL Curve Feature

Additional Information

Related Issues