Export space fails on duplicated key over OS_PROPERTYENTRY table
Symptoms
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
Diagnosis
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.
Cause
Duplicates in the OS_PROPERTYENTRY table.
Resolution
Remove the duplicates found in the Diagnosis section from the database.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.