Unable To Delete User with com.atlassian.confluence.spaces.Space.pageTemplates Exception
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
Try to do the instruction following articles before attempting the removal:
The personal space of the user is not properly removed from the database.
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