Confluence syncing ldap directory

Question

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 :

https://confluence.atlassian.com/confkb/synchronization-with-external-directory-fails-with-error-query-did-not-return-unique-result-757727378.html

SELECT lower_username FROM user_mapping GROUP BY lower_username HAVING (COUNT(lower_username) > 1)

https://confluence.atlassian.com/confkb/user-login-renders-query-did-not-return-a-unique-result-error-596181603.html

SELECT external_id, lower_user_name
FROM cwd_user
GROUP BY external_id, lower_user_name
HAVING ( COUNT(external_id) > 1)

Raphael_3e6qa0 · Answer

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 ?

DerivcoITServer · Answer

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.