Unable To Delete User with com.atlassian.confluence.spaces.Space.pageTemplates Exception
Symptoms
Unable to remove specific user even though all content related to this user has already been removed.
The following appears in the atlassian-confluence.log: (PostgreSQL database)
2014-03-14 09:06:42,802 ERROR [http-8090-4] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- referer: http://localhost:8090/admin/users/removeuser.action?username=test| url: /admin/users/removeuser-confirm.action | userName: test
com.atlassian.core.exception.InfrastructureException: net.sf.hibernate.LazyInitializationException: Failed to lazily initialize a collection
...
Caused by: net.sf.hibernate.LazyInitializationException: Failed to lazily initialize a collection
...
Caused by: net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.atlassian.confluence.spaces.Space.pageTemplates#1933313]
...
Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
Diagnosis
Try to do the instruction following articles before attempting the removal:
Cause
The personal space of the user is not properly removed from the database.
Resolution
Run the following query to find the problematic row:
select * from spaces where substr(spacekey,2) = 'username';Follow the instruction from the article 'How to Manually Delete a Space' to remove the problematic personal space
- Restart Confluence and click on 'Flush All' in
Confluence Admin >> Cache Statisticsscreen Remove the user from Confluence Administration panel
Last modified on Nov 15, 2018
Powered by Confluence and Scroll Viewport.