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

      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>;

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

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

                Created:
                Updated:
                Resolved: