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

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

      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.

            [CONFSERVER-5255] HibernateSystemException: "query did not return a unique result" when performing label/space operations

            mpanteleiev (Inactive) made changes -
            Link New: This issue is caused by CONFSERVER-75171 [ CONFSERVER-75171 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2898411 ] New: CONFSERVER Bug Workflow v4 [ 2993044 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2790706 ] New: JAC Bug Workflow v3 [ 2898411 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2720808 ] New: JAC Bug Workflow v2 [ 2790706 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2384238 ] New: JAC Bug Workflow [ 2720808 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2278729 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2384238 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2220201 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2278729 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2157427 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2220201 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1913110 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2157427 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1719780 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1913110 ]

              Unassigned Unassigned
              8d92d19feb5e Jeremy Higgs
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: