Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.7.1
-
None
Description
If you have duplicate labels in your database for whatever reason, trying to remove them through the application comes up with this:
Cause: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 3 at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590) Stack Trace: [hide] org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 3 at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.confluence.labels.persistence.dao.hibernate.HibernateLabelDao.findLabellingByContentAndLabel(HibernateLabelDao.java:456) at com.atlassian.confluence.labels.DefaultLabelManager.internalRemove(DefaultLabelManager.java:144) at com.atlassian.confluence.labels.DefaultLabelManager.removeLabel(DefaultLabelManager.java:168)
Attachments
Issue Links
- relates to
-
CONFSERVER-10845 Additional database constraints to prevent erroneous duplication of the same row
- Closed