Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-3983

A large number of comments on an issue can cause delays when running a re-index

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Done
    • Affects Version/s: 5.6.7
    • Fix Version/s: 5.6.10
    • Component/s: Performance
    • Labels:
      None
    • Sprint:
      SR4J Sprint 68
    • Critical Points:
      3

      Description

      If you have issues with a very high number of comments it can hold the re-index up for a long time.

      For example, an issue with 26,000 comments may take 20 minutes to re-index that one issue and in the logs, it appears as though the re-index is stuck at a certain percentage.

      The problem appears to be related to us making to many calls to the database when we run the indexer so this bug is to track our optimization of this process so we do not hold up the re-index process.

       

      Steps to reproduce:

      1-Create an issue with a very large number of comments

      2-Try to run a re-index and track our last comment re-indexer calls to the database

       

        Attachments

          Activity

            People

            Assignee:
            merdmann Marcin Erdmann
            Reporter:
            mclark Matthew Clark
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: