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

XMLWordPrintable

    • Type: Bug
    • Resolution: Duplicate
    • Priority: High
    • 7.2.0
    • Affects Version/s: 7.0.10, 7.1.0
    • Component/s: None
    • 7
    • 8
    • Severity 1 - Critical
    • 23

      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';

              Assignee:
              Unassigned
              Reporter:
              Bob Swift
              Votes:
              15 Vote for this issue
              Watchers:
              27 Start watching this issue

                Created:
                Updated:
                Resolved: