2022-05-27 10:30:52.356 [http-nio-8081-exec-5] DEBUG c.h.p.b.m.P.H.getFiveBusinessIncome - [debug,137] - ==> Preparing: SELECT t.track, SUM(corporate_income) corporateIncome FROM pb_income_develop t WHERE t.product_name = ‘ALL’ AND t.area
= ‘ALL’ AND t.professional_line
= ‘ALL’ AND t.country
= ‘ALL’ AND t.product_category
= ‘ALL’ GROUP BY t.track
2022-05-27 10:30:52.365 [http-nio-8081-exec-5] DEBUG c.h.p.b.m.P.H.getFiveBusinessIncome - [debug,137] - > Parameters:
2022-05-27 10:30:52.391 [http-nio-8081-exec-5] DEBUG c.h.p.b.m.P.H.getFiveBusinessIncome - [debug,137] - < Total: 4
2022-05-27 10:31:12.989 [http-nio-8081-exec-5] ERROR c.h.f.w.e.GlobalExceptionHandler - [handleRuntimeException,69] - 请求地址’/dev-api/pb/largeScreen/headerArea’,发生未知异常.
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
at org.mybatis.spring.SqlSessionTemplate
S
q
l
S
e
s
s
i
o
n
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
S
q
l
S
e
s
s
i
o
n
T
e
m
p
l
a
t
e
.
j
a
v
a
:
441
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441) at com.sun.proxy.
SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)atcom.sun.proxy.Proxy116.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:160)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
at org.apache.ibatis.binding.MapperProxy
P
l
a
i
n
M
e
t
h
o
d
I
n
v
o
k
e
r
.
i
n
v
o
k
e
(
M
a
p
p
e
r
P
r
o
x
y
.
j
a
v
a
:
145
)
a
t
o
r
g
.
a
p
a
c
h
e
.
i
b
a
t
i
s
.
b
i
n
d
i
n
g
.
M
a
p
p
e
r
P
r
o
x
y
.
i
n
v
o
k
e
(
M
a
p
p
e
r
P
r
o
x
y
.
j
a
v
a
:
86
)
a
t
c
o
m
.
s
u
n
.
p
r
o
x
y
.
PlainMethodInvoker.invoke(MapperProxy.java:145) at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86) at com.sun.proxy.
PlainMethodInvoker.invoke(MapperProxy.java:145)atorg.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)atcom.sun.proxy.Proxy201.getFiveBusinessIncome(Unknown Source)
at com.hollycrm.product.bscreen.service.impl.Product.HomeServiceImpl.getHeaderAreaIncome(HomeServiceImpl.java:53)
at com.hollycrm.product.bscreen.controller.largescreeninterface.LargeScreenInterfaceController.getHeaderAreaIncome(LargeScreenInterfaceController.java:148)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at com.hollycrm.common.filter.RepeatableFilter.doFilter(RepeatableFilter.java:39)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
327
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
a
c
c
e
s
s
.
i
n
t
e
r
c
e
p
t
.
F
i
l
t
e
r
S
e
c
u
r
i
t
y
I
n
t
e
r
c
e
p
t
o
r
.
i
n
v
o
k
e
(
F
i
l
t
e
r
S
e
c
u
r
i
t
y
I
n
t
e
r
c
e
p
t
o
r
.
j
a
v
a
:
115
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
a
c
c
e
s
s
.
i
n
t
e
r
c
e
p
t
.
F
i
l
t
e
r
S
e
c
u
r
i
t
y
I
n
t
e
r
c
e
p
t
o
r
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
S
e
c
u
r
i
t
y
I
n
t
e
r
c
e
p
t
o
r
.
j
a
v
a
:
81
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:327) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:327)atorg.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)atorg.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:121)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
s
e
s
s
i
o
n
.
S
e
s
s
i
o
n
M
a
n
a
g
e
m
e
n
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
S
e
s
s
i
o
n
M
a
n
a
g
e
m
e
n
t
F
i
l
t
e
r
.
j
a
v
a
:
126
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
s
e
s
s
i
o
n
.
S
e
s
s
i
o
n
M
a
n
a
g
e
m
e
n
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
S
e
s
s
i
o
n
M
a
n
a
g
e
m
e
n
t
F
i
l
t
e
r
.
j
a
v
a
:
81
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atorg.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)atorg.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
s
e
r
v
l
e
t
a
p
i
.
S
e
c
u
r
i
t
y
C
o
n
t
e
x
t
H
o
l
d
e
r
A
w
a
r
e
R
e
q
u
e
s
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
S
e
c
u
r
i
t
y
C
o
n
t
e
x
t
H
o
l
d
e
r
A
w
a
r
e
R
e
q
u
e
s
t
F
i
l
t
e
r
.
j
a
v
a
:
149
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atorg.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
c
o
m
.
h
o
l
l
y
c
r
m
.
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
f
i
l
t
e
r
.
J
w
t
A
u
t
h
e
n
t
i
c
a
t
i
o
n
T
o
k
e
n
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
I
n
t
e
r
n
a
l
(
J
w
t
A
u
t
h
e
n
t
i
c
a
t
i
o
n
T
o
k
e
n
F
i
l
t
e
r
.
j
a
v
a
:
42
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
w
e
b
.
f
i
l
t
e
r
.
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
j
a
v
a
:
117
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at com.hollycrm.framework.security.filter.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:42) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atcom.hollycrm.framework.security.filter.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:42)atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
a
u
t
h
e
n
t
i
c
a
t
i
o
n
.
l
o
g
o
u
t
.
L
o
g
o
u
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
L
o
g
o
u
t
F
i
l
t
e
r
.
j
a
v
a
:
103
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
a
u
t
h
e
n
t
i
c
a
t
i
o
n
.
l
o
g
o
u
t
.
L
o
g
o
u
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
L
o
g
o
u
t
F
i
l
t
e
r
.
j
a
v
a
:
89
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atorg.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)atorg.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
h
e
a
d
e
r
.
H
e
a
d
e
r
W
r
i
t
e
r
F
i
l
t
e
r
.
d
o
H
e
a
d
e
r
s
A
f
t
e
r
(
H
e
a
d
e
r
W
r
i
t
e
r
F
i
l
t
e
r
.
j
a
v
a
:
90
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
h
e
a
d
e
r
.
H
e
a
d
e
r
W
r
i
t
e
r
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
I
n
t
e
r
n
a
l
(
H
e
a
d
e
r
W
r
i
t
e
r
F
i
l
t
e
r
.
j
a
v
a
:
75
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
w
e
b
.
f
i
l
t
e
r
.
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
j
a
v
a
:
117
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90) at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atorg.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)atorg.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)
at org.springframework.security.web.FilterChainProxy
V
i
r
t
u
a
l
F
i
l
t
e
r
C
h
a
i
n
.
d
o
F
i
l
t
e
r
(
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
.
j
a
v
a
:
336
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
c
o
n
t
e
x
t
.
r
e
q
u
e
s
t
.
a
s
y
n
c
.
W
e
b
A
s
y
n
c
M
a
n
a
g
e
r
I
n
t
e
g
r
a
t
i
o
n
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
I
n
t
e
r
n
a
l
(
W
e
b
A
s
y
n
c
M
a
n
a
g
e
r
I
n
t
e
g
r
a
t
i
o
n
F
i
l
t
e
r
.
j
a
v
a
:
55
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
w
e
b
.
f
i
l
t
e
r
.
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
d
o
F
i
l
t
e
r
(
O
n
c
e
P
e
r
R
e
q
u
e
s
t
F
i
l
t
e
r
.
j
a
v
a
:
117
)
a
t
o
r
g
.
s
p
r
i
n
g
f
r
a
m
e
w
o
r
k
.
s
e
c
u
r
i
t
y
.
w
e
b
.
F
i
l
t
e
r
C
h
a
i
n
P
r
o
x
y
VirtualFilterChain.doFilter(FilterChainProxy.java:336) at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) at org.springframework.security.web.FilterChainProxy
VirtualFilterChain.doFilter(FilterChainProxy.java:336)atorg.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)atorg.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)atorg.springframework.security.web.FilterChainProxyVirtualFilterChain.doFilter(FilterChainProxy.java:336)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol
C
o
n
n
e
c
t
i
o
n
H
a
n
d
l
e
r
.
p
r
o
c
e
s
s
(
A
b
s
t
r
a
c
t
P
r
o
t
o
c
o
l
.
j
a
v
a
:
895
)
a
t
o
r
g
.
a
p
a
c
h
e
.
t
o
m
c
a
t
.
u
t
i
l
.
n
e
t
.
N
i
o
E
n
d
p
o
i
n
t
ConnectionHandler.process(AbstractProtocol.java:895) at org.apache.tomcat.util.net.NioEndpoint
ConnectionHandler.process(AbstractProtocol.java:895)atorg.apache.tomcat.util.net.NioEndpointSocketProcessor.doRun(NioEndpoint.java:1732)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor
W
o
r
k
e
r
.
r
u
n
(
T
h
r
e
a
d
P
o
o
l
E
x
e
c
u
t
o
r
.
j
a
v
a
:
659
)
a
t
o
r
g
.
a
p
a
c
h
e
.
t
o
m
c
a
t
.
u
t
i
l
.
t
h
r
e
a
d
s
.
T
a
s
k
T
h
r
e
a
d
Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread
Worker.run(ThreadPoolExecutor.java:659)atorg.apache.tomcat.util.threads.TaskThreadWrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
… 113 common frames omitted
2022-05-27 10:31:12.992 [http-nio-8081-exec-5] WARN o.s.w.s.m.m.a.ExceptionHandlerExceptionResolver - [logException,208] - Resolved [org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.TooManyResultsException: Expected one result (or null) to be returned by selectOne(), but found: 4]
原因:封装实体类的时候,实体类属性没有get和set方法!!!