We use Crowd as a user directory for Confluence. We have recently done quite a bit of work cleaning up groups in Crowd, as a lot of cruft had grown up over time.
While membership changes and new groups seem to be propagating correctly from Crowd to Confluence, group deletions and group name changes are not. The sync consistently reports success.
Changes are being correctly propagated to Jira and Bamboo.
I am at a loss on how to start diagnosing this, so any help would be welcome. We are using Crowd 2.6.4 and Confluence 4.3.3 (yes, I know, we need to update).
Edit: We have (finally) upgraded to Confluence 5.4.1 and we are still seeing this issue. I hesitate to try the proposed workaround until I have some reassurance that it's non-desctructive.
Thanks for the quick response! There's nothing in the log that looks like an error, and there is a call to deleteCachedGroupsNotIn. It is finding the correct number of groups on the Crowd server, but there are still considerably more in the local list in Confluence. Will disabling the Crowd directory and re-enabling it cause any problems with permissions and document ownership when the users and groups (temporarily) disappear?
I'd like to add that we're seeing this problem with JIRA as well but Tiago's suggested workaround does solve the problem. That said, it would be good if the problem didn't occur in the first place because typically the first time we know the problem has occurred is when it is affecting a user and that is not a good thing!
If you are using PostgreSQL backend this could be a workaround for making the sync work again.
begin; DELETE from cwd_membership where child_user_id in ( SELECT id from cwd_user where external_id IN ( SELECT external_id FROM cwd_user GROUP BY external_id, directory_id HAVING COUNT(*) > 1 ) ORDER BY external_id, ID LIMIT 1 ); DELETE from cwd_user where id in ( SELECT id from cwd_user where external_id IN ( SELECT external_id FROM cwd_user GROUP BY external_id, directory_id HAVING COUNT(*) > 1 ) ORDER BY external_id, ID LIMIT 1 ); commit;
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Community, Jessica here from the Confluence Product Marketing team! July’s community challenge is all about sharing pictures — and as an extension of our first post on what ...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs