Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-56554

Users are duplicated in the search results due to duplicated USERINFO records in the database

    XMLWordPrintable

Details

    Description

      Symptoms

      • Users appear twice in the search result
      • Users have two USERINFO records with no 'prevver' value (ie two current records), eg:
        select * from content where contenttype like 'USERINFO' and prevver is null;
        

        USERINFO records that do not have an entry in prevver are the currently active records. This is a little counter-intuitive given the name of the field, however older records that are no longer active contain the id of the superseding record in prevver. If prevver is null, the record is considered active.

      • If duplicated users appears anywhere else, refer to CONFSERVER-30050.

      Diagnosis - is this affecting you?

      First, try a content reindex, and a reindex from scratch. If this doesn't help, run this query (on any version). If it returns any results, this bug is the cause of your duplicates.

      SELECT c.username
            FROM CONTENT c
            WHERE
              contenttype LIKE 'USERINFO'
              AND prevver is null
                GROUP BY c.username
                HAVING count(c.username)>1;
      

      If this query returns nothing, have a look at CONF-36018 as well.

      Work Around

      Follow the Workaround provided in the CONFSERVER-30050

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mkhairuliana Monique Khairuliana (Inactive)
              Votes:
              6 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: