result returns more than one elements

Spring Security多用户认证异常

最新推荐文章于 2021-11-26 18:20:27 发布

原创最新推荐文章于 2021-11-26 18:20:27 发布 · 662 阅读

0 ·

CC 4.0 BY-SA版权

zhch 专栏收录该内容

3 篇文章

订阅专栏

本文记录了一次在使用Spring Security进行用户认证时遇到的问题，当数据库中存在多个相同用户名的记录时，会导致认证失败，抛出InternalAuthenticationServiceException异常。文章详细描述了错误堆栈跟踪，指出问题在于DaoAuthenticationProvider尝试检索用户时返回了多于一个元素，进而引发了NonUniqueResultException。解决方案是清理数据库，确保每个用户名唯一。

019-04-22 15:19:28.102 [3a250759c278443fb8327bf1d176eba4] [http-nio-8088-exec-8] ERROR o.s.s.w.a.UsernamePasswordAuthenticationFilter - An internal error occurred while trying to authenticate the user.
org.springframework.security.authentication.InternalAuthenticationServiceException: result returns more than one elements; nested exception is javax.persistence.NonUniqueResultException: result returns more than one elements
   at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:126)
   at org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:143)
   at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:167)
   at org.springframework.security.authentication.ProviderManager.authenticate(ProviderManager.java:192)
   at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:93)
   at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:217)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
   at com.ichzh.wg4pmss.WebSecurityConfig$2.doFilter(WebSecurityConfig.java:133)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)
   at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:120)
   at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

数据库里添加了多个相同的admin用户把相同的删掉只留一个 OK