log_error.log 50 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530
  1. 2022-03-01 09:56:07.358 ERROR 2988 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler : nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'eartagParamVo.eartagNo != null'. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "eartagNo")
  2. org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'eartagParamVo.eartagNo != null'. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "eartagNo")
  3. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
  4. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
  5. at com.sun.proxy.$Proxy88.selectList(Unknown Source)
  6. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
  7. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:173)
  8. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)
  9. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  10. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  11. at com.sun.proxy.$Proxy99.listAllSell(Unknown Source)
  12. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  13. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  14. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  15. at java.lang.reflect.Method.invoke(Method.java:498)
  16. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  17. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  18. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  19. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  20. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  21. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
  22. at com.sun.proxy.$Proxy100.listAllSell(Unknown Source)
  23. at com.huimv.acquisition.service.impl.EartagDataServiceImpl.listAllSell(EartagDataServiceImpl.java:534)
  24. at com.huimv.acquisition.service.impl.EartagDataServiceImpl$$FastClassBySpringCGLIB$$fe20e69.invoke(<generated>)
  25. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  26. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
  27. at com.huimv.acquisition.service.impl.EartagDataServiceImpl$$EnhancerBySpringCGLIB$$e33ff0c8.listAllSell(<generated>)
  28. at com.huimv.acquisition.controller.EartagDataController.listAllSell(EartagDataController.java:168)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  30. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  31. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  32. at java.lang.reflect.Method.invoke(Method.java:498)
  33. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  34. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  35. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  36. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  37. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  38. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  39. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  40. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  41. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  42. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  43. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  44. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  45. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  46. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  47. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  48. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  49. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  50. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  51. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  52. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  53. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  54. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  55. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  56. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  57. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  58. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  59. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  60. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  61. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  62. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  63. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  64. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  65. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  66. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  67. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  68. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  69. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  70. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  71. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  72. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  73. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  74. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  75. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  76. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  77. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  78. at java.lang.Thread.run(Thread.java:748)
  79. Caused by: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'eartagParamVo.eartagNo != null'. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "eartagNo")
  80. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:48)
  81. at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
  82. at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
  83. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
  84. at java.util.ArrayList.forEach(ArrayList.java:1249)
  85. at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
  86. at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
  87. at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:305)
  88. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:69)
  89. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  90. at com.sun.proxy.$Proxy127.query(Unknown Source)
  91. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
  92. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  93. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  94. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  95. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  96. at java.lang.reflect.Method.invoke(Method.java:498)
  97. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
  98. ... 74 common frames omitted
  99. Caused by: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "eartagNo")
  100. at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:3331)
  101. at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:121)
  102. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  103. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  104. at org.apache.ibatis.ognl.ASTChain.getValueBody(ASTChain.java:141)
  105. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  106. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  107. at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:50)
  108. at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)
  109. at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)
  110. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:560)
  111. at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:524)
  112. at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46)
  113. ... 91 common frames omitted
  114. 2022-03-01 10:33:17.548 ERROR 17648 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler : Required request parameter 'pigpenId' for method parameter type Integer is present but converted to null
  115. org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'pigpenId' for method parameter type Integer is present but converted to null
  116. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueInternal(RequestParamMethodArgumentResolver.java:218)
  117. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueAfterConversion(RequestParamMethodArgumentResolver.java:200)
  118. at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:138)
  119. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)
  120. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
  121. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
  122. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  123. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  124. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  125. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  126. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  127. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  128. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  129. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  130. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  131. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  132. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  133. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  134. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  135. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  136. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  137. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  138. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  139. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  140. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  141. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  142. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  143. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  144. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  145. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  146. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  147. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  148. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  149. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  150. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  151. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  152. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  153. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  154. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  155. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  156. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  157. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  158. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  159. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  160. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  161. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  162. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  163. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  164. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  165. at java.lang.Thread.run(Thread.java:748)
  166. 2022-03-01 10:33:29.955 ERROR 17648 --- [http-nio-9501-exec-5] c.h.a.result.RRExceptionHandler : Required request parameter 'pigpenId' for method parameter type Integer is not present
  167. org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'pigpenId' for method parameter type Integer is not present
  168. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueInternal(RequestParamMethodArgumentResolver.java:218)
  169. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValue(RequestParamMethodArgumentResolver.java:193)
  170. at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:114)
  171. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)
  172. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
  173. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
  174. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  175. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  176. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  177. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  178. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  179. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  180. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  181. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  182. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  183. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  184. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  185. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  186. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  187. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  188. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  189. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  190. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  191. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  192. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  193. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  194. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  195. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  196. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  197. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  198. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  199. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  200. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  201. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  202. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  203. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  204. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  205. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  206. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  207. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  208. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  209. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  210. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  211. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  212. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  213. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  214. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  215. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  216. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  217. at java.lang.Thread.run(Thread.java:748)
  218. 2022-03-01 10:34:37.968 ERROR 2528 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler : Required request parameter 'pigpenId' for method parameter type String is not present
  219. org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'pigpenId' for method parameter type String is not present
  220. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueInternal(RequestParamMethodArgumentResolver.java:218)
  221. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValue(RequestParamMethodArgumentResolver.java:193)
  222. at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:114)
  223. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)
  224. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
  225. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
  226. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  227. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  228. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  229. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  230. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  231. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  232. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  233. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  234. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  235. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  236. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  237. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  238. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  239. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  240. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  241. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  242. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  243. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  244. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  245. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  246. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  247. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  248. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  249. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  250. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  251. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  252. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  253. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  254. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  255. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  256. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  257. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  258. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  259. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  260. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  261. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  262. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  263. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  264. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  265. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  266. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  267. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  268. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  269. at java.lang.Thread.run(Thread.java:748)
  270. 2022-03-01 10:36:32.060 ERROR 19288 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler : Required request parameter 'pigpenId' for method parameter type String is not present
  271. org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'pigpenId' for method parameter type String is not present
  272. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueInternal(RequestParamMethodArgumentResolver.java:218)
  273. at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValue(RequestParamMethodArgumentResolver.java:193)
  274. at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:114)
  275. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)
  276. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
  277. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
  278. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  279. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  280. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  281. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  282. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  283. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  284. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  285. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  286. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  287. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  288. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  289. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  290. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  291. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  292. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  293. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  294. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  295. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  296. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  297. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  298. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  299. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  300. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  301. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  302. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  303. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  304. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  305. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  306. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  307. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  308. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  309. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  310. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  311. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  312. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  313. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  314. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  315. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  316. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  317. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  318. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  319. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  320. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  321. at java.lang.Thread.run(Thread.java:748)
  322. 2022-03-01 10:39:21.003 ERROR 19504 --- [main] o.s.b.d.LoggingFailureAnalysisReporter :
  323. ***************************
  324. APPLICATION FAILED TO START
  325. ***************************
  326. Description:
  327. Web server failed to start. Port 9501 was already in use.
  328. Action:
  329. Identify and stop the process that's listening on port 9501 or configure this application to listen on another port.
  330. 2022-03-01 13:20:44.778 ERROR 17036 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler : Required request body is missing: public com.huimv.acquisition.result.R com.huimv.acquisition.controller.EartagDataController.listIndex(com.huimv.acquisition.entity.vo.EartagParamVo) throws java.text.ParseException
  331. org.springframework.http.converter.HttpMessageNotReadableException: Required request body is missing: public com.huimv.acquisition.result.R com.huimv.acquisition.controller.EartagDataController.listIndex(com.huimv.acquisition.entity.vo.EartagParamVo) throws java.text.ParseException
  332. at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.readWithMessageConverters(RequestResponseBodyMethodProcessor.java:163)
  333. at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.resolveArgument(RequestResponseBodyMethodProcessor.java:133)
  334. at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:121)
  335. at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
  336. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
  337. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  338. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  339. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  340. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  341. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  342. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  343. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  344. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  345. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  346. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  347. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  348. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  349. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  350. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  351. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  352. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  353. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  354. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  355. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  356. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  357. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  358. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  359. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  360. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  361. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  362. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  363. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  364. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  365. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  366. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  367. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  368. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  369. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  370. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  371. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  372. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  373. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  374. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  375. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  376. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  377. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  378. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  379. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  380. at java.lang.Thread.run(Thread.java:748)
  381. 2022-03-01 13:34:30.246 ERROR 7712 --- [http-nio-9501-exec-1] c.h.a.result.RRExceptionHandler :
  382. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  383. ### The error may exist in file [G:\idea\huimv\huimv.goldpig\huimv-goldpig\huimv-goldpig-anquisition\target\classes\mapper\acquisition\EartagDataDao.xml]
  384. ### The error may involve defaultParameterMap
  385. ### The error occurred while setting parameters
  386. ### SQL: SELECT COUNT(*) FROM (SELECT * FROM `eartag_data` SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_data` ed JOIN base_pigpen bp ON bp.id = ed.unit_id JOIN base_pigpen bp1 ON bp1.id = ed.pigpen WHERE id IN (SELECT MAX(id) FROM `eartag_data` WHERE eartag_no IN (SELECT eartag_no FROM `eartag_register` WHERE stage = 7 ) GROUP BY eartag_no)) TOTAL
  387. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  388. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  389. org.springframework.jdbc.BadSqlGrammarException:
  390. ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  391. ### The error may exist in file [G:\idea\huimv\huimv.goldpig\huimv-goldpig\huimv-goldpig-anquisition\target\classes\mapper\acquisition\EartagDataDao.xml]
  392. ### The error may involve defaultParameterMap
  393. ### The error occurred while setting parameters
  394. ### SQL: SELECT COUNT(*) FROM (SELECT * FROM `eartag_data` SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_data` ed JOIN base_pigpen bp ON bp.id = ed.unit_id JOIN base_pigpen bp1 ON bp1.id = ed.pigpen WHERE id IN (SELECT MAX(id) FROM `eartag_data` WHERE eartag_no IN (SELECT eartag_no FROM `eartag_register` WHERE stage = 7 ) GROUP BY eartag_no)) TOTAL
  395. ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  396. ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  397. at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
  398. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
  399. at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)
  400. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
  401. at com.sun.proxy.$Proxy88.selectList(Unknown Source)
  402. at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
  403. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:122)
  404. at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:86)
  405. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
  406. at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
  407. at com.sun.proxy.$Proxy99.listAllSell(Unknown Source)
  408. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  409. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  410. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  411. at java.lang.reflect.Method.invoke(Method.java:498)
  412. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  413. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  414. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  415. at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
  416. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  417. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
  418. at com.sun.proxy.$Proxy100.listAllSell(Unknown Source)
  419. at com.huimv.acquisition.service.impl.EartagDataServiceImpl.listAllSell(EartagDataServiceImpl.java:539)
  420. at com.huimv.acquisition.service.impl.EartagDataServiceImpl$$FastClassBySpringCGLIB$$fe20e69.invoke(<generated>)
  421. at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
  422. at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
  423. at com.huimv.acquisition.service.impl.EartagDataServiceImpl$$EnhancerBySpringCGLIB$$69d6f3d2.listAllSell(<generated>)
  424. at com.huimv.acquisition.controller.EartagDataController.listAllSell(EartagDataController.java:171)
  425. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  426. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  427. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  428. at java.lang.reflect.Method.invoke(Method.java:498)
  429. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
  430. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
  431. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
  432. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
  433. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
  434. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  435. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
  436. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
  437. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  438. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  439. at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)
  440. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  441. at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
  442. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
  443. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  444. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  445. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  446. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  447. at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
  448. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  449. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  450. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  451. at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
  452. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  453. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  454. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  455. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  456. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
  457. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
  458. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
  459. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
  460. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
  461. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
  462. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
  463. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  464. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
  465. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
  466. at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382)
  467. at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
  468. at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895)
  469. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732)
  470. at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  471. at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
  472. at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
  473. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  474. at java.lang.Thread.run(Thread.java:748)
  475. Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT ed.* , bp.pigpen_name unitName ,bp1.pigpen_name pigpenName FROM `eartag_d' at line 4
  476. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  477. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  478. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  479. at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
  480. at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
  481. at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
  482. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  483. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  484. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  485. at java.lang.reflect.Method.invoke(Method.java:498)
  486. at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
  487. at com.sun.proxy.$Proxy132.execute(Unknown Source)
  488. at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
  489. at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
  490. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  491. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  492. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  493. at java.lang.reflect.Method.invoke(Method.java:498)
  494. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
  495. at com.sun.proxy.$Proxy131.query(Unknown Source)
  496. at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:69)
  497. at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
  498. at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
  499. at com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor.willDoQuery(PaginationInnerInterceptor.java:141)
  500. at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:75)
  501. at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
  502. at com.sun.proxy.$Proxy130.query(Unknown Source)
  503. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
  504. at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
  505. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  506. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  507. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  508. at java.lang.reflect.Method.invoke(Method.java:498)
  509. at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
  510. ... 74 common frames omitted