|
2024-11-23 00:38:19 [http-nio-9527-exec-120] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092880552
|
|
2024-11-23 00:39:22 [http-nio-9527-exec-127] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092880552
|
|
2024-11-23 00:55:20 [http-nio-9527-exec-112] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092853102
|
|
2024-11-23 01:01:03 [http-nio-9527-exec-122] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092809214
|
|
2024-11-23 02:19:07 [http-nio-9527-exec-112] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092802720
|
|
2024-11-23 02:54:27 [http-nio-9527-exec-105] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092861738
|
|
2024-11-23 02:55:21 [http-nio-9527-exec-121] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092861738
|
|
2024-11-23 03:27:36 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092805914
|
|
2024-11-23 03:36:23 [http-nio-9527-exec-112] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092824065
|
|
2024-11-23 04:40:20 [http-nio-9527-exec-121] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092879414
|
|
2024-11-23 06:21:22 [http-nio-9527-exec-117] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092808811
|
|
2024-11-23 06:21:41 [http-nio-9527-exec-125] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092808811
|
|
2024-11-23 06:22:14 [http-nio-9527-exec-117] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092808811
|
|
2024-11-23 06:48:43 [http-nio-9527-exec-127] ERROR org.example.controller.MesController - 物料: 2327.11065.031没有维护对应的存储仓库，请联系相关人员维护后重新发送！
|
|
2024-11-23 06:53:25 [http-nio-9527-exec-127] ERROR org.example.controller.MesController - 物料: 2327.11065.031没有维护对应的存储仓库，请联系相关人员维护后重新发送！
|
|
2024-11-23 07:07:11 [http-nio-9527-exec-120] ERROR org.example.controller.MesController - 物料: 2327.11065.031没有维护对应的存储仓库，请联系相关人员维护后重新发送！
|
|
2024-11-23 07:08:09 [http-nio-9527-exec-112] ERROR org.example.controller.MesController - 物料: 2327.11065.031没有维护对应的存储仓库，请联系相关人员维护后重新发送！
|
|
2024-11-23 07:08:13 [http-nio-9527-exec-120] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092807992
|
|
2024-11-23 07:17:04 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 物料: 2327.11065.031没有维护对应的存储仓库，请联系相关人员维护后重新发送！
|
|
2024-11-23 07:26:16 [http-nio-9527-exec-112] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092807992
|
|
2024-11-23 07:26:31 [http-nio-9527-exec-105] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092807992
|
|
2024-11-23 07:41:49 [http-nio-9527-exec-127] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.jdbc.BadSqlGrammarException:
|
|
### 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
### The error may exist in URL [jar:file:/home/warehouse/warehouse-1.0-SNAPSHOT.jar!/mappers/ReportMapper.xml]
|
|
### The error may involve defaultParameterMap
|
|
### The error occurred while setting parameters
|
|
### SQL: SELECT bmb.id,SUM(bmb.number) AS `count`,bind.*,m.*, FROM bind_material_box AS bmb LEFT JOIN ( SELECT id,`code` AS materialCode,`name` AS materialName,`specs`,`unit` FROM material HAVING id ) AS m ON m.id = bmb.material_id LEFT JOIN ( SELECT bsb.box_id AS boxId,bsb.`status`,w.`code` AS warehouseCode,w.`name` AS warehouseName FROM bind_shelf_box AS bsb LEFT JOIN shelf_box AS sb ON sb.id = bsb.shelf_box_id LEFT JOIN shelf AS s ON s.id = sb.shelf_id LEFT JOIN area AS a ON a.id = s.area_id LEFT JOIN warehouse AS w ON w.id = a.warehouse_id HAVING boxId ) AS bind ON bind.boxId = bmb.box_id WHERE bind.`status` IN (1,2) GROUP BY bmb.material_id,bind.warehouseCode HAVING bmb.`id` LIMIT ?, ?
|
|
### 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
; 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.selectList(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy74.searchInventoryAge(Unknown Source)
|
|
at org.example.service.impl.ReportServiceImpl.inventoryAgePage(ReportServiceImpl.java:188)
|
|
at org.example.service.impl.ReportServiceImpl$$FastClassBySpringCGLIB$$56dfcada.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
|
|
at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
|
|
at org.example.service.impl.ReportServiceImpl$$EnhancerBySpringCGLIB$$c9f07d.inventoryAgePage(<generated>)
|
|
at org.example.controller.ReportController.inventorySecurityPage(ReportController.java:136)
|
|
at sun.reflect.GeneratedMethodAccessor2024.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 71 common frames omitted
|
|
2024-11-23 07:50:47 [http-nio-9527-exec-117] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.jdbc.BadSqlGrammarException:
|
|
### 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
### The error may exist in URL [jar:file:/home/warehouse/warehouse-1.0-SNAPSHOT.jar!/mappers/ReportMapper.xml]
|
|
### The error may involve defaultParameterMap
|
|
### The error occurred while setting parameters
|
|
### SQL: SELECT bmb.id,SUM(bmb.number) AS `count`,bind.*,m.*, FROM bind_material_box AS bmb LEFT JOIN ( SELECT id,`code` AS materialCode,`name` AS materialName,`specs`,`unit` FROM material HAVING id ) AS m ON m.id = bmb.material_id LEFT JOIN ( SELECT bsb.box_id AS boxId,bsb.`status`,w.`code` AS warehouseCode,w.`name` AS warehouseName FROM bind_shelf_box AS bsb LEFT JOIN shelf_box AS sb ON sb.id = bsb.shelf_box_id LEFT JOIN shelf AS s ON s.id = sb.shelf_id LEFT JOIN area AS a ON a.id = s.area_id LEFT JOIN warehouse AS w ON w.id = a.warehouse_id HAVING boxId ) AS bind ON bind.boxId = bmb.box_id WHERE bind.`status` IN (1,2) GROUP BY bmb.material_id,bind.warehouseCode HAVING bmb.`id` LIMIT ?, ?
|
|
### 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
; 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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.selectList(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
|
|
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:147)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:80)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy74.searchInventoryAge(Unknown Source)
|
|
at org.example.service.impl.ReportServiceImpl.inventoryAgePage(ReportServiceImpl.java:188)
|
|
at org.example.service.impl.ReportServiceImpl$$FastClassBySpringCGLIB$$56dfcada.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
|
|
at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
|
|
at org.example.service.impl.ReportServiceImpl$$EnhancerBySpringCGLIB$$c9f07d.inventoryAgePage(<generated>)
|
|
at org.example.controller.ReportController.inventorySecurityPage(ReportController.java:136)
|
|
at sun.reflect.GeneratedMethodAccessor2024.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
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 'FROM bind_material_box AS bmb
|
|
LEFT JOIN (
|
|
SELECT id,`code` AS ma' at line 3
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
|
|
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
|
|
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
|
|
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
|
|
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 71 common frames omitted
|
|
2024-11-23 07:52:56 [http-nio-9527-exec-122] ERROR org.example.controller.MesController - 根据仓库：101030，库区：3F拆箱区(缓存区),货架：3F外协货架-拆箱区7线查找第二层接驳位失败
|
|
2024-11-23 08:05:22 [http-nio-9527-exec-105] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53554' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:05:31 [http-nio-9527-exec-121] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53554' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53554' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:19:03 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:19:39 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:19:51 [http-nio-9527-exec-127] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:21:44 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:23:27 [http-nio-9527-exec-112] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:23:43 [http-nio-9527-exec-120] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:24:08 [http-nio-9527-exec-120] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:24:12 [http-nio-9527-exec-121] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:24:59 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:25:29 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:25:33 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:25:44 [http-nio-9527-exec-128] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:25:59 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:26:25 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:26:37 [http-nio-9527-exec-105] ERROR org.example.controller.MesController - 根据仓库：101030，库区：3F拆箱区(缓存区),货架：3F外协货架-拆箱区10线查找第二层接驳位失败
|
|
2024-11-23 08:26:38 [http-nio-9527-exec-120] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:26:59 [http-nio-9527-exec-121] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:27:29 [http-nio-9527-exec-120] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:28:08 [http-nio-9527-exec-117] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:28:32 [http-nio-9527-exec-121] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:29:03 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:29:41 [http-nio-9527-exec-117] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:30:06 [http-nio-9527-exec-127] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:31:40 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:36:03 [http-nio-9527-exec-127] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53491' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:36:15 [http-nio-9527-exec-127] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53491' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53491' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:37:31 [http-nio-9527-exec-128] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53551' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:41:56 [http-nio-9527-exec-127] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:42:29 [http-nio-9527-exec-128] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:43:23 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:45:06 [http-nio-9527-exec-127] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:47:10 [http-nio-9527-exec-127] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:47:32 [http-nio-9527-exec-105] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53551' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:48:00 [http-nio-9527-exec-128] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:48:09 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:48:55 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:50:15 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:51:01 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:52:43 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:53:36 [http-nio-9527-exec-117] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53551' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53551' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 08:54:39 [http-nio-9527-exec-125] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:55:04 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:58:32 [http-nio-9527-exec-122] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 08:58:38 [http-nio-9527-exec-122] ERROR o.example.controller.BaseController - 系统未知错误
|
|
java.lang.NullPointerException: null
|
|
at org.example.service.impl.SplitServiceImpl.checkParam(SplitServiceImpl.java:848)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:741)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
2024-11-23 09:05:35 [http-nio-9527-exec-105] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 09:19:11 [http-nio-9527-exec-121] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53560' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 09:20:03 [http-nio-9527-exec-113] ERROR o.example.controller.BaseController - 系统未知错误
|
|
org.springframework.dao.DuplicateKeyException:
|
|
### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
### The error may exist in org/example/dao/BindShelfBoxDAO.java (best guess)
|
|
### The error may involve org.example.dao.BindShelfBoxDAO.insert-Inline
|
|
### The error occurred while setting parameters
|
|
### SQL: INSERT INTO bind_shelf_box (box_id,shelf_box_id,`status`,`time`) VALUE (?,?,?,?)
|
|
### Cause: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
; Duplicate entry '53560' for key 'shelf_box_id_2'; nested exception is java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:247)
|
|
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
|
|
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
|
|
at com.sun.proxy.$Proxy66.insert(Unknown Source)
|
|
at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
|
|
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
|
|
at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
|
|
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
|
|
at com.sun.proxy.$Proxy76.insert(Unknown Source)
|
|
at org.example.service.impl.SplitServiceImpl.increaseInventory(SplitServiceImpl.java:857)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:788)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '53560' for key 'shelf_box_id_2'
|
|
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)
|
|
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
|
|
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
|
|
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
|
|
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
|
|
at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
|
|
at com.sun.proxy.$Proxy106.execute(Unknown Source)
|
|
at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
|
|
at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
|
|
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
|
|
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
|
|
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
|
|
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
|
|
at sun.reflect.GeneratedMethodAccessor169.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
|
|
... 77 common frames omitted
|
|
2024-11-23 09:26:37 [http-nio-9527-exec-120] ERROR org.example.controller.MesController - 库存数据不足，无任务创建！
|
|
2024-11-23 11:00:01 [http-nio-9527-exec-125] ERROR org.example.controller.MesController - 根据仓库：101030，库区：3F拆箱区(缓存区),货架：3F外协货架-拆箱区10线查找第二层接驳位失败
|
|
2024-11-23 11:09:17 [http-nio-9527-exec-113] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092885083
|
|
2024-11-23 11:13:10 [http-nio-9527-exec-122] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092886095
|
|
2024-11-23 13:16:31 [http-nio-9527-exec-127] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092849955
|
|
2024-11-23 13:19:55 [http-nio-9527-exec-122] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092829729
|
|
2024-11-23 13:21:56 [http-nio-9527-exec-122] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092850226
|
|
2024-11-23 13:30:18 [http-nio-9527-exec-117] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092885144
|
|
2024-11-23 13:32:13 [http-nio-9527-exec-125] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092862815
|
|
2024-11-23 13:34:10 [http-nio-9527-exec-105] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 13:34:11 [http-nio-9527-exec-125] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 13:34:11 [http-nio-9527-exec-112] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 13:46:29 [http-nio-9527-exec-121] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092808624
|
|
2024-11-23 13:48:53 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092822043
|
|
2024-11-23 13:49:36 [http-nio-9527-exec-125] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092878793
|
|
2024-11-23 15:22:32 [http-nio-9527-exec-121] ERROR o.example.controller.BaseController - 系统未知错误
|
|
java.lang.NullPointerException: null
|
|
at org.example.service.impl.SplitServiceImpl.checkParam(SplitServiceImpl.java:848)
|
|
at org.example.service.impl.SplitServiceImpl.commitSplitNew(SplitServiceImpl.java:741)
|
|
at org.example.service.impl.SplitServiceImpl$$FastClassBySpringCGLIB$$7d8ec1a2.invoke(<generated>)
|
|
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
|
|
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
|
|
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
|
|
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
|
|
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
|
|
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
|
|
at org.example.service.impl.SplitServiceImpl$$EnhancerBySpringCGLIB$$9b099273.commitSplitNew(<generated>)
|
|
at org.example.controller.PDASplitController.commitSplit(PDASplitController.java:56)
|
|
at sun.reflect.GeneratedMethodAccessor1249.invoke(Unknown Source)
|
|
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
|
|
at java.lang.reflect.Method.invoke(Method.java:498)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
|
|
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
|
|
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
|
|
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
|
|
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
|
|
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
|
|
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
|
|
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
|
|
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
|
|
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
|
|
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.example.filter.AccessFilter.doFilter(AccessFilter.java:129)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
|
|
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
|
|
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
|
|
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
|
|
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
|
|
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
|
|
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
|
|
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
|
|
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
|
|
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
|
|
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
|
|
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
|
|
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
|
|
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
|
|
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
|
|
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
|
|
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
|
|
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
|
|
at java.lang.Thread.run(Thread.java:750)
|
|
2024-11-23 15:57:18 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 15:58:26 [http-nio-9527-exec-113] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 16:37:25 [http-nio-9527-exec-121] ERROR org.example.controller.WcsController - 入库操作任务不存在！
|
|
2024-11-23 17:58:22 [http-nio-9527-exec-127] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:22 [http-nio-9527-exec-125] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|101030
|
|
2024-11-23 17:58:23 [http-nio-9527-exec-120] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:24 [http-nio-9527-exec-130] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:24 [http-nio-9527-exec-117] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:24 [http-nio-9527-exec-122] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:24 [http-nio-9527-exec-113] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 17:58:24 [http-nio-9527-exec-127] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 18:04:07 [http-nio-9527-exec-130] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|null
|
|
2024-11-23 18:14:08 [http-nio-9527-exec-130] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092857361
|
|
2024-11-23 18:17:33 [http-nio-9527-exec-120] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092857361
|
|
2024-11-23 18:19:20 [http-nio-9527-exec-131] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092872457
|
|
2024-11-23 18:26:41 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092831152
|
|
2024-11-23 18:27:06 [http-nio-9527-exec-113] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092877209
|
|
2024-11-23 18:35:15 [http-nio-9527-exec-127] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092884719
|
|
2024-11-23 19:03:57 [http-nio-9527-exec-105] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092818142
|
|
2024-11-23 19:04:35 [http-nio-9527-exec-117] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092820196
|
|
2024-11-23 19:05:15 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 批次识别码已在占用！09004722092820196
|
|
2024-11-23 19:17:34 [http-nio-9527-exec-130] ERROR org.example.controller.MesController - 库存数据不足，无任务创建！
|
|
2024-11-23 19:24:00 [http-nio-9527-exec-128] ERROR org.example.controller.MesController - 库存数据不足，无任务创建！
|
|
2024-11-23 19:35:32 [http-nio-9527-exec-131] ERROR org.example.controller.MesController - 库存数据不足，无任务创建！
|
|
2024-11-23 20:00:10 [http-nio-9527-exec-120] ERROR org.example.controller.ErpController - REP仓库和WMS仓库数据不一致！null|101030
|