Unable to Delete Space

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

An error is thrown when deleting a space. Appearing in the logs is one of:

  • a constraint violation
  • a NullPointerException
  • a org.springframework.dao.DataIntegrityViolationException

Diagnosis

There is an invalid entry or foreign key relationship in the database. Inspect the stack trace you receive from the error. See below for the corresponding solution.

Causes and Resolutions


org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result

There are duplicate labels in the database. This issue is tracked in CONF-5254 - Getting issue details... STATUS .

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete com.atlassian.confluence.pages.templates.PageTemplate


This issue is tracked in CONF-19490 - Getting issue details... STATUS . It was resolved in Confluence 3.3. Please see the bug report for the workaround if you are on 3.3 or before.

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not delete com.atlassian.confluence.pages.Attachment

This issue is tracked in  CONF-19611 - Getting issue details... STATUS . It was resolved in Confluence 4.1.2. Please see the bug report for the workaround if you are on 4.1.2 or before.

Further Help

tip/resting Created with Sketch.

If you are unable to access the space at all from the UI, you can run the deletion from the URL directly at http://<baseURL>/spaces/removespace.action?key=<insert space key>. If that fails to work, refer to the documentation on Manually Deleting a Space.

Quick Workarounds

  1. Try to Purge the Space Trash first and then attempt to delete the Space again.
  2. From the application logs or UI, if you encounter an issue with a particular page which is causing issue during the Space Delete operation, try and move/copy the page to a different space and then attempt to delete the Space in question.

If you find you're still having problems, you may need to get a bit more information about what specifically is causing problems.

  1. If you can reproduce the problem on a test instance, use these steps there before trying this in production.
  2. Shut down Confluence
  3. Enable sql logging with parameters.
  4. Restart Confluence and attempt to delete the space, recreating the error.
  5. View the atlassian-confluence.log. You'll find the culprit space and the offending database row.
  6. If you have any questions about which rows to delete, create a support ticket and attach the detailed logs.

Last modified on Aug 3, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.