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

Identify the health state of Confluence ancestor CONFANCESTORS table

    XMLWordPrintable

Details

    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    Description

      NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.

      There are times that Confluence ancestor CONFANCESTORS table gets out of sync which could cause some bizarre issues.

      Currently, the only way to identify this is to wait until a user hit into the above issues or any unknown upcoming issue. This is very hard to catch. And currently, one would need to rebuild it manually.

      It'd be nice if the health state of CONFANCESTORS table can be identified from an accessible page in admin console or perhaps in the System Information (would be a huge win for Support).

      It'd be even nicer if Confluence would automatically rebuild the ancestor table once it's detected to be out of sync or corrupted.

      Resolution

      We've made some changes in 6.5.0 to detect if there is no parent ancestor record for a page. This change will block users from viewing pages with a missing parent ancestor record, and will log a warning for administrators.
      The steps to resolve this issue is still to rebuild the ancestors table as described in this KB https://confluence.atlassian.com/x/8qr-Nw

      Workaround

      Quoting from this KB - Unable to Move Pages with Attachments. This can be checked manually by running this SQL query:

      SELECT A.ANCESTORID, A.DESCENDENTID, COUNT(A.DESCENDENTID)
FROM CONFANCESTORS A, CONTENT B
WHERE B.CONTENTID = A.DESCENDENTID
GROUP BY A.ANCESTORID, A.DESCENDENTID
ORDER BY 3 DESC

      All returned rows should have value '1' for the column 'count'. If there is a value other than '1' (e.g. '2', '3', etc.), the CONFANCESTORS table is broken.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-34226 Detect loops when going through page tree structure

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-35040 Page move action causes database deadlock and data corruption

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-19753 Page.getAncestors() can sometime return duplicates

          • Medium - Medium priority issues
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-54945 CONFANCESTORS table obtains duplicate record after a page page re-order to space root

          • High - High priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-25189 Confluence Page View Restriction is not Inherited when Ancestor CONFANCESTORS Table Gets out of Sync

          • Medium - Medium priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-38939 Rebuilding ancestor table is slow and inefficient on large instances

          • Low - Low priority issues
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-53054 Confluence Questions causes certain functions to be very slow

          • Low - Low priority issues
          • Gathering Impact

          Suggestion - CONFCLOUD-25188 Identify the health state of Confluence ancestor CONFANCESTORS table and rebuild it automatically

          • Gathering Interest

          Suggestion - CONFSERVER-38795 Progress report for rebuilding the ancestor table

          • Gathering Interest
          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            People

              abarnes@atlassian.com Adam Barnes (Inactive)
              halatas HuseinA
              Votes:
              33 Vote for this issue
              Watchers:
              50 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: