Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-23244

3.5 documentation restore into new confluence install fails with ORA-00001: unique constraint (CONFLUENCE.SYS_C00298027) violated

    XMLWordPrintable

Details

    • Bug
    • Resolution: Support Request
    • Medium
    • None
    • 3.5.9
    • None

    Description

      • Install new confluence 3.5.9 with above env(confluence-3.5.9-std.tar.gz)
      • Setup initial admin user
      • Attempt to restore 3.5 Document XML zip (Confluence 3.5 Complete Documentation (XML) DOC-20110317.zip)
      • Import fails with:
      Importing Data
      Time Elapsed: 	6 minutes, 34 seconds
      Time Remaining: 	18 minutes, 43 seconds (estimated)
      Completion: 	26% complete
        	 
      Import failed. Check your server logs for more information. Hibernate operation: could not insert: [com.atlassian.confluence.links.ReferralLink#1317484]; SQL []; ORA-00001: unique constraint (CONFLUENCE.SYS_C00298027) violated ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CONFLUENCE.SYS_C00298027) violated
      

      Attachments are logs with full hibernate debug on as described here: https://team.eea.sk/wiki/display/DOC/Troubleshooting+XML+backups+that+fail+on+restore

      Attachments

        Activity

          People

            Unassigned Unassigned
            df0a7e8426c7 Christopher Fitch
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: