error.2023-08-28.log 88 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957
  1. 10:11:45.476 [nioEventLoopGroup-5-4] ERROR io.netty.util.ResourceLeakDetector - LEAK: ByteBuf.release() was not called before it's garbage-collected. See https://netty.io/wiki/reference-counted-objects.html for more information.
  2. Recent access records:
  3. Created at:
  4. io.netty.buffer.PooledByteBufAllocator.newDirectBuffer(PooledByteBufAllocator.java:403)
  5. io.netty.buffer.AbstractByteBufAllocator.directBuffer(AbstractByteBufAllocator.java:188)
  6. io.netty.buffer.AbstractByteBufAllocator.directBuffer(AbstractByteBufAllocator.java:179)
  7. io.netty.buffer.AbstractByteBufAllocator.ioBuffer(AbstractByteBufAllocator.java:140)
  8. io.netty.channel.DefaultMaxMessagesRecvByteBufAllocator$MaxMessageHandle.allocate(DefaultMaxMessagesRecvByteBufAllocator.java:120)
  9. io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:150)
  10. io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:788)
  11. io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:724)
  12. io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:650)
  13. io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:562)
  14. io.netty.util.concurrent.SingleThreadEventExecutor$4.run(SingleThreadEventExecutor.java:997)
  15. io.netty.util.internal.ThreadExecutorMap$2.run(ThreadExecutorMap.java:74)
  16. io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)
  17. java.base/java.lang.Thread.run(Thread.java:833)
  18. 14:48:15.516 [MQTT Ping: iotbackgroundmgrlocal] ERROR o.e.p.c.mqttv3.internal.ClientState - iotbackgroundmgrlocal: Timed out as no write activity, keepAlive=20,000,000,000 lastOutboundActivity=38,840,219,457,000 lastInboundActivity=38,840,224,223,300 time=41,977,376,102,200 lastPing=38,840,219,458,600
  19. 17:41:08.827 [XNIO-1 task-2] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  20. org.mybatis.spring.MyBatisSystemException: null
  21. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  22. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  23. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  24. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  25. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  26. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  27. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  28. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  29. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  30. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  31. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  32. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  33. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  34. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  35. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  36. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  37. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  38. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  39. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  40. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  41. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  42. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  43. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  44. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  45. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  46. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  47. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  48. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  49. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  50. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  51. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  52. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  53. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  54. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  55. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  56. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  57. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  58. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  59. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  60. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  61. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  62. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  63. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  64. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  65. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  66. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  67. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  68. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  69. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  70. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  71. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  72. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  73. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  74. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  75. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  76. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  77. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  78. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  79. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  80. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  81. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  82. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  83. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  84. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  85. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  86. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  87. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  88. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  89. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  90. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  91. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  92. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  93. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  94. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  95. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  96. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  97. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  98. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  99. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  100. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  101. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  102. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  103. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  104. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  105. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  106. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  107. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  108. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  109. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  110. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  111. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  112. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  113. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  114. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  115. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  116. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  117. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  118. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  119. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  120. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  121. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  122. at java.base/java.lang.Thread.run(Thread.java:833)
  123. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  124. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  125. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  126. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  127. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  128. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  129. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  130. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  131. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  132. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  133. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  134. ... 100 common frames omitted
  135. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  136. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  137. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  138. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  139. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  140. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  141. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  142. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  143. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  144. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  145. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  146. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  147. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  148. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  149. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  150. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  151. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  152. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  153. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  154. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  155. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  156. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  157. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  158. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  159. ... 106 common frames omitted
  160. 17:41:08.840 [XNIO-1 task-5] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  161. org.mybatis.spring.MyBatisSystemException: null
  162. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  163. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  164. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  165. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  166. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  167. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  168. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  169. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  170. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  171. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  172. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  173. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  174. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  175. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  176. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  177. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  178. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  179. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  180. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  181. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  182. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  183. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  184. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  185. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  186. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  187. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  188. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  189. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  190. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  191. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  192. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  193. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  194. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  195. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  196. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  197. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  198. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  199. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  200. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  201. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  202. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  203. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  204. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  205. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  206. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  207. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  208. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  209. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  210. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  211. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  212. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  213. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  214. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  215. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  216. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  217. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  218. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  219. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  220. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  221. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  222. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  223. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  224. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  225. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  226. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  227. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  228. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  229. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  230. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  231. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  232. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  233. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  234. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  235. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  236. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  237. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  238. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  239. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  240. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  241. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  242. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  243. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  244. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  245. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  246. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  247. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  248. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  249. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  250. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  251. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  252. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  253. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  254. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  255. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  256. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  257. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  258. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  259. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  260. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  261. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  262. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  263. at java.base/java.lang.Thread.run(Thread.java:833)
  264. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  265. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  266. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  267. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  268. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  269. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  270. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  271. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  272. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  273. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  274. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  275. ... 100 common frames omitted
  276. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  277. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  278. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  279. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  280. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  281. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  282. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  283. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  284. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  285. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  286. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  287. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  288. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  289. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  290. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  291. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  292. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  293. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  294. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  295. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  296. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  297. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  298. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  299. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  300. ... 106 common frames omitted
  301. 17:44:47.210 [MQTT Ping: iotbackgroundmgrlocal] ERROR o.e.p.c.mqttv3.internal.ClientState - iotbackgroundmgrlocal: Timed out as no write activity, keepAlive=20,000,000,000 lastOutboundActivity=52,348,939,354,800 lastInboundActivity=52,350,675,063,000 time=52,569,070,013,500 lastPing=52,348,939,379,800
  302. 17:46:23.988 [XNIO-1 task-5] ERROR o.s.t.i.TransactionInterceptor - Application exception overridden by rollback exception
  303. org.mybatis.spring.MyBatisSystemException: null
  304. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  305. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  306. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  307. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  308. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  309. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  310. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  311. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  312. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  313. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  314. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  315. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  316. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  317. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  318. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  319. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  320. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  321. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  322. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  323. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  324. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  325. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  326. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  327. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  328. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  329. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  330. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  331. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  332. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  333. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  334. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  335. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  336. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  337. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  338. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  339. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  340. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  341. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  342. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  343. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  344. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  345. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  346. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  347. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  348. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  349. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  350. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  351. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  352. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  353. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  354. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  355. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  356. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  357. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  358. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  359. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  360. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  361. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  362. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  363. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  364. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  365. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  366. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  367. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  368. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  369. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  370. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  371. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  372. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  373. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  374. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  375. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  376. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  377. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  378. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  379. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  380. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  381. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  382. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  383. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  384. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  385. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  386. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  387. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  388. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  389. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  390. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  391. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  392. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  393. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  394. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  395. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  396. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  397. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  398. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  399. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  400. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  401. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  402. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  403. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  404. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  405. at java.base/java.lang.Thread.run(Thread.java:833)
  406. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  407. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  408. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  409. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  410. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  411. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  412. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  413. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  414. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  415. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  416. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  417. ... 100 common frames omitted
  418. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  419. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  420. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  421. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  422. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  423. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  424. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  425. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  426. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  427. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  428. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  429. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  430. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  431. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  432. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  433. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  434. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  435. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  436. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  437. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  438. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  439. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  440. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  441. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  442. ... 106 common frames omitted
  443. 17:46:23.989 [XNIO-1 task-5] ERROR c.z.x.c.e.GlobalExceptionHandler - JDBC rollback; Communications link failure during rollback(). Transaction resolution unknown.
  444. org.springframework.dao.DataAccessResourceFailureException: JDBC rollback; Communications link failure during rollback(). Transaction resolution unknown.
  445. at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:86)
  446. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  447. at org.springframework.jdbc.support.JdbcTransactionManager.translateException(JdbcTransactionManager.java:178)
  448. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:351)
  449. at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:835)
  450. at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:809)
  451. at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:677)
  452. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:394)
  453. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  454. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  455. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  456. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  457. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  458. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  459. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  460. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  461. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  462. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  463. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  464. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  465. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  466. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  467. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  468. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  469. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  470. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  471. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  472. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  473. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  474. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  475. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  476. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  477. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  478. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  479. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  480. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  481. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  482. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  483. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  484. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  485. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  486. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  487. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  488. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  489. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  490. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  491. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  492. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  493. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  494. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  495. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  496. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  497. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  498. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  499. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  500. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  501. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  502. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  503. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  504. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  505. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  506. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  507. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  508. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  509. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  510. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  511. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  512. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  513. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  514. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  515. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  516. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  517. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  518. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  519. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  520. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  521. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  522. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  523. at java.base/java.lang.Thread.run(Thread.java:833)
  524. Caused by: java.sql.SQLNonTransientConnectionException: Communications link failure during rollback(). Transaction resolution unknown.
  525. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
  526. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  527. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  528. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  529. at com.mysql.cj.jdbc.ConnectionImpl.rollback(ConnectionImpl.java:1833)
  530. at com.p6spy.engine.wrapper.ConnectionWrapper.rollback(ConnectionWrapper.java:182)
  531. at com.zaxxer.hikari.pool.ProxyConnection.rollback(ProxyConnection.java:385)
  532. at com.zaxxer.hikari.pool.HikariProxyConnection.rollback(HikariProxyConnection.java)
  533. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:348)
  534. ... 75 common frames omitted
  535. 17:47:41.211 [XNIO-1 task-5] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  536. org.mybatis.spring.MyBatisSystemException: null
  537. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  538. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  539. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  540. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  541. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  542. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  543. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  544. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  545. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  546. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  547. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  548. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  549. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  550. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  551. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  552. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  553. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  554. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  555. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  556. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  557. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  558. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  559. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  560. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  561. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  562. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  563. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  564. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  565. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  566. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  567. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  568. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  569. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  570. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  571. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  572. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  573. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  574. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  575. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  576. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  577. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  578. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  579. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  580. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  581. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  582. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  583. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  584. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  585. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  586. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  587. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  588. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  589. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  590. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  591. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  592. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  593. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  594. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  595. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  596. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  597. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  598. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  599. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  600. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  601. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  602. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  603. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  604. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  605. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  606. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  607. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  608. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  609. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  610. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  611. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  612. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  613. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  614. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  615. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  616. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  617. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  618. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  619. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  620. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  621. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  622. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  623. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  624. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  625. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  626. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  627. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  628. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  629. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  630. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  631. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  632. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  633. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  634. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  635. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  636. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  637. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  638. at java.base/java.lang.Thread.run(Thread.java:833)
  639. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  640. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  641. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  642. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  643. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  644. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  645. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  646. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  647. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  648. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  649. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  650. ... 100 common frames omitted
  651. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  652. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  653. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  654. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  655. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  656. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  657. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  658. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  659. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  660. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  661. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  662. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  663. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  664. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  665. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  666. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  667. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  668. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  669. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  670. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  671. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  672. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  673. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  674. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  675. ... 106 common frames omitted
  676. 17:50:46.941 [XNIO-1 task-4] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  677. org.mybatis.spring.MyBatisSystemException: null
  678. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  679. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  680. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  681. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  682. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  683. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  684. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  685. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  686. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  687. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  688. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  689. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  690. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  691. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  692. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  693. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  694. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  695. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  696. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  697. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  698. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  699. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  700. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  701. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  702. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  703. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  704. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  705. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  706. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  707. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  708. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  709. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  710. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  711. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  712. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  713. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  714. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  715. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  716. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  717. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  718. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  719. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  720. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  721. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  722. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  723. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  724. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  725. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  726. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  727. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  728. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  729. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  730. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  731. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  732. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  733. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  734. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  735. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  736. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  737. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  738. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  739. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  740. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  741. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  742. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  743. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  744. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  745. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  746. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  747. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  748. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  749. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  750. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  751. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  752. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  753. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  754. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  755. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  756. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  757. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  758. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  759. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  760. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  761. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  762. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  763. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  764. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  765. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  766. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  767. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  768. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  769. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  770. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  771. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  772. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  773. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  774. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  775. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  776. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  777. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  778. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  779. at java.base/java.lang.Thread.run(Thread.java:833)
  780. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  781. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  782. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  783. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  784. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  785. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  786. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  787. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  788. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  789. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  790. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  791. ... 100 common frames omitted
  792. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  793. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  794. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  795. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  796. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  797. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  798. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  799. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  800. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  801. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  802. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  803. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  804. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  805. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  806. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  807. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  808. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  809. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  810. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  811. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  812. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  813. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  814. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  815. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  816. ... 106 common frames omitted
  817. 17:51:09.110 [XNIO-1 task-4] ERROR c.z.x.c.e.GlobalExceptionHandler - null
  818. org.mybatis.spring.MyBatisSystemException: null
  819. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:97)
  820. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:439)
  821. at jdk.proxy2/jdk.proxy2.$Proxy110.selectList(Unknown Source)
  822. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
  823. at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
  824. at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
  825. at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
  826. at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
  827. at jdk.proxy3/jdk.proxy3.$Proxy390.getByList(Unknown Source)
  828. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  829. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  830. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  831. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  832. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  833. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  834. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  835. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  836. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  837. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:218)
  838. at jdk.proxy3/jdk.proxy3.$Proxy391.getByList(Unknown Source)
  839. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl.getBigScreenSensoralarmByList(GoafSensoralarmServiceImpl.java:68)
  840. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  841. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  842. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  843. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  844. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
  845. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
  846. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  847. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  848. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
  849. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:390)
  850. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
  851. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184)
  852. at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:750)
  853. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:702)
  854. at com.zhyc.xps.goaf.service.impl.GoafSensoralarmServiceImpl$$SpringCGLIB$$0.getBigScreenSensoralarmByList(<generated>)
  855. at com.zhyc.xps.goaf.controller.GoafSensoralarmController.getBigScreenSensoralarmByList(GoafSensoralarmController.java:56)
  856. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  857. at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
  858. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  859. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  860. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:207)
  861. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:152)
  862. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  863. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:884)
  864. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  865. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  866. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1081)
  867. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:974)
  868. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1011)
  869. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:903)
  870. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:527)
  871. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
  872. at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:614)
  873. at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
  874. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
  875. at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:172)
  876. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  877. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  878. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  879. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  880. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  881. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  882. at org.springframework.web.filter.ServerHttpObservationFilter.doFilterInternal(ServerHttpObservationFilter.java:109)
  883. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  884. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  885. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  886. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  887. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:116)
  888. at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67)
  889. at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
  890. at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
  891. at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
  892. at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
  893. at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
  894. at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
  895. at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
  896. at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
  897. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  898. at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
  899. at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
  900. at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
  901. at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
  902. at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
  903. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  904. at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
  905. at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
  906. at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
  907. at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:276)
  908. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
  909. at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:132)
  910. at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
  911. at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
  912. at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:256)
  913. at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:101)
  914. at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393)
  915. at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:859)
  916. at org.jboss.threads.ContextHandler$1.runWith(ContextHandler.java:18)
  917. at org.jboss.threads.EnhancedQueueExecutor$Task.run(EnhancedQueueExecutor.java:2513)
  918. at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1538)
  919. at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282)
  920. at java.base/java.lang.Thread.run(Thread.java:833)
  921. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  922. ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  923. ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  924. at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
  925. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153)
  926. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
  927. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  928. at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
  929. at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  930. at java.base/java.lang.reflect.Method.invoke(Method.java:568)
  931. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
  932. ... 100 common frames omitted
  933. Caused by: java.lang.IllegalArgumentException: invalid comparison: java.time.LocalDateTime and java.lang.String
  934. at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:98)
  935. at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:153)
  936. at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:814)
  937. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53)
  938. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  939. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  940. at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61)
  941. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  942. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  943. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:586)
  944. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:550)
  945. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  946. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  947. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  948. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  949. at java.base/java.util.ArrayList.forEach(ArrayList.java:1511)
  950. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  951. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  952. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  953. at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:119)
  954. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
  955. at jdk.proxy2/jdk.proxy2.$Proxy416.query(Unknown Source)
  956. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
  957. ... 106 common frames omitted