Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-14422

All attachments versions loaded when you query for just one

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 3.0
    • None
    • None
    • EAC
      postgres linux confluence 3.0_m4

    Description

      There is a page on Extranet with four attachments, each of which has 5000+ versions. Whenever one of these attachments appears in the recently updated list – which is about every 10 minutes – all 5000 versions are retrieved from the database.

      If the attachment cache were bigger (it defaults to 10000), then the cache would keep this attachment metadata in it. But as it stands, the cache can't hold all the data, so anyone visiting the dashboard will retrieve up to 20000 rows from the attachments table in the database.

      A thread dump from EAC running with a cache of 10000 is attached, and shows a lot of activity in the attachment retrieval code.

      Attachments

        Activity

          People

            matt@atlassian.com Matt Ryall
            don.willis@atlassian.com Don Willis
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: