Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-5505

System.Data.SqlClient.SqlException: Deadlock Issue during Transaction Process

    XMLWordPrintable

Details

    • 2
    • Severity 2 - Major
    • No

    Description

      Issue Summary

      Some customers have reported intermittent performance degradation in their JA instances across different pages and most notably in roadmaps.

      Steps to Reproduce

      1. No specific steps but the page would feel sluggish

      Expected Results

      Actual Results

      The below exception is thrown in the Splunk logs

         Exception: System.Data.SqlClient.SqlException (0x80131904): Transaction (Process ID 176) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
      

      Workaround

      A DB restart would temporarily clear the locks but eventually will build up again.

      Attachments

        Issue Links

          Activity

            People

              dfuller@atlassian.com Don Fuller
              lsoronio@atlassian.com Leo Soronio
              Votes:
              1 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Backbone Issue Sync