Delete Space and Key from DB

Yogesh Mude_u145qk

Hi,

As I wanted to import a single space to a confluence server instance, whenever I tried to import it getting below error..

Import failed. Check your server logs for more information. com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: org.hibernate.exception.ConstraintViolationException: could not execute statement

So i tried to delete the space from DB, but I'm unable to do...

ERROR: update or delete on table "spaces" violates foreign key constraint "fklmweu06nft59g7mw1i1myorys" on table "content"
DETAIL: Key (spaceid)=(31391745) is still referenced from table "content".
********** Error **********

ERROR: update or delete on table "spaces" violates foreign key constraint "fklmweu06nft59g7mw1i1myorys" on table "content"
SQL state: 23503
Detail: Key (spaceid)=(31391745) is still referenced from table "content".

 

Steve Thornhill_57zt4f

Is the original space still active? If so, delete that through Confluence first.

Alternatively, if you are not too bothered by the actual Key on the import you can update this in the xml file before importing.

Deleting from the database should be avoided if possible due to the links between tables as you have seen.