• Type: Bug
    • Status: Resolved
    • Priority: Medium
    • Resolution: Support Request
    • Affects Version/s: 5.4.2
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      Apache Tomcat/6.0.26, jdk1.6.0_26


      We have the same error like described in this issue:

      The problem seems to occur to one specific user. That user can't be LDAP synchronised, can't login and you cannot open the User Detail information or the Group Detail information that user belongs got. We always get following exception:

      org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
      at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(
      at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(
      at org.springframework.orm.hibernate.HibernateTemplate.execute(
      at org.springframework.orm.hibernate.HibernateTemplate.execute(
      at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUser(
      at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByName(
      at com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByName(
      at com.atlassian.confluence.user.crowd.CachedCrowdUserDao$1.apply(
      at com.atlassian.confluence.user.crowd.CachedCrowdUserDao$1.apply(
      at com.atlassian.confluence.cache.option.OptionalReadThroughCache.get(
      at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findUser(
      at com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByName(
      at sun.reflect.GeneratedMethodAccessor263.invoke(Unknown Source)

      We are not able te remove the user from the system. When we exclude the user in den LDAP sync configuration, do a restart of the server, the user entry seems to disappear. But when we try to sync the user from LDAP again, the LDAP synchronisation fails with the above exception.

      How can we get rid off this "corrupted" user entry? Does that entry reside in the database or in a local cache file? How did this corrupted user entry even happen?

      Or: it is possible there are much more such users in our productive system with full LDAP directory. How to recognize those?


          Issue Links



              • Votes:
                0 Vote for this issue
                3 Start watching this issue


                • Created:
                  Last commented:
                  2 years, 5 weeks ago