2025-06-13 08:28:37.093 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 08:28:38.133 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 08:28:39.159 [Thread-13] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 08:42:12.348 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:42:22.861 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:42:33.376 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:42:43.897 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:42:54.410 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:43:04.924 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:43:15.441 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:43:25.955 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 08:43:29.706 [Thread-12] ERROR com.zy.core.thread.SiemensCrnThread - 读取堆垛机plc状态信息失败 ===>> [id:1] [ip:178.18.1.130] [port:102] [rack:0] [slot:0] 2025-06-13 09:12:28.868 [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:12:47.278 [Thread-12] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 09:12:48.336 [Thread-12] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 09:12:49.372 [Thread-12] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 09:36:12.446 [Thread-12] ERROR com.zy.core.thread.SiemensDevpThread - 更新数据库数据失败 ===>> [id:1] [ip:178.18.1.140] [port:102] [rack:0] [slot:0] 2025-06-13 09:36:25.913 [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: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() 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() 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() 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() at com.zy.asrs.service.impl.MainServiceImpl.recCrnErr(MainServiceImpl.java:1291) at com.zy.asrs.service.impl.MainServiceImpl$$FastClassBySpringCGLIB$$75c80c20.invoke() 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() 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() 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() 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]