IncorrectResultSizeDataAccessException when logging in

Question

When trying to login to Confluence with our admin account the following error is displayed:

Cause

org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2
    at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:590)

I have checked the cwd_users table and there are no duplicate usernames.

What else might I need to check to identify the root cause of this issue?

Shannon S · Answer

I'm happy to hear the SQL logging was able to help you resolve your issue!

Take care and Kind Regards,
Shannon

unknown · Answer

Thanks @Shannon S!

With SQL Logging enabled I was able to indentify that this query was returning two rows:

SELECT
 confluence0_.user_key as user_key, 
 confluence0_.username as username, 
 confluence0_.lower_username as lower_us3_ 
FROM
 user_mapping confluence0_ 
WHERE
 (confluence0_.lower_username='interconnekt');

I edited the values of username and lower_username on one of the rows, and the issue was resolved.

Shannon S · Answer

Hi there,

So this means that the duplicate row is in another table. For example, user_mapping could have a duplicate.

My recommendation to you would be to turn on SQL Logging and then you will be able to see which SQL statement is causing the error.

Let us know how it goes or if you have any follow-up questions.

Kind Regards,
Shannon