Space problem removal

[Deleted user]

Hello,

We have a space called developement that is empty but we cannot delete it :

I did try to use the following script but with no success :

https://confluence.atlassian.com/display/CONFKB/How+to+Manually+Delete+a+Space

[root@syn-ops01 ~]# mysql -u root -p confluence < space.sql

Enter password:

spaceid

22642695

ERROR 1451 (23000) at line 367: Cannot delete or update a parent row: a foreign key constraint fails (`confluence`.`CONTENT`, CONSTRAINT `FK6382C059B2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`))

[root@syn-ops01 ~]#

As you can see it was a failure to delete the space called developement.

Finally when I'm trying to delete it manually, same result, the removal is failling :

mysql> SELECT SPACEID FROM SPACES WHERE SPACEKEY = "Development";

+----------+

| SPACEID |

+----------+

| 22642695 |

+----------+

1 row in set (0.00 sec)

mysql> DELETE FROM SPACE WHERE SPACEID ="22642695" ;

ERROR 1146 (42S02): Table 'confluence.SPACE' doesn't exist

mysql> DELETE FROM SPACES WHERE SPACEID ="22642695" ;

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`confluence`.`CONTENT`, CONSTRAINT `FK6382C059B2DC6081` FOREIGN KEY (`SPACEID`) REFERENCES `SPACES` (`SPACEID`))

mysql>

Please can you provide us a clean way to delete the unused space we have ?

Regards

Martial NDEKO-FOLLIGAN

CloudOps

[hsuhailah]

It seems that the issue you're encountering is related to this issue we have documented before: https://confluence.atlassian.com/display/CONFKB/Unable+to+Remove+Personal+Space+Due+to+Foreign+Key+Constraint

Let's give it a check and see if the resolution helps. Please backup the server before making any changes.