Export space fails on duplicated key over OS_PROPERTYENTRY table
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
Generating a XML backup, the following appears in the atlassian-confluence.log:
1
2
3
4
5
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.
1
2
3
4
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.
Solution
Resolution
Remove the duplicates found in the
Diagnosis section
from the database.
Was this helpful?