Uploaded image for project: 'Jira Software Server and Data Center'
  1. Jira Software Server and Data Center
  2. JSWSERVER-12542

Balancing does not complete due to UPDATE AO_60DB71_LEXORANK exceeding acquireLockByRowIds timeout

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: High
    • Resolution: Duplicate
    • Affects Version/s: 6.7.7, 6.4.12, 7.2.1, 7.3.3
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      JIRA 6.3.12
      Large instance with more than 1M issues

      Description

      Summary

      Lexorank Balancing does not complete due to UPDATE AO_60DB71_LEXORANK exceeding acquireLockByRowIds timeout

      Steps to reproduce

      1. Go to Lexorank management in your instance. type g + g + lexorank management.
      2. On the balancing section, click on Balance all fields > wait for sometimes then click on Refresh

      Expected Result

      Lexorank balancing will be completed

      Actual Result

      1. Lexorank balancing does not complete
      2. Problem related to this SQL query performed by com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.save(...):
        UPDATE AO_60DB71_LEXORANK SET FIELD_ID = ?, ISSUE_ID = ?, RANK = ?, TYPE = ? WHERE ID = ? AND LOCK_HASH = ? AND LOCK_TIME = ? AND LOCK_TIME >= ?
      1. It cannot find any rows with such criteria specified in the WHERE clause ID = ? AND LOCK_HASH = ? AND LOCK_TIME = ? AND LOCK_TIME >= ?
        • LOCK_TIME = ? goes from acquired Lock performed by com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.acquireLockByRowIds(...):
          UPDATE AO_60DB71_LEXORANK SET LOCK_HASH = ?, LOCK_TIME = ? WHERE ID IN (?, ?) AND (LOCK_HASH IS NULL OR LOCK_TIME < ?)
        • LOCK_TIME >= ? is being calculated - System.currentTimeMillis() - 1500.

      Additional Information

      This would happen in large instance (with more than 1M issues)

      Potential Workaround

      As per JSWSERVER-15874, if currently using MySQL 5.6.x, upgrading MySQL to 5.7 might fix the problem

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              azuhra Aqqiela
              Votes:
              5 Vote for this issue
              Watchers:
              19 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: