Unable to delete Confluence space due to reference to notifications table

XMLWordPrintable

    • 22
    • Severity 3 - Minor
    • 1

      Summary

      When a delete space is triggered on the UI it will either get stuck at 0% or at another progress rate.

      You might see this error when reloading the page or triggering another delete:

      Expected Results

      Space should be deleted.

      Actual Results

      An exception like the one below prevents the delet, this can be found in the Confluence logs:

      2017-05-24 19:49:40.254835500 2017-05-24 19:49:40,253 ERROR [Caesium-1-5] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: update or delete on table "content" violates foreign key constraint "fk_notifications_content" on table "notifications"
      2017-05-24 19:49:40.254836500   Detail: Key (contentid)=(607978) is still referenced from table "notifications".
      

      Workaround

      Manually deleting the entry in the notifications table and then deleting the space.

        1. Delete.png
          Delete.png
          7 kB
        2. No long.png
          No long.png
          19 kB

            Assignee:
            Matthew Erickson
            Reporter:
            André K. (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            15 Start watching this issue

              Created:
              Updated:
              Resolved: