Symptoms

Followers and followees for a user are lost in the user's Network tab:

Attempting to add a user to Follow results in the error: "Already Following User"

Diagnosis

Try to How to Rebuild the Content Indexes From Scratch on Confluence Server . If that does not work, run the following queries in the Confluence Database:

SELECT * FROM follow_connections WHERE FOLLOWER = '<user_key>';

SELECT * FROM CONTENT WHERE CONTENTTYPE = 'USERINFO' AND LOWER(USERNAME) IN (SELECT LOWER(FOLLOWEE) FROM FOLLOW_CONNECTIONS WHERE FOLLOWER = 'TGDBIPA4');

If the first query returns the correct values for FOLLOWEE (who you are supposed to be following), and if the second query returns a USERINFO entry in the CONTENT table for the correct users, proceed to the next steps, else, request for all the users that are missing as a Followee to login to Confluence to create his/her USERINFO entry, then How to Rebuild the Content Indexes From Scratch on Confluence Server to resolve the issue

Cause

The users that do not appear there do not have the Can Use permission into Confluence via individual/group permissions in Confluence Admin >> Global Permissions

Resolution

• Either add a Can Use permission for any group that the user is member of, or add the permission individually for the user in Confluence Admin >> Global Permissions. See Global Permissions Overview