#

野心家

6 天以前 c5a3c0864c3fc94aed7019b412586352c589f185

#

 log/error.log

@@ -19,3 +19,227 @@
2025-06-13 09:36:26.980 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 09:36:28.023 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 09:46:13.142 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 10:56:03.587 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 10:56:04.623 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 10:56:05.681 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:14.320 [Thread-13] ERROR o.s.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.apache.ibatis.exceptions.PersistenceException: 
### Error updating database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
### SQL: UPDATE asr_bas_devp  SET in_enable=?,  out_enable=?,  autoing=?,  loading=?,                  wrk_no=?,        in_qty=?,            loc_type1=?  WHERE dev_no=?
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
    at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:200)
    at com.baomidou.mybatisplus.service.impl.ServiceImpl.updateBatchById(ServiceImpl.java:374)
    at com.baomidou.mybatisplus.service.impl.ServiceImpl.updateBatchById(ServiceImpl.java:339)
    at com.baomidou.mybatisplus.service.impl.ServiceImpl.updateBatchById(ServiceImpl.java:333)
    at com.baomidou.mybatisplus.service.impl.ServiceImpl$$FastClassBySpringCGLIB$$3e2398a4.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.BasDevpServiceImpl$$EnhancerBySpringCGLIB$$d9c6889.updateBatchById(<generated>)
    at com.zy.core.thread.SiemensDevpThread.read(SiemensDevpThread.java:251)
    at com.zy.core.thread.SiemensDevpThread.run(SiemensDevpThread.java:100)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1130)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3536)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(SQLServerConnection.java:3187)
    at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:311)
    at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)
    at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
    at sun.reflect.GeneratedMethodAccessor110.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
    at com.baomidou.mybatisplus.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:98)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
    at com.sun.proxy.$Proxy155.prepare(Unknown Source)
    at org.apache.ibatis.executor.BatchExecutor.doUpdate(BatchExecutor.java:70)
    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:198)
    ... 15 common frames omitted
2025-06-13 13:18:14.323 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:15.389 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:29.722 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:30.762 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:31.788 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:48:16.594 [Thread-16] ERROR o.s.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.springframework.dao.DataAccessResourceFailureException: 
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
### The error may exist in com/zy/asrs/mapper/BasErrLogMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT  id AS id,uuid,wrk_no AS wrkNo,start_time AS startTime,end_time AS endTime,wrk_sts AS wrkSts,io_type AS ioType,crn_no AS crnNo,plc_no AS plcNo,loc_no AS locNo,sta_no AS staNo,source_sta_no AS sourceStaNo,source_loc_no AS sourceLocNo,barcode,err_code AS errCode,error,status,create_time AS createTime,create_by AS createBy,update_time AS updateTime,update_by AS updateBy,memo  FROM asr_bas_err_log   WHERE  (crn_no = ?) ORDER BY start_time DESC
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
; Connection reset; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    at com.sun.proxy.$Proxy77.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy106.selectList(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy107.selectList(Unknown Source)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl.findLatest(BasErrLogServiceImpl.java:27)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$FastClassBySpringCGLIB$$c70e84fe.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$EnhancerBySpringCGLIB$$d496bc8f.findLatest(<generated>)
    at com.zy.asrs.service.impl.MainServiceImpl.recCrnErr(MainServiceImpl.java:1291)
    at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.MainServiceImpl$$EnhancerBySpringCGLIB$$fc17d735.recCrnErr(<generated>)
    at com.zy.core.MainProcess.lambda$start$0(MainProcess.java:64)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2998)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2034)
    at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6446)
    at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7610)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:598)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy155.query(Unknown Source)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
    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:83)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at sun.reflect.GeneratedMethodAccessor159.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:433)
    ... 33 common frames omitted
Caused by: java.net.SocketException: Connection reset
    at java.net.SocketInputStream.read(SocketInputStream.java:209)
    at java.net.SocketInputStream.read(SocketInputStream.java:141)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2026)
    ... 62 common frames omitted
2025-06-13 13:54:38.984 [Thread-16] ERROR o.s.transaction.interceptor.TransactionInterceptor - Application exception overridden by rollback exception
org.springframework.dao.DataAccessResourceFailureException: 
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
### The error may exist in file [D:\IDEA\zy-wcs\target\classes\mapper\WrkMastMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select * from dbo.asr_wrk_mast where crn_no=? and source_sta_no=? and wrk_sts=11 and io_type>100 order by io_pri desc,io_time,wrk_no asc
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
; Socket closed; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
    at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    at com.sun.proxy.$Proxy77.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy78.selectPakOutStep11(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy80.selectPakOutStep11(Unknown Source)
    at com.zy.asrs.service.impl.MainServiceImpl.locToCrnStn(MainServiceImpl.java:794)
    at com.zy.asrs.service.impl.MainServiceImpl.crnIoExecute(MainServiceImpl.java:578)
    at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.MainServiceImpl$$EnhancerBySpringCGLIB$$fc17d735.crnIoExecute(<generated>)
    at com.zy.core.MainProcess.lambda$start$0(MainProcess.java:58)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2998)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2034)
    at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6446)
    at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7610)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:598)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy155.query(Unknown Source)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
    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:83)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at sun.reflect.GeneratedMethodAccessor159.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:433)
    ... 29 common frames omitted
Caused by: java.net.SocketException: Socket closed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
    at java.net.SocketInputStream.read(SocketInputStream.java:170)
    at java.net.SocketInputStream.read(SocketInputStream.java:141)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2026)
    ... 58 common frames omitted
2025-06-13 13:54:40.980 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]
2025-06-13 13:54:42.053 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0]

 log/info.log

@@ -143,3 +143,107 @@
2025-06-13 09:46:12.193 [Thread-26] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.
2025-06-13 09:46:12.580 [Thread-12] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
2025-06-13 09:46:12.612 [Thread-12] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
2025-06-13 10:55:57.329 [main] INFO  com.zy.Boot - Starting Boot on zzzzzzz with PID 28796 (D:\IDEA\zy-wcs\target\classes started by zwl in D:\IDEA\zy-wcs)
2025-06-13 10:55:57.330 [main] INFO  com.zy.Boot - No active profile set, falling back to default profiles: default
2025-06-13 10:55:58.125 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
2025-06-13 10:55:58.127 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data repositories in DEFAULT mode.
2025-06-13 10:55:58.171 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 32ms. Found 0 repository interfaces.
2025-06-13 10:55:58.561 [main] INFO  o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$566f3fda] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-06-13 10:55:58.846 [main] INFO  o.s.boot.web.embedded.tomcat.TomcatWebServer - Tomcat initialized with port(s): 9092 (http)
2025-06-13 10:55:58.865 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-9092"]
2025-06-13 10:55:58.876 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
2025-06-13 10:55:58.876 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.16]
2025-06-13 10:55:58.883 [main] INFO  org.apache.catalina.core.AprLifecycleListener - Loaded APR based Apache Tomcat Native library [1.2.24] using APR version [1.7.0].
2025-06-13 10:55:58.883 [main] INFO  org.apache.catalina.core.AprLifecycleListener - APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
2025-06-13 10:55:58.883 [main] INFO  org.apache.catalina.core.AprLifecycleListener - APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
2025-06-13 10:55:58.887 [main] INFO  org.apache.catalina.core.AprLifecycleListener - OpenSSL successfully initialized [OpenSSL 1.1.1g  21 Apr 2020]
2025-06-13 10:55:59.048 [main] INFO  o.a.c.c.C.[Tomcat].[localhost].[/clwcs] - Initializing Spring embedded WebApplicationContext
2025-06-13 10:55:59.048 [main] INFO  org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 1668 ms
2025-06-13 10:55:59.341 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2025-06-13 10:55:59.534 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
2025-06-13 10:56:00.748 [main] INFO  com.zy.core.ServerBootstrap - 核心控制层开始初始化...............................................
2025-06-13 10:56:02.751 [main] INFO  com.zy.core.ServerBootstrap - 初始化堆垛机线程...................................................
2025-06-13 10:56:02.753 [main] INFO  com.zy.core.ServerBootstrap - 初始化输送线线程...................................................
2025-06-13 10:56:02.755 [main] INFO  com.zy.core.ServerBootstrap - 初始化条码扫描仪线程...................................................
2025-06-13 10:56:02.755 [main] INFO  com.zy.core.ServerBootstrap - 初始化LED线程...................................................
2025-06-13 10:56:02.758 [main] INFO  com.zy.core.ServerBootstrap - 核心控制层已启动...............................................
2025-06-13 10:56:02.857 [main] INFO  com.zy.core.netty.OnlineServer - TCP server started successfully, port：0
2025-06-13 10:56:02.866 [Thread-12] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机plc连接成功 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0]
2025-06-13 10:56:02.923 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线plc连接成功 ===>> [id:1] [ip:178.18.1.140] [port:102]
2025-06-13 10:56:03.580 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：80000001
2025-06-13 10:56:06.106 [main] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Initializing ExecutorService 'applicationTaskExecutor'
2025-06-13 10:56:06.636 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-9092"]
2025-06-13 10:56:06.659 [main] INFO  o.s.boot.web.embedded.tomcat.TomcatWebServer - Tomcat started on port(s): 9092 (http) with context path '/clwcs'
2025-06-13 10:56:06.662 [main] INFO  com.zy.Boot - Started Boot in 9.879 seconds (JVM running for 12.664)
2025-06-13 10:56:06.986 [http-nio-9092-exec-4] INFO  o.a.c.c.C.[Tomcat].[localhost].[/clwcs] - Initializing Spring DispatcherServlet 'dispatcherServlet'
2025-06-13 10:56:06.986 [http-nio-9092-exec-4] INFO  org.springframework.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
2025-06-13 10:56:06.992 [http-nio-9092-exec-4] INFO  org.springframework.web.servlet.DispatcherServlet - Completed initialization in 6 ms
2025-06-13 10:56:08.055 [Thread-16] INFO  com.zy.asrs.service.impl.MainServiceImpl - 堆垛机命令下发成功，堆垛机号=1，任务数据={"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3023,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 10:56:08.601 [Thread-12] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3023,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 10:57:19.207 [Thread-12] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":0,"taskMode":0,"crnNo":1,"sourceStaNo":0,"command":0,"ackFinish":1,"destinationLane":0,"taskNo":0,"destinationPosZ":0,"sourceLane":0,"destinationPosY":0,"destinationStaNo":0,"destinationPosX":0,"sourcePosY":0,"sourcePosZ":0}
2025-06-13 10:57:19.816 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线命令下发 [id:1] >>>>> 命令下发： {"inEnable":false,"weightErr":false,"staNo":102,"infraredErr":false,"pakMk":true,"rightErr":false,"frontErr":false,"workNo":3023,"high":false,"leftErr":false,"outEnable":false,"upcontactErr":false,"low":false,"inverterErr":false,"seizeSeatErr":false,"breakerErr":false,"outTimeErr":false,"autoing":true,"loading":true,"fullPlt":false,"contactErr":false,"barcodeErr":false,"backErr":false,"highErr":false,"siteId":103,"wrkYgoodsN":false,"emptyMk":false}
2025-06-13 13:16:38.732 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：00000000
2025-06-13 13:16:43.962 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：80000001
2025-06-13 13:18:14.286 [Thread-26] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Shutting down ExecutorService 'applicationTaskExecutor'
2025-06-13 13:18:14.300 [Thread-26] INFO  com.zy.core.netty.OnlineServer - TCP server stopped successfully, port: 0
2025-06-13 13:18:14.304 [Thread-26] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated...
2025-06-13 13:18:14.310 [Thread-26] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.
2025-06-13 13:18:14.781 [Thread-12] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
2025-06-13 13:18:14.807 [Thread-12] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.
2025-06-13 13:18:23.615 [main] INFO  com.zy.Boot - Starting Boot on zzzzzzz with PID 26232 (D:\IDEA\zy-wcs\target\classes started by zwl in D:\IDEA\zy-wcs)
2025-06-13 13:18:23.616 [main] INFO  com.zy.Boot - No active profile set, falling back to default profiles: default
2025-06-13 13:18:24.458 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode!
2025-06-13 13:18:24.460 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data repositories in DEFAULT mode.
2025-06-13 13:18:24.496 [main] INFO  o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 25ms. Found 0 repository interfaces.
2025-06-13 13:18:24.765 [main] INFO  o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker - Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$283ec6aa] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2025-06-13 13:18:25.103 [main] INFO  o.s.boot.web.embedded.tomcat.TomcatWebServer - Tomcat initialized with port(s): 9092 (http)
2025-06-13 13:18:25.120 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-9092"]
2025-06-13 13:18:25.134 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
2025-06-13 13:18:25.134 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.16]
2025-06-13 13:18:25.141 [main] INFO  org.apache.catalina.core.AprLifecycleListener - Loaded APR based Apache Tomcat Native library [1.2.24] using APR version [1.7.0].
2025-06-13 13:18:25.141 [main] INFO  org.apache.catalina.core.AprLifecycleListener - APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
2025-06-13 13:18:25.142 [main] INFO  org.apache.catalina.core.AprLifecycleListener - APR/OpenSSL configuration: useAprConnector [false], useOpenSSL [true]
2025-06-13 13:18:25.146 [main] INFO  org.apache.catalina.core.AprLifecycleListener - OpenSSL successfully initialized [OpenSSL 1.1.1g  21 Apr 2020]
2025-06-13 13:18:25.265 [main] INFO  o.a.c.c.C.[Tomcat].[localhost].[/clwcs] - Initializing Spring embedded WebApplicationContext
2025-06-13 13:18:25.265 [main] INFO  org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 1606 ms
2025-06-13 13:18:25.545 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
2025-06-13 13:18:25.729 [main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Start completed.
2025-06-13 13:18:26.866 [main] INFO  com.zy.core.ServerBootstrap - 核心控制层开始初始化...............................................
2025-06-13 13:18:28.879 [main] INFO  com.zy.core.ServerBootstrap - 初始化堆垛机线程...................................................
2025-06-13 13:18:28.881 [main] INFO  com.zy.core.ServerBootstrap - 初始化输送线线程...................................................
2025-06-13 13:18:28.884 [main] INFO  com.zy.core.ServerBootstrap - 初始化条码扫描仪线程...................................................
2025-06-13 13:18:28.886 [main] INFO  com.zy.core.ServerBootstrap - 初始化LED线程...................................................
2025-06-13 13:18:28.890 [main] INFO  com.zy.core.ServerBootstrap - 核心控制层已启动...............................................
2025-06-13 13:18:28.993 [main] INFO  com.zy.core.netty.OnlineServer - TCP server started successfully, port：0
2025-06-13 13:18:29.030 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机plc连接成功 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0]
2025-06-13 13:18:29.048 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线plc连接成功 ===>> [id:1] [ip:178.18.1.140] [port:102]
2025-06-13 13:18:29.715 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：80000001
2025-06-13 13:18:32.309 [main] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Initializing ExecutorService 'applicationTaskExecutor'
2025-06-13 13:18:32.819 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-9092"]
2025-06-13 13:18:32.834 [main] INFO  o.s.boot.web.embedded.tomcat.TomcatWebServer - Tomcat started on port(s): 9092 (http) with context path '/clwcs'
2025-06-13 13:18:32.837 [main] INFO  com.zy.Boot - Started Boot in 9.802 seconds (JVM running for 14.497)
2025-06-13 13:18:45.099 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线命令下发 [id:1] >>>>> 命令下发： {"inEnable":true,"weightErr":false,"staNo":101,"infraredErr":false,"pakMk":true,"rightErr":false,"frontErr":false,"workNo":3023,"high":false,"leftErr":false,"outEnable":false,"upcontactErr":false,"low":true,"inverterErr":false,"seizeSeatErr":false,"breakerErr":false,"outTimeErr":false,"autoing":true,"loading":true,"fullPlt":true,"contactErr":false,"barcodeErr":false,"backErr":false,"highErr":false,"siteId":101,"wrkYgoodsN":false,"emptyMk":false}
2025-06-13 13:18:47.350 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":2,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3023,"destinationPosZ":1,"sourceLane":0,"destinationPosY":1,"destinationStaNo":0,"destinationPosX":1,"sourcePosY":18,"sourcePosZ":1}
2025-06-13 13:19:06.315 [http-nio-9092-exec-3] INFO  o.a.c.c.C.[Tomcat].[localhost].[/clwcs] - Initializing Spring DispatcherServlet 'dispatcherServlet'
2025-06-13 13:19:06.315 [http-nio-9092-exec-3] INFO  org.springframework.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
2025-06-13 13:19:06.320 [http-nio-9092-exec-3] INFO  org.springframework.web.servlet.DispatcherServlet - Completed initialization in 5 ms
2025-06-13 13:20:05.313 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":0,"taskMode":0,"crnNo":1,"sourceStaNo":0,"command":0,"ackFinish":1,"destinationLane":0,"taskNo":0,"destinationPosZ":0,"sourceLane":0,"destinationPosY":0,"destinationStaNo":0,"destinationPosX":0,"sourcePosY":0,"sourcePosZ":0}
2025-06-13 13:21:04.628 [Thread-16] INFO  com.zy.asrs.service.impl.MainServiceImpl - 堆垛机命令下发成功，堆垛机号=1，任务数据={"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3024,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 13:21:05.524 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3024,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 13:22:23.878 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":0,"taskMode":0,"crnNo":1,"sourceStaNo":0,"command":0,"ackFinish":1,"destinationLane":0,"taskNo":0,"destinationPosZ":0,"sourceLane":0,"destinationPosY":0,"destinationStaNo":0,"destinationPosX":0,"sourcePosY":0,"sourcePosZ":0}
2025-06-13 13:22:24.072 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线命令下发 [id:1] >>>>> 命令下发： {"inEnable":false,"weightErr":false,"staNo":102,"infraredErr":false,"pakMk":true,"rightErr":false,"frontErr":false,"workNo":3024,"high":false,"leftErr":false,"outEnable":false,"upcontactErr":false,"low":false,"inverterErr":false,"seizeSeatErr":false,"breakerErr":false,"outTimeErr":false,"autoing":true,"loading":true,"fullPlt":false,"contactErr":false,"barcodeErr":false,"backErr":false,"highErr":false,"siteId":103,"wrkYgoodsN":false,"emptyMk":false}
2025-06-13 13:32:57.580 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：00000000
2025-06-13 13:33:01.865 [Thread-13] INFO  com.zy.core.thread.BarcodeThread - 1号条码器，检索数据：80000001
2025-06-13 13:33:16.707 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线命令下发 [id:1] >>>>> 命令下发： {"inEnable":true,"weightErr":false,"staNo":101,"infraredErr":false,"pakMk":true,"rightErr":false,"frontErr":false,"workNo":3024,"high":false,"leftErr":false,"outEnable":false,"upcontactErr":false,"low":true,"inverterErr":false,"seizeSeatErr":false,"breakerErr":false,"outTimeErr":false,"autoing":true,"loading":true,"fullPlt":true,"contactErr":false,"barcodeErr":false,"backErr":false,"highErr":false,"siteId":101,"wrkYgoodsN":false,"emptyMk":false}
2025-06-13 13:33:18.979 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":2,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":3024,"destinationPosZ":1,"sourceLane":0,"destinationPosY":1,"destinationStaNo":0,"destinationPosX":1,"sourcePosY":18,"sourcePosZ":1}
2025-06-13 13:34:38.956 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":0,"taskMode":0,"crnNo":1,"sourceStaNo":0,"command":0,"ackFinish":1,"destinationLane":0,"taskNo":0,"destinationPosZ":0,"sourceLane":0,"destinationPosY":0,"destinationStaNo":0,"destinationPosX":0,"sourcePosY":0,"sourcePosZ":0}
2025-06-13 13:34:54.932 [Thread-16] INFO  com.zy.asrs.service.impl.MainServiceImpl - 堆垛机命令下发成功，堆垛机号=1，任务数据={"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":6040,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 13:34:55.666 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":1,"taskMode":3,"crnNo":1,"sourceStaNo":0,"command":1,"ackFinish":0,"destinationLane":0,"taskNo":6040,"destinationPosZ":1,"sourceLane":0,"destinationPosY":19,"destinationStaNo":0,"destinationPosX":2,"sourcePosY":1,"sourcePosZ":1}
2025-06-13 13:36:07.392 [Thread-11] INFO  com.zy.core.thread.SiemensCrnThread - 堆垛机命令下发[id:1] >>>>> {"sourcePosX":0,"taskMode":0,"crnNo":1,"sourceStaNo":0,"command":0,"ackFinish":1,"destinationLane":0,"taskNo":0,"destinationPosZ":0,"sourceLane":0,"destinationPosY":0,"destinationStaNo":0,"destinationPosX":0,"sourcePosY":0,"sourcePosZ":0}
2025-06-13 13:36:08.071 [Thread-13] INFO  com.zy.core.thread.SiemensDevpThread - 输送线命令下发 [id:1] >>>>> 命令下发： {"inEnable":false,"weightErr":false,"staNo":102,"infraredErr":false,"pakMk":true,"rightErr":false,"frontErr":false,"workNo":6040,"high":false,"leftErr":false,"outEnable":false,"upcontactErr":false,"low":false,"inverterErr":false,"seizeSeatErr":false,"breakerErr":false,"outTimeErr":false,"autoing":true,"loading":true,"fullPlt":false,"contactErr":false,"barcodeErr":false,"backErr":false,"highErr":false,"siteId":103,"wrkYgoodsN":false,"emptyMk":false}
2025-06-13 13:54:38.968 [Thread-25] INFO  o.s.scheduling.concurrent.ThreadPoolTaskExecutor - Shutting down ExecutorService 'applicationTaskExecutor'
2025-06-13 13:54:38.978 [Thread-25] INFO  com.zy.core.netty.OnlineServer - TCP server stopped successfully, port: 0
2025-06-13 13:54:38.980 [Thread-25] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown initiated...
2025-06-13 13:54:38.983 [Thread-25] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Shutdown completed.
2025-06-13 13:54:39.315 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Starting...
2025-06-13 13:54:39.362 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-2 - Start completed.

 log/warn.log

@@ -41,3 +41,211 @@
2025-06-13 09:46:12.739 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.LocDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 09:46:12.937 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WaitPakin ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 09:46:12.949 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WrkDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 10:55:59.825 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.LocDetl.
2025-06-13 10:55:59.825 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.LocDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 10:56:00.058 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.WaitPakin.
2025-06-13 10:56:00.058 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WaitPakin ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 10:56:00.074 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.WrkDetl.
2025-06-13 10:56:00.074 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WrkDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:15.005 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.LocDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:15.203 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WaitPakin ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:15.231 [Thread-12] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WrkDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:26.032 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.LocDetl.
2025-06-13 13:18:26.032 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.LocDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:26.271 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.WaitPakin.
2025-06-13 13:18:26.271 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WaitPakin ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:18:26.291 [main] WARN  com.baomidou.mybatisplus.toolkit.TableInfoHelper - Warn: Could not find @TableId in Class: com.zy.asrs.entity.WrkDetl.
2025-06-13 13:18:26.291 [main] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WrkDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:48:16.429 [Thread-16] WARN  com.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection ConnectionID:6 ClientConnectionId: db9986cd-9eff-4d30-ad67-04c4a6cbf839 marked as broken because of SQLSTATE(08S01), ErrorCode(0)
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2998)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2034)
    at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6446)
    at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7610)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:598)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy155.query(Unknown Source)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
    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:83)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at sun.reflect.GeneratedMethodAccessor159.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:433)
    at com.sun.proxy.$Proxy77.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy106.selectList(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy107.selectList(Unknown Source)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl.findLatest(BasErrLogServiceImpl.java:27)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$FastClassBySpringCGLIB$$c70e84fe.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$EnhancerBySpringCGLIB$$d496bc8f.findLatest(<generated>)
    at com.zy.asrs.service.impl.MainServiceImpl.recCrnErr(MainServiceImpl.java:1291)
    at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.MainServiceImpl$$EnhancerBySpringCGLIB$$fc17d735.recCrnErr(<generated>)
    at com.zy.core.MainProcess.lambda$start$0(MainProcess.java:64)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Connection reset
    at java.net.SocketInputStream.read(SocketInputStream.java:209)
    at java.net.SocketInputStream.read(SocketInputStream.java:141)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2026)
    ... 62 common frames omitted
2025-06-13 13:48:16.575 [Thread-16] WARN  o.s.jdbc.support.SQLErrorCodesFactory - Error while extracting database name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connection is closed
    at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:331)
    at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:356)
    at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:214)
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:136)
    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:99)
    at org.mybatis.spring.MyBatisExceptionTranslator.initExceptionTranslator(MyBatisExceptionTranslator.java:87)
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:72)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
    at com.sun.proxy.$Proxy77.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy106.selectList(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor178.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy107.selectList(Unknown Source)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl.findLatest(BasErrLogServiceImpl.java:27)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$FastClassBySpringCGLIB$$c70e84fe.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
    at com.zy.asrs.service.impl.BasErrLogServiceImpl$$EnhancerBySpringCGLIB$$d496bc8f.findLatest(<generated>)
    at com.zy.asrs.service.impl.MainServiceImpl.recCrnErr(MainServiceImpl.java:1291)
    at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.MainServiceImpl$$EnhancerBySpringCGLIB$$fc17d735.recCrnErr(<generated>)
    at com.zy.core.MainProcess.lambda$start$0(MainProcess.java:64)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Connection is closed
    at com.zaxxer.hikari.pool.ProxyConnection$ClosedConnection.lambda$getClosedConnection$0(ProxyConnection.java:489)
    at com.sun.proxy.$Proxy66.getMetaData(Unknown Source)
    at com.zaxxer.hikari.pool.ProxyConnection.getMetaData(ProxyConnection.java:354)
    at com.zaxxer.hikari.pool.HikariProxyConnection.getMetaData(HikariProxyConnection.java)
    at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
    ... 40 common frames omitted
2025-06-13 13:54:38.983 [Thread-16] WARN  com.zaxxer.hikari.pool.ProxyConnection - HikariPool-1 - Connection ConnectionID:14 ClientConnectionId: 660253a4-f53f-43ce-b1fd-77290f7efa69 marked as broken because of SQLSTATE(08S01), ErrorCode(0)
com.microsoft.sqlserver.jdbc.SQLServerException: Socket closed
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2998)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2034)
    at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6446)
    at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7610)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:598)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:522)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7225)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3053)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:247)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:222)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:503)
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
    at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:63)
    at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
    at sun.reflect.GeneratedMethodAccessor108.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
    at com.sun.proxy.$Proxy155.query(Unknown Source)
    at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
    at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
    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:83)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
    at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
    at sun.reflect.GeneratedMethodAccessor159.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:433)
    at com.sun.proxy.$Proxy77.selectList(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
    at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
    at com.sun.proxy.$Proxy78.selectPakOutStep11(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor298.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
    at com.sun.proxy.$Proxy80.selectPakOutStep11(Unknown Source)
    at com.zy.asrs.service.impl.MainServiceImpl.locToCrnStn(MainServiceImpl.java:794)
    at com.zy.asrs.service.impl.MainServiceImpl.crnIoExecute(MainServiceImpl.java:578)
    at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.zy.asrs.service.impl.MainServiceImpl$$EnhancerBySpringCGLIB$$fc17d735.crnIoExecute(<generated>)
    at com.zy.core.MainProcess.lambda$start$0(MainProcess.java:58)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.SocketException: Socket closed
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
    at java.net.SocketInputStream.read(SocketInputStream.java:170)
    at java.net.SocketInputStream.read(SocketInputStream.java:141)
    at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:2026)
    ... 58 common frames omitted
2025-06-13 13:54:40.046 [Thread-11] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.LocDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:54:40.699 [Thread-11] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WaitPakin ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.
2025-06-13 13:54:40.776 [Thread-11] WARN  com.baomidou.mybatisplus.mapper.AutoSqlInjector - class com.zy.asrs.entity.WrkDetl ,Not found @TableId annotation, Cannot use Mybatis-Plus 'xxById' Method.

 src/main/resources/application.yml

@@ -34,7 +34,7 @@
  enable: false

wms:
  url: 127.0.0.1:8081/clwms
  url: 127.0.0.1:8080/clwms

# 下位机配置
wcs-slave:

 src/main/resources/mapper/WrkMastMapper.xml

@@ -100,7 +100,7 @@
    </select>

    <select id="selectPickStep" resultMap="BaseResultMap">
        select top 1 * from asr_wrk_mast where barcode=#{barcode} and wrk_sts=14 and (io_type=103 or io_type=107 or io_type=104)
        select top 1 * from asr_wrk_mast where barcode=#{barcode} and wrk_sts=16 and (io_type=103 or io_type=107 or io_type=104)
    </select>

    <select id="selectPakOutStep1" resultMap="BaseResultMap">