Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-13516

Cannot delete duplicate labels

    XMLWordPrintable

Details

    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

          Suggestion - CONFSERVER-10845 Additional database constraints to prevent erroneous duplication of the same row

          • Closed

          Activity

            People

              matt@atlassian.com Matt Ryall
              matt@atlassian.com Matt Ryall
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: