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

            BillA added a comment -

            Thank you for raising this issue. As this issues is minor and we have no plans to implement it in the foreseeable future, we are closing it in order to set expectations.

            BillA added a comment - Thank you for raising this issue. As this issues is minor and we have no plans to implement it in the foreseeable future, we are closing it in order to set expectations.

            Joe Clark added a comment -

            Hi Brian,

            Thanks for reporting this issue; it will be triaged and prioritised in accordance with our Bug Fixing Policy.

            Cheers!
            Joe.

            Joe Clark added a comment - Hi Brian, Thanks for reporting this issue; it will be triaged and prioritised in accordance with our Bug Fixing Policy . Cheers! Joe.

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

                Created:
                Updated:
                Resolved: