Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-15480

Assets reindexing performance regression on instance having multi-million object-ticket connections

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 10.1.1
    • 5.12.5, 5.4.21
    • Assets - Indexing

      Issue Summary

      On specific instances where there are more than million object-ticket connections (links between Assets objects and Jira custom fields), there is a general performance regression when reindexing Assets objects.

      This regression got introduced between JSM 4.20 and 5.12 versions.

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Establish an Assets instance that has tends of thousands Jira issues linked to many Assets objects.
      2. Run a clean Assets reindex / or restart Jira instance which will trigger Assets reindex.

      Expected Results

      Reindexing takes normal amount of time that it took on JSM 4.20.x.

      Actual Results

      Reindexing takes much more time, depending on the instance size (e.g. 2 hours or even more).

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

        1. 2024-07-30_11-49-31.png
          2024-07-30_11-49-31.png
          159 kB
        2. 2024-07-30_12-28-43.png
          2024-07-30_12-28-43.png
          78 kB
        3. 2024-07-31_13-26-31.png
          2024-07-31_13-26-31.png
          266 kB
        4. 2024-07-31_13-34-44.png
          2024-07-31_13-34-44.png
          129 kB

          Form Name

            [JSDSERVER-15480] Assets reindexing performance regression on instance having multi-million object-ticket connections

            Pavel Rabau made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 1027299 ]
            Pavel Rabau made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 1025752 ]
            Divyanshi made changes -
            Remote Link Original: This issue links to "Page (Confluence)" [ 960409 ]
            Marko Filipan made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 968399 ]
            Piotr Górecki made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 968467 ]
            Marc Dacanay made changes -
            Labels Original: lts10 ltsr New: lts10
            Tripta Kaur made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 960409 ]
            Satej Mirpagar made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Waiting for Release [ 12075 ] New: Closed [ 6 ]
            Anton Miniailo made changes -
            Fix Version/s Original: 10.1.0 [ 109015 ]
            Fix Version/s New: 10.1.1 [ 108913 ]
            SET Analytics Bot made changes -
            UIS Original: 41 New: 49

              bornatowski Bartosz Ornatowski
              mfilipan Marko Filipan
              Affected customers:
              2 This affects my team
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: