-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Medium
-
Affects Version/s: 2.7.1
-
Component/s: None
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)
- relates to
-
CONFSERVER-10845 Additional database constraints to prevent erroneous duplication of the same row
- Closed