Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-13391

Issue creates hang due to LEXORANK table query locking up under stress of concurrent issue creates or updates

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • High
    • 7.2.0
    • 7.1.0, 7.0.10
    • None

    Description

      Database: Postgres 9.3.11

      Once query locks up, issue creates hang and we have to restart the JIRA instance.

      Query that is locked
      UPDATE public.AO_60DB71_LEXORANK" SET "LOCK_HASH" = $1, "LOCK_TIME" = $2 WHERE "ID" IN ($3, $4) AND ("LOCK_HASH" IS NULL OR "LOCK_TIME" < $5)

      The locked query/statement was determined by running this analysis query:

      SELECT pid, state,query FROM pg_stat_activity where datname='jira712' and state in ('active') and now() - query_start > '1m';

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. JSWSERVER-13756 Third-party apps that create multiple subtasks as part of workflow operations may trigger LexoRank deadlocks

          • High - High priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JSWSERVER-13756 Third-party apps that create multiple subtasks as part of workflow operations may trigger LexoRank deadlocks

          • High - High priority issues
          • Closed
          is related to

          ACJIRA-486 Loading...

          mentioned in

          Page Loading...

          Activity

            People

              Unassigned Unassigned
              bob.swift@charter.net Bob Swift OSS (Bob Swift Atlassian Apps)
              Votes:
              15 Vote for this issue
              Watchers:
              27 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: