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

XMLWordPrintable

    • Type: Bug
    • Resolution: Support Request
    • Priority: Medium
    • None
    • Affects Version/s: 3.5.9
    • Component/s: None
    • Environment:

      • 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

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

              Created:
              Updated:
              Resolved: