Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-34473

Deleted users still active on watcher's list for Confluence pages - show as an Unknown User and Cannot Be Deleted.

    XMLWordPrintable

Details

    Description

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? See the corresponding bug report.

      Also affects current version of Confluence in all Cloud instances.

      Steps to Reproduce in Self Hosted Confluence instances using LDAP:

      1. Add a LDAP user as a watcher to a page
      2. Remove the user from LDAP
      3. Sync the LDAP directory in Confluence
      4. View the page's Manage Watchers
      5. Try to remove the Unknown User
      6. Reload the page, and notice that the Unknown User still appears there:

      Workaround

      As a space administrator, remove the invalid user from the watchers list.

      If the user disappears and reappears then do:

      1. Find the user:
        select username from user_mapping where user_key in (select username from notifications where contentid = <YOURPAGEIDHERE>);
        

        PAGEID can be determined by clicking "Edit" on the page and grabbing the last number in the Browser URL.

      2. Get your user_key by selecting the user from previous query and searching with:
        select user_key from user_mapping where username = '<YOURUSERNAMEHERE>';
        
      3. Backup Database
      4. Delete all notifications for that user:
        delete from notifications where username = '<YOURUSERKEYHERE>';
        

        This will also fix the problem for any other pages not that has that deleted user as a watcher

      5. Flush Cache

      Attachments

        Issue Links

          Activity

            People

              skatta@atlassian.com Swati Katta
              fsim Foo Sim (Inactive)
              Votes:
              29 Vote for this issue
              Watchers:
              37 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: