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

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

      • 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

        1. atlassian-confluence.logs.tgz
          1.12 MB
          Christopher Fitch

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

                Created:
                Updated:
                Resolved: