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

Arnaud BUTZBACH 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 July 2, 2022

MySQLIntegrityConstraintViolationException: Column 'USERNAME' cannot be null

Like 刘志涛 likes this
刘志涛 June 13, 2023

怎么解决  我也遇到了

Suggest an answer

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

Atlassian Community Events