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

Add database constraints to prevent duplicate content permission entries

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Low Low
    • 3.5.2
    • None
    • None
    • None

      Add a database constraint to prevent duplicate content permission entries (i.e. entries with the same user or group against the same content with the same permission level)

      An upgrade task is also needed that will clean up any existing duplicate entries and then add the constraint.

      Also need to ensure that XML imports from backups that contain duplicate permission entries report useful errors or are handled silently.

      Attached is a patch that adds the constraint but does not do any special handling for XML imports with duplicate permissions.

        1. Confluence_3_5_Permissions_Database_Constraint.patch
          36 kB

            [CONFSERVER-22123] Add database constraints to prevent duplicate content permission entries

            Niraj Bhawnani added a comment -

            The Ad Hoc Workflows plugin from Comalatech is known to cause this. In 3.5.2 and above it may fail to create a page (or possibly other actions) with a constraint violation.

            Niraj Bhawnani added a comment - The Ad Hoc Workflows plugin from Comalatech is known to cause this. In 3.5.2 and above it may fail to create a page (or possibly other actions) with a constraint violation.

            Niraj Bhawnani added a comment -

            XML imports with duplicates will still fail, except they will write a helpful message to the server log. The UI may not display the right exception message due to another exception masking the original exception, but does instruct the admin to have a look at the logs.

            Niraj Bhawnani added a comment - XML imports with duplicates will still fail, except they will write a helpful message to the server log. The UI may not display the right exception message due to another exception masking the original exception, but does instruct the admin to have a look at the logs.

              nbhawnani Niraj Bhawnani
              nbhawnani Niraj Bhawnani
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: