Overview

When trying to delete a Space through the Admin Console, the delete task fails with the following error message:

"An error occurred during community deletion. Please check the logs for more information."

The logs contain the following error message:

2018-03-28 22:59:53,346 [TaskEngineWorker-pool-3] [::] ERROR com.jivesoftware.community.CommunityDeleteHelper - An error occurred while deleting community 2727
java.lang.Exception: There was a problem deleting communities as user 2000
at com.jivesoftware.community.CommunityDeleteHelper$CommunityDeleteRunnable.run(CommunityDeleteHelper.java:260)
at com.jivesoftware.util.task.TaskEngineRunnable.run(TaskEngineRunnable.java:51)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLException: Couldn't perform the operation rollback: You can't perform any operations on this connection. It has been automatically closed by Proxool for some reason (see logs).

Environment

Jive Cloud 2016.3.9.0

Reproduction Steps

1. Log in the Jive Admin Console (as an Administrator).
2. Go the Spaces tab and select the space that you want to delete.
3. Click on the Delete button and wait for the operation to end. If the issues exist, the Space is not deleted and the above-mentioned error is displayed.

Root Cause

The error indicates a connection issue. As the delete space operation is database intensive, the server may not have sufficient resources to execute the task and therefore closes the connection.

Resolution

Consider implementing one or both of the following options to avoid this issue:

• Delete the Spaces during non-business hours.
• Increase the database server resources.