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

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

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

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

                Created:
                Updated:
                Resolved: