This documentation relates to the latest version of Confluence.
If you are using an earlier version, please go to the documentation home page and select the relevant previous version.

Edit page fails with 'DataIntegrityViolationException... Violation of PRIMARY KEY constraint'

Added by Mei Yan Chan, last edited by Sarah Maddox on Mar 12, 2008  (view change)
Confluence 2.8 Documentation

Index

Error

When trying to edit or save a page, an error screen is shown and the page is not updated.

org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; 
nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__CONTENT__5DCAEF64'. Cannot insert duplicate key in object 'CONTENT'
...

Cause

Confluence is deployed twice in the application server. The Confluence install should only be manually deployed via confluence.xml or server.xml. If the Confluence install directory is under an application server directory which is being auto-deployed, such as under the Tomcat webapps directory, Confluence will be deployed a second time.

Solution

The Confluence install directory referenced by confluence.xml or server.xml must be moved to a directory outside of the application server, so that is it no longer auto-deployed. See the instructions for installing the Confluence EAR WAR edition.

Labels