A space deletion hung and I cannot clear up space

[Bob Solimine]

I downgraded our Confluence from paid to free a while back. After reverting to the free account, I was over the size limit. After careful backup, I started deleting older spaces. I initiated a delete for one space at about 3.1 GB and waited almost an hour, but the progress stalled. Ever since, I am still over my space quota and can't figure out a way to clear it up. I tried a manual delete via URL (/spaces/removespace.action?key=myspacekey) but the page was not found. Without access to Atlassian support, is there anything I can do?

[Betsy Walker {Appfire} · Accepted solution]

You would need to join the content table on the spaces table, based on the spaceid in both columns, something like this:

SELECT title, contentid 
FROM content 
WHERE spaceid = 
    (SELECT spaceid FROM spaces WHERE spacekey = 'yourspacename') 
ORDER BY 1;

or

SELECT C.title, C.contentid
FROM content C
INNER JOIN spaces S ON C.spaceid = S.spaceid
ORDER BY title;