When you create a project from an archive from the UI, after having checked the archive, it create the project empty with the status 'CreatingFromArchive' (X in db). But if anything goes wrong after (especially an exception) the project will stay in this status forever and there is no way to delete it or retry import. And its shortname cannot be reused.