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(<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]
|
