Issue Summary

Currently space delete operation of large spaces often causes deadlocks, and since it's not single transactional it leaves space data in inconsistent state. This needs to be fixed.

Steps to Reproduce

1. Import a space with large size eg. 40GB
2. Try to delete it from UI

Expected Results

It should be deleted without leaving anything in the database

Actual Results

Even after several hours 17-18, it gets failed with timeout

Workaround

Deletion from backend.