Export space fails on duplicated key over OS_PROPERTYENTRY table

お困りですか?

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

コミュニティに質問

症状

Generating a XML backup, the following appears in the atlassian-confluence.log:

ERROR [confluence.importexport.impl.XmlExporter] backupEntities Couldn't backup database data.
.
.
.
org.springframework.orm.hibernate.HibernateSystemException: More than one row with the given identifier was found: bucket.user.propertyset.BucketPropertySetItem@ce6b3866, for class: bucket.user.propertyset.BucketPropertySetItem; nested exception is net.sf.hibernate.HibernateException: More than one row with the given identifier was found: bucket.user.propertyset.BucketPropertySetItem@ce6b3866, for class: bucket.user.propertyset.BucketPropertySetItem

診断

The following query will search for duplicate entries in the OS_PropertyEntry table.

This query is for MySQL. For other databases a tweak will be necessary.

select entity_name, entity_id, entity_key, count(*)
from os_propertyentry
group by entity_name, entity_id, entity_key
having count(*) > 1;

 

 

If this query returns any results then you are are affected.

原因

Duplicates in the OS_PROPERTYENTRY table.

ソリューション

Remove the duplicates found in the Diagnosis section from the database.
Last modified on Mar 30, 2016

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

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