Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Confluence site XML import failed due to duplicate entry '' for key unq_lwr_username

Arnaud BUTZBACH
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 14, 2021

After a disaster (physical server lost in flames), we attempted to restore our Confluence Server instance from an XML backup.
The import fails with a known error com.atlassian.confluence.importexport.ImportExportException: Unable to complete import because the data does not match the constraints in the Confluence schema. Cause: MySQLIntegrityConstraintViolationException: Duplicate entry '' for key 'unq_lwr_username'

There are available workaround when the entry is not null or when the original database is available (Ha Ha!).

We are running Confluence 6.13.8

The entities.xml file alone is 1.8GB and the import takes days. So that playing with the database while import is running is feasible.

Any help welcome !

1 answer

0 votes
Fabian Lim
Community Champion
December 24, 2021

Hi @Arnaud BUTZBACH

I found this KB article that will help other admins if they encounter the same issue: https://confluence.atlassian.com/confkb/confluence-site-xml-import-fails-with-duplicate-key-error-438993638.html

Regards

vajraboy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 2, 2022

MySQLIntegrityConstraintViolationException: Column 'USERNAME' cannot be null

Like 刘志涛 likes this
刘志涛
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 13, 2023

怎么解决  我也遇到了

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
6138
TAGS
AUG Leaders

Atlassian Community Events