-
Bug
-
Resolution: Duplicate
-
High
-
None
-
6.7.7, 6.4.12, 7.2.1, 7.3.3
-
None
-
JIRA 6.3.12
Large instance with more than 1M issues
-
6.04
-
17
-
Severity 1 - Critical
-
15
-
Summary
Lexorank Balancing does not complete due to UPDATE AO_60DB71_LEXORANK exceeding acquireLockByRowIds timeout
Steps to reproduce
- Go to Lexorank management in your instance. type g + g + lexorank management.
- 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
- Lexorank balancing does not complete
- 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 >= ?
- 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 = ? goes from acquired Lock performed by com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.acquireLockByRowIds(...):
-
- 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
- duplicates
-
JSWSERVER-16542 During rebalancing ranking operation fails to save new rank due to slow DB operation
- Gathering Impact
- is caused by
-
JSWSERVER-13163 LexoRank database query performance is slow due to the way the field is constructed
- Closed
-
JSEV-121 Loading...
- is related to
-
JSWSERVER-15874 Issue ranking operation fails to save new rank due to slow DB operation in MySQL and MS-SQL
- Closed
-
JSWSERVER-16542 During rebalancing ranking operation fails to save new rank due to slow DB operation
- Gathering Impact
- was cloned as
-
JDEV-33787 Loading...