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

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