Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-52148

Confluence site import failing with error related to duplicated users

XMLWordPrintable

      Summary

      Confluence site import fails. 

      Environment

      • Confluence 1000.1090.1

      Steps to Reproduce

      1. Perform a site import using a Confluence backup (Server or Cloud)

      Expected Results

      The import completes successfully.

      Actual Results

      Following error on logs:

      2017-03-15 17:12:46.639427500 2017-03-15 17:12:46,638 ERROR [Long running task: Importing data] [engine.jdbc.spi.SqlExceptionHelper] logExceptions ERROR: duplicate key value violates unique constraint "unq_lwr_username"
      2017-03-15 17:12:46.639429500   Detail: Key (lower_username)=(paula) already exists.
      
          	 msg:	 com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: org.hibernate.exception.ConstraintViolationException: could not execute statement	
      

      If we look for the user on the backup xml, there's only one entry for class="ConfluenceUserImpl".

      Notes

      Workaround

              kihlberg Klaus (Inactive)
              psilveira Paula Silveira (Inactive)
              Votes:
              3 Vote for this issue
              Watchers:
              19 Start watching this issue

                Created:
                Updated:
                Resolved: