Confluence syncing ldap directory

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)

 

 

 

1 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.

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 ?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 11, 2018 in Confluence

What are your project planning tips?

Hello Community,  Jessica here from the Confluence product marketing team! Today I wanted to get your takes on project planning –– what works, what doesn’t, how do you know if you’re doing it r...

296 views 1 4
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you