Edit Page Fails with 'DataIntegrityViolationException Violation of PRIMARY KEY constraint'

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

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'
... 

原因

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.

ソリューション

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.

 

 

Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.