Unable to import any space in confluence

Question

Following Error is coming whenever I am trying to import any confluence space

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'SK-atlassian.confluence.space.settings' for key 'bandana_unique_key'

I have attached the error logs & the zip file I am trying to import

Deividi Luvison · Answer

Hey Ankur,

That is indeed odd, could you please specify what you mean by any Confluence space?

From where the xml export comes from, another instance or is a space you exported and trying to reimport?

If it's from a different instance what are the confluence versions?

Thanks and Regards,David|Confluence Support Engineer

rrudnicki · Answer

Hi Ankur,

Please try to rebuild the index of Confluence. You can do it going to: 
Cog Icon -> General Configuration -> Content Indexing -> Rebuild.

Hope it helps,

Renato Rudnicki