Our ldap server is unable to sync successfully until recently.
We get the following error:
2017-04-04 09:47:01,376 ERROR [Caesium-1-3] [atlassian.crowd.directory.DbCachingDirectoryPoller] pollChanges Error occurred while refreshing the cache for directory [ 10944516 ].
org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
How do we determine which is the duplicate ? Most of the dianostic queries we run returns no results :
SELECT lower_username FROM user_mapping GROUP BY lower_username HAVING (COUNT(lower_username) > 1)
SELECT external_id, lower_user_name FROM cwd_user GROUP BY external_id, lower_user_name HAVING ( COUNT(external_id) > 1)
I have resolved this. There was a duplicate user in the cwd_user table, which needed to be deleted. We also had to removed user from the cwd_mapping table.
You mean that there is a internal user in jira, and duplicated with the ldap sync, so you delete the internal user in jira, and everything become ok ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.