Symptoms

When trying to edit or save a page, an error screen is shown and the page is not updated. The following appears in the atlassian-confluence.log:

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.

Resolution

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.