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

Table locking when deleting from content

XMLWordPrintable

      We have had a couple of occurrences of tables getting locked and causing significant blocking. Our DBA opened a case with Oracle and they found that the problematic sql was "delete from CONTENT where CONTENTID=:1". They determined that there needed to be an index added to confancestors.ancestorid column or we will see this type of behavior. I found a comment in the Atlassian documentation about this exact issue and posted a reply there as well. http://confluence.atlassian.com/display/DOC/Confluence+Data+Model.

            [CONFSERVER-20654] Table locking when deleting from content

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2900668 ] New: CONFSERVER Bug Workflow v4 [ 2995409 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2796078 ] New: JAC Bug Workflow v3 [ 2900668 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2726228 ] New: JAC Bug Workflow v2 [ 2796078 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390260 ] New: JAC Bug Workflow [ 2726228 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2286492 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390260 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2226092 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2286492 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2180587 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2226092 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1947505 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2180587 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1742811 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1947505 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1703764 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1742811 ]

              Unassigned Unassigned
              c6e9bbe35156 Brian Cook
              Affected customers:
              0 This affects my team
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: