This documentation relates to an early version of Confluence.
View this page in the current documentation or visit the current documentation home.

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

All Versions
Click for all versions
Confluence 2.0 to 2.5 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

troubleshooting-faq troubleshooting-faq Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.