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

Improve performance when placing restrictions on pages that have a lot of child pages or attachments

    XMLWordPrintable

Details

    Description

      Description

      When adding or removing permissions from a page with many child pages, Confluence times out

      Steps to reproduce

      1. Find a page with a great number of child pages (100-1000+).
      2. Attempt to add restrictions to it.
      3. Watch the spinning wheel going for a long time (often +30s)
      4. Indexing queue <Confluence_URL>/admin/viewindexqueue.action, Time taken > ~51342ms

      Workaround

      Based on How to remove all restrictions from pages within a space to remove restrictions from just one page:

      Please test these scripts first in a development environment. You are responsible for confirming they are correct for your system

      1. Find the PageId of the page you want to remove permissions from by looking at the URL when editing it, or running the query (where <page title> is the title of the page). 
        select CONTENTID from CONTENT where contenttype = 'PAGE' and TITLE = '<page title>';
      2. Then you delete the parent page permissions by running (where <contentid> is the PageId). 
        delete from CONTENT_PERM WHERE CPS_ID IN (select ID from CONTENT_PERM_SET WHERE CONTENT_ID = <contentid>);

delete from CONTENT_PERM_SET WHERE CONTENT_ID = <contentid>;

      Attachments

        1. SystemLoad.png
          SystemLoad.png
          123 kB
        2. SystemMonitoring.png
          SystemMonitoring.png
          123 kB

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-37352 Page restrictions timeout

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-37353 Page restrictions timeout

          • Low - Low priority issues
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-17866 Restriction dialog is extremely slow to update, and provides no user feedback

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-39608 Page Restrictions action is too slow when a large number of group or user restriction on a page in a large space

          • Low - Low priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-43191 Children Display Macro slow due to poor permission check performance

          • Highest - Our top priority issues
          • Closed
          included in

          [JIRA] CPU-121 Confluence 6.0.0-OD-2015.49.1-0002

          [JIRA] CPU-139 Confluence 6.0.0-OD-2015.49.1-0003

          [JIRA] CPU-141 Confluence 6.0.0-OD-2015.50.1-0003

          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            People

              jmcarthur James McArthur (Inactive)
              gnedel Guilherme Nedel (Inactive)
              Votes:
              42 Vote for this issue
              Watchers:
              48 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: