Details
-
Bug
-
Resolution: Fixed
-
Highest
-
117
-
Minor
-
65
-
Description
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
- Copy page in the new editor
- 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.