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

HibernateSystemException: "query did not return a unique result" when performing label/space operations

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Medium
    • 2.2
    • 2.1.2, 2.1.3
    • None

    Description

      This is a symptom of CONF-5254, when duplicate labels exist on the system. An error like this may appear:

      HibernateSystemException: query did not return a unique result: 2

      The following query can be used to identify the offending labels:

      select name, labelid from label group by name, labelid having count(name) > 1

      and any duplicate labels can then be removed from the LABEL table. Relationships in the CONTENT_LABEL table will have to be mapped to the remaining label ID.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              8d92d19feb5e Jeremy Higgs
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: