Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-28591

DefaultOfBizListIterator reads the full result set into memory under Postgres and possibly other database implementations

    XMLWordPrintable

Details

    Description

      During a re-index all issues are read using the DefaultOfBizListIterator, because this is implemented outside a transaction PostgreSQL does not use a server side cursor and so reads the complete result set containing all issues into memory consuming excessive amounts of memory in the process.

      Other databases may behave similarly.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-11725 Exporting data from a JIRA instance with a lot records in the notificationinstance table causes an OutOfMemoryException

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. JRASERVER-28572 Jira re-indexing process appears to leak memory

          • Low - Low priority issues
          • Closed
          copied to

          JDEV-13116 Loading...

          Activity

            People

              edalgliesh Eric Dalgliesh
              tcampbell Trevor Campbell (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: