Copy page dialog throws ERROR: duplicate key value violates unique constraint

XMLWordPrintable

    • 117
    • Minor
    • 65

      Issue Summary

      Copying page results in duplicate key value violates unique constraint error, but works on another attempt 10-15 minutes later.

      Steps to Reproduce

      1. Copy page in the new editor
      2. Dialogue locks up

      This issue also affects the functionality of archiving pages.

      Expected Results

      Page copies successfully.

      Actual Results

      Copy page locks up, and the below exception is thrown:

      org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; sql=n/a; ERROR: duplicate key value violates unique constraint "xxxxxxx"
        Detail: Key (lock_id)=(task:com.atlassian.confluence.api.impl.service.longtasks.BulkPageCopyTaskRunner.ContentId{id=00000000}->ContentId{id=00000001}) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "xxxxxxx"
        Detail: Key (lock_id)=(task:com.atlassian.confluence.api.impl.service.longtasks.BulkPageCopyTaskRunner.ContentId{id=00000000}->ContentId{id=0000001}) already exists.
      

      Workaround

      On a subsequent attempt 10-15 minutes later, the page copies successfully.

            Assignee:
            Connor DeYoung
            Reporter:
            SMS (Inactive)
            Votes:
            48 Vote for this issue
            Watchers:
            77 Start watching this issue

              Created:
              Updated:
              Resolved: