-
Bug
-
Resolution: Fixed
-
Medium (View bug fix roadmap)
-
6.4.5, 6.5.0, 6.6.0
-
None
-
6.04
-
Steps to reproduce:
- Install a new version of JAG in an environment where no JAG was installed before.
- Go to "Indexing" in JIRA.
- Run a full re-index or a background re-index
Expected behaviour: You should be informed that lexorank indexer is running and running a full re-index at the same time will slow the performance.
When a full re-index or background re-index runs immediately after installing JAG you are going to see how the time and performance of the app degrades because it takes twice the time to do everything.
2 threads are doing the same work at the same time.
Work around
If you want to migrate from JIRA Agile < 6.4 to JIRA Agile >= 6.4.5, and you want to avoid a background re-index being triggered by JIRA Agile's upgrade task GhUpgradeTask044, you can set the Java System Property upgrade.reindex.allowed to false.
Notes
This issue only tracks the scenario when the first population/migration of rank values is happening in JIRA Agile after installing JIRA Agile >= 6.4. We have tracked (and resolved) a separate issue around not letting balancing and foreground re-indexes happen at the same time (the re-index cancels any balancing jobs until it is done).
- is related to
-
JSWSERVER-12303 Lexorank index timeout when it is running in parallel with Issue indexing
-
- Closed
-
-
JDEV-34137 Failed to load
- mentioned in
-
Page Failed to load
-
Page Failed to load
-
Page Failed to load
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
- was cloned as
-
JDEV-33040 Loading...
-
SW-748 Loading...
ckhatchikian ibosticky based on the above support case alone, I would say our initial hypothesis that the problem is related to re-indexes running concurrently during upgrade is wrong. We should go back through all support cases linked to this issue and check to see if they previously had attempted an upgrade to JIRA Agile 6.4+ and then subsequently downgraded.
Also, the MSSQL-specific error message in the above support case is worrying and is seemingly unrelated to whether re-indexes are running concurrently. If "java.sql.DataTruncation: Data truncation" errors are being thrown frequently while attempting to generate rank initially values, then this would probably slow down re-indexing too, but it warrants its own investigation as to why the errors are being thrown in the first place.