remove space faild

我的排查思路
1）结合日志排查报错原因atlassian-confluence.log

2）拆分删除动作，改为cli批量删除page，比如100000 page为一组，进行删除动作。

无论是页面、CLI、或者SQL，都要根据报错日志，去排查失败原因。

所谓条条大路通罗马，这条道不通，要搞清楚，为什么这条道不能走，以及换一条道对比当前的优势。

延伸阅读：

https://confluence.atlassian.com/confkb/delete-space-failed-error-when-trying-to-delete-a-space-within-confluence-785463377.html

https://bobswift.atlassian.net/wiki/spaces/CSOAP/pages/10584066/Examples#Examples-removePage

https://confluence.atlassian.com/confkb/after-a-failed-space-import-it-s-not-possible-to-re-import-because-of-leftover-space-data-217743668.html

 

SQL获取单个confluence space 所有page的方法：

SELECT C.title, C.contentid, CONCAT('[',C.title, '|http://yourwiki.com/pages/editpage.action?pageId=',C.contentid,']') AS ViewURL
FROM CONTENT C
INNER JOIN SPACES S ON S.spaceid = C.spaceid
WHERE S.spacekey = 'general' AND C.content_status = 'current' AND C.contenttype = 'PAGE'
ORDER BY C.title