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: