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

Increase in load time when accessing Blogpost

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 8.4.0, 7.19.10, 8.3.2
    • 8.2.0, 7.19.7, 7.19.8, 8.1.3, 8.2.1, 8.1.4, 8.2.2, 8.5.3
    • Content - Blogs

      Issue Summary

      The time taken to load Blogpost has increased.

      This is reproducible on Data Center: Yes

      Steps to Reproduce

      1. Install a Confluence version mentioned in the affected versions
      2. Create a space with a lot of blogpost(e.g. 100 blogpost)
      3. Navigate to a blogpost

      Expected Results

      The time to take load a blogpost is fast

      Actual Results

      The time taken to load a blogpost goes up to a minute or more depending on the environment

      Investigation

      The method PageManager.getBlogPosts() is executed several times. In the example below it was executed 96 times, and we can find 96 attempts in atlassian-confluence-sql.log

      2023-05-02 10:02:24,359 [http-nio-8090-exec-12] 
[7288.2ms] - /confluence/pages/viewpage.action
...
           [12.5ms] - SpaceManager.getLogoForSpace()
           [474.6ms] - PageManager.getYearsWithBlogPosts()
           [4497.9ms] [count: 96, avg: 46.9ms] - PageManager.getBlogPosts()

      The query was executed 96 times
      sql-query_2023-05-02T10_07_33.346Z.txt

      Observation

      As it executes an SQL query several times, over time this can slow down the overall performance of the application when multiple users are accessing

      Workaround

      There are currently no known workaround

        1. screenshot-3.png
          screenshot-3.png
          183 kB
        2. sql-query_2023-05-02T10_07_33.346Z.txt
          85 kB

          Form Name

            [CONFSERVER-83349] Increase in load time when accessing Blogpost

            James Whitehead added a comment -

            A fix for this issue is available in Confluence Server and Data Center 8.4.0.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            James Whitehead added a comment - A fix for this issue is available in Confluence Server and Data Center 8.4.0. Upgrade now or check out the Release Notes to see what other issues are resolved.

            Patrick Albrecht added a comment -

            Glad to hear that, this was preventing us from upgrading to the newest LTS version.

            Patrick Albrecht added a comment - Glad to hear that, this was preventing us from upgrading to the newest LTS version.

            Madhubabu Kethineni (Inactive) added a comment -

            A fix for this issue is available in Confluence Server and Data Center 8.3.2.
            Upgrade now or check out the Release Notes to see what other issues are resolved.

            Madhubabu Kethineni (Inactive) added a comment - A fix for this issue is available in Confluence Server and Data Center 8.3.2. Upgrade now or check out the Release Notes to see what other issues are resolved.

            ViktorS added a comment - - edited

            @Atlassian Support, given that the fix should be simple, is it possible to deliver it with the next minor version?

            ViktorS added a comment - - edited @Atlassian Support, given that the fix should be simple, is it possible to deliver it with the next minor version?

              ablekhman@atlassian.com Alex Blekhman (Inactive)
              c84ad05f80fa Puventhira Mannen
              Affected customers:
              8 This affects my team
              Watchers:
              18 Start watching this issue

                Created:
                Updated:
                Resolved: