qiaolin-li commented on issue #2677: TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException URL: https://github.com/apache/incubator-shardingsphere/issues/2677#issuecomment-509196755 ## Attach the relevant stack information： ### primary ```java 2019-07-06 16:33:25,345 INFO [pool-52-thread-1-591] Class=[com.frxs.trade.area.biz.event.schedule.nativejob.AreaScheduled] 刷新区域缓存完成... 2019-07-06 16:33:51,933 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2076-6540] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:0 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[100,110] 2019-07-06 16:33:51,933 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2077-6541] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:1 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[101,111] 2019-07-06 16:33:51,933 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2078-6542] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:2 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[102,112] 2019-07-06 16:33:51,934 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2079-6543] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:3 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[103,113] 2019-07-06 16:33:51,935 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2080-6544] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:4 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[104,114] 2019-07-06 16:33:51,938 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2081-6545] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:5 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[105,115] 2019-07-06 16:33:51,939 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2082-6546] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:6 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[106,116] 2019-07-06 16:33:51,941 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2084-6548] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:8 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[108,118] 2019-07-06 16:33:51,940 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2083-6547] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:7 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[107,117] 2019-07-06 16:33:51,941 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2085-6549] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:9 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[109,119] 2019-07-06 16:33:51,990 ERROR [autoConfirmThreadPool185-2879] Class=[com.alibaba.druid.pool.DruidDataSource] discard connection com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,728,456 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor137.newInstance(Unknown Source) ~[?:?] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_151] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_151] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3903) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4796) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:738) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:985) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:733) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:430) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:712) ~[druid-1.1.10.jar!/:1.1.10] at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at io.shardingjdbc.core.jdbc.adapter.invocation.JdbcMethodInvocation.invoke(JdbcMethodInvocation.java:48) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.adapter.WrapperAdapter.replayMethodsInvocation(WrapperAdapter.java:74) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.core.connection.ShardingConnection.getConnection(ShardingConnection.java:114) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.core.connection.ShardingConnection.getMetaData(ShardingConnection.java:133) ~[sharding-jdbc-core-2.0.3.jar!/:?] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNextResultSet(DefaultResultSetHandler.java:258) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:197) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.6.jar!/:3.4.6] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) ~[mybatis-3.4.6.jar!/:3.4.6] at com.sun.proxy.$Proxy147.query(Unknown Source) ~[?:?] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar!/:3.4.6] at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar!/:1.3.2] at com.sun.proxy.$Proxy104.selectList(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-1.3.2.jar!/:1.3.2] at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.6.jar!/:3.4.6] at com.sun.proxy.$Proxy123.findAutoConfirmOrders(Unknown Source) ~[?:?] at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.sun.proxy.$Proxy124.findAutoConfirmOrders(Unknown Source) ~[?:?] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.fetchAutoConfirmOrders(AutoConfirmDeliveryServiceImpl.java:275) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.lambda$handeDelivery$0(AutoConfirmDeliveryServiceImpl.java:175) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.handeDelivery(AutoConfirmDeliveryServiceImpl.java:172) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.start(AutoConfirmDeliveryServiceImpl.java:108) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob.lambda$execute$2(AutoConfirmDeliveryJob.java:125) ~[trade-area-biz-event-1.0.0.jar!/:1.0.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151] Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:210) ~[?:1.8.0_151] at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[?:1.8.0_151] at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] ... 62 more 2019-07-06 16:33:52,196 INFO [autoConfirmThreadPool31-1034] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:7 sharding:101_668807 time:255.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,253 INFO [autoConfirmThreadPool185-2879] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:3 sharding:101_668803 time:319.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,263 INFO [autoConfirmThreadPool31-1034] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,263 ERROR [autoConfirmThreadPool185-2879] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货异常 item:101_668803 sharding:org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException 2019-07-06 16:33:52,265 INFO [autoConfirmThreadPool216-2909] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:8 sharding:101_668808 time:324.2 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,271 INFO [autoConfirmThreadPool163-2859] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:2 sharding:101_668802 time:338.7 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,278 INFO [autoConfirmThreadPool216-2909] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,361 INFO [autoConfirmThreadPool163-2859] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,375 INFO [autoConfirmThreadPool310-4932] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:0 sharding:101_668800 time:443.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,386 INFO [autoConfirmThreadPool310-4932] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,403 INFO [autoConfirmThreadPool221-2918] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:6 sharding:101_668806 time:463.8 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,280 ERROR [autoConfirmThreadPool262-4884] Class=[com.alibaba.druid.pool.DruidDataSource] discard connection com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,461,993 milliseconds ago. The last packet sent successfully to the server was 7 milliseconds ago. at sun.reflect.GeneratedConstructorAccessor137.newInstance(Unknown Source) ~[?:?] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_151] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_151] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3562) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3462) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3903) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2482) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4796) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:738) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:985) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:733) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:430) ~[druid-1.1.10.jar!/:1.1.10] at com.alibaba.druid.pool.DruidPooledConnection.setAutoCommit(DruidPooledConnection.java:712) ~[druid-1.1.10.jar!/:1.1.10] at sun.reflect.GeneratedMethodAccessor111.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at io.shardingjdbc.core.jdbc.adapter.invocation.JdbcMethodInvocation.invoke(JdbcMethodInvocation.java:48) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.adapter.WrapperAdapter.replayMethodsInvocation(WrapperAdapter.java:74) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.core.connection.ShardingConnection.getConnection(ShardingConnection.java:114) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.core.connection.ShardingConnection.getMetaData(ShardingConnection.java:133) ~[sharding-jdbc-core-2.0.3.jar!/:?] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getNextResultSet(DefaultResultSetHandler.java:258) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:197) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.4.6.jar!/:3.4.6] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63) ~[mybatis-3.4.6.jar!/:3.4.6] at com.sun.proxy.$Proxy147.query(Unknown Source) ~[?:?] at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.6.jar!/:3.4.6] at sun.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433) ~[mybatis-spring-1.3.2.jar!/:1.3.2] at com.sun.proxy.$Proxy104.selectList(Unknown Source) ~[?:?] at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230) ~[mybatis-spring-1.3.2.jar!/:1.3.2] at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:139) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76) ~[mybatis-3.4.6.jar!/:3.4.6] at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.6.jar!/:3.4.6] at com.sun.proxy.$Proxy123.findAutoConfirmOrders(Unknown Source) ~[?:?] at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_151] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_151] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:197) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.sun.proxy.$Proxy124.findAutoConfirmOrders(Unknown Source) ~[?:?] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.fetchAutoConfirmOrders(AutoConfirmDeliveryServiceImpl.java:275) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.lambda$handeDelivery$0(AutoConfirmDeliveryServiceImpl.java:175) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.handeDelivery(AutoConfirmDeliveryServiceImpl.java:172) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl.start(AutoConfirmDeliveryServiceImpl.java:108) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob.lambda$execute$2(AutoConfirmDeliveryJob.java:125) ~[trade-area-biz-event-1.0.0.jar!/:1.0.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151] Caused by: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:210) ~[?:1.8.0_151] at java.net.SocketInputStream.read(SocketInputStream.java:141) ~[?:1.8.0_151] at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3011) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3472) ~[mysql-connector-java-5.1.46.jar!/:5.1.46] ... 62 more 2019-07-06 16:33:52,441 INFO [autoConfirmThreadPool221-2918] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,485 INFO [autoConfirmThreadPool176-2884] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:4 sharding:101_668804 time:549.9 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,498 INFO [autoConfirmThreadPool176-2884] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,512 INFO [autoConfirmThreadPool308-4930] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:0 sharding:101_668810 time:580.4 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,513 INFO [autoConfirmThreadPool183-2880] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:1 sharding:101_668801 time:580.4 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,522 INFO [autoConfirmThreadPool308-4930] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,523 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2076-6540] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:0 time:591.0 ms 2019-07-06 16:33:52,525 INFO [autoConfirmThreadPool183-2880] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,528 INFO [autoConfirmThreadPool262-4884] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:9 sharding:101_668809 time:587.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,531 ERROR [autoConfirmThreadPool262-4884] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货异常 item:101_668809 sharding:org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException 2019-07-06 16:33:52,555 INFO [autoConfirmThreadPool115-2546] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:7 sharding:101_668817 time:615.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,566 INFO [autoConfirmThreadPool115-2546] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,566 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2083-6547] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:7 time:626.1 ms 2019-07-06 16:33:52,642 INFO [autoConfirmThreadPool11-1014] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:8 sharding:101_668818 time:701.8 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,642 INFO [autoConfirmThreadPool151-2584] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:3 sharding:101_668813 time:708.7 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,642 INFO [autoConfirmThreadPool278-4900] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:6 sharding:101_668816 time:703.7 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,651 INFO [autoConfirmThreadPool151-2584] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,652 INFO [autoConfirmThreadPool278-4900] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,651 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2079-6543] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:3 time:717.2 ms 2019-07-06 16:33:52,652 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2082-6546] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:6 time:712.7 ms 2019-07-06 16:33:52,656 INFO [autoConfirmThreadPool11-1014] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,656 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2084-6548] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:8 time:715.8 ms 2019-07-06 16:33:52,665 INFO [autoConfirmThreadPool112-2541] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:2 sharding:101_668812 time:731.9 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,673 INFO [autoConfirmThreadPool112-2541] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,673 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2078-6542] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:2 time:740.2 ms 2019-07-06 16:33:52,712 INFO [autoConfirmThreadPool252-2952] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:1 sharding:101_668811 time:780.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,720 INFO [autoConfirmThreadPool252-2952] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,720 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2077-6541] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:1 time:787.6 ms 2019-07-06 16:33:52,741 INFO [autoConfirmThreadPool149-2586] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:5 sharding:101_668815 time:803.5 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,741 INFO [autoConfirmThreadPool307-4929] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:5 sharding:101_668805 time:804.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,748 INFO [autoConfirmThreadPool149-2586] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,748 INFO [autoConfirmThreadPool307-4929] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,749 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2081-6545] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:5 time:811.3 ms 2019-07-06 16:33:52,786 INFO [autoConfirmThreadPool301-4923] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:4 sharding:101_668814 time:851.0 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,800 INFO [autoConfirmThreadPool301-4923] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,801 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2080-6544] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:4 time:865.8 ms 2019-07-06 16:33:52,800 INFO [autoConfirmThreadPool187-2892] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:9 sharding:101_668819 time:861.5 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:1 2019-07-06 16:33:52,809 INFO [autoConfirmThreadPool187-2892] Class=[com.frxs.framework.integration.rocketmq.adapter.RocketMqProducerAdapter] rocketmq 2019-07-06 16:33:52,809 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2085-6549] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:9 time:868.0 ms 2019-07-06 16:33:53,069 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2086-6552] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:0 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[100,110] 2019-07-06 16:33:53,069 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2087-6553] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:1 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[101,111] 2019-07-06 16:33:53,070 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2088-6554] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:2 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[102,112] 2019-07-06 16:33:53,070 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2089-6555] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:3 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[103,113] 2019-07-06 16:33:53,072 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2090-6556] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:4 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[104,114] 2019-07-06 16:33:53,072 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2091-6557] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:5 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[105,115] 2019-07-06 16:33:53,073 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2092-6558] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:6 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[106,116] 2019-07-06 16:33:53,074 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2093-6559] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:7 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[107,117] 2019-07-06 16:33:53,076 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2094-6560] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:8 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[108,118] 2019-07-06 16:33:53,083 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2095-6561] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 分片信息 item:9 moAreas:[1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15] tables:[109,119] 2019-07-06 16:33:53,156 INFO [autoConfirmThreadPool206-2904] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:9 sharding:101_668809 time:72.98 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,157 INFO [autoConfirmThreadPool353-4975] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:7 sharding:101_668807 time:83.98 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,176 INFO [autoConfirmThreadPool180-2874] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:6 sharding:101_668806 time:103.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,173 INFO [autoConfirmThreadPool287-4909] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:5 sharding:101_668805 time:104.8 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,177 INFO [autoConfirmThreadPool39-1042] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:1 sharding:101_668801 time:108.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,221 INFO [autoConfirmThreadPool275-4897] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:0 sharding:101_668800 time:152.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,250 INFO [autoConfirmThreadPool347-4969] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:2 sharding:101_668802 time:181.0 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,254 INFO [autoConfirmThreadPool99-1102] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:3 sharding:101_668803 time:184.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,259 INFO [autoConfirmThreadPool146-2578] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:4 sharding:101_668804 time:188.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,262 INFO [autoConfirmThreadPool305-4927] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:8 sharding:101_668808 time:189.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,265 INFO [autoConfirmThreadPool210-2912] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:0 sharding:101_668810 time:196.8 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,269 INFO [autoConfirmThreadPool39-1042] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:5 sharding:101_668815 time:196.9 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,276 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2086-6552] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:0 time:207.1 ms 2019-07-06 16:33:53,282 INFO [autoConfirmThreadPool95-1098] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:3 sharding:101_668813 time:211.9 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,286 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2089-6555] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:3 time:216.5 ms 2019-07-06 16:33:53,291 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2091-6557] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:5 time:219.1 ms 2019-07-06 16:33:53,303 INFO [autoConfirmThreadPool127-2562] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:6 sharding:101_668816 time:230.0 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,308 INFO [autoConfirmThreadPool180-2874] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:2 sharding:101_668812 time:238.1 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,308 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2092-6558] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:6 time:234.8 ms 2019-07-06 16:33:53,308 INFO [autoConfirmThreadPool283-4905] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:4 sharding:101_668814 time:237.3 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,308 INFO [autoConfirmThreadPool287-4909] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:7 sharding:101_668817 time:234.6 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,314 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2088-6554] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:2 time:244.2 ms 2019-07-06 16:33:53,315 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2090-6556] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:4 time:243.9 ms 2019-07-06 16:33:53,315 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2093-6559] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:7 time:241.3 ms 2019-07-06 16:33:53,337 INFO [autoConfirmThreadPool13-1016] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:8 sharding:101_668818 time:262.0 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,339 INFO [autoConfirmThreadPool313-4935] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:9 sharding:101_668819 time:256.4 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,347 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2094-6560] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:8 time:271.7 ms 2019-07-06 16:33:53,349 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2095-6561] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:9 time:265.8 ms 2019-07-06 16:33:53,345 INFO [autoConfirmThreadPool246-2941] Class=[com.frxs.trade.core.service.service.impl.AutoConfirmDeliveryServiceImpl] 自动确认收货成功 item:1 sharding:101_668811 time:280.7 ms minDate:2019-07-02 00:00:00 maxDate:2019-07-04 23:59:59 limitNum:50 fetchCount:0 2019-07-06 16:33:53,358 INFO [inner-job-trade-area-elastic-job.autoConfirmDeliveryJobName-2087-6553] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.AutoConfirmDeliveryJob] 自动确认收货 任务完成 item:1 time:288.6 ms 2019-07-06 16:33:55,381 INFO [pool-52-thread-1-591] Class=[com.frxs.trade.area.biz.event.schedule.nativejob.AreaScheduled] 刷新区域缓存完成... ``` ### relevant ``` java 2019-07-06 10:44:55,112 ERROR [tradeDataSynThreadPool20-678] Class=[com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess] 佌º佟~_录°彍®佐~L步 录°彍®壾D潐~F失败 areaId:101, data:[{"address":"䷾J海巾B轗µ蠾L佌º31232133 213222","amount":{"amount":0.01,"cent":1,"centFactor":100,"currency":"CNY"},"areaId":101,"areaName":"渾V位~W佌º佟~_","billOfLading":5,"clientType":"MINI_PROGRAM","itemList":[{"afterSalePeriod":"48.00","afterSalePeriodMeasure":"彗¶","areaa Id":101,"commission":{"amount":0.01,"cent":1,"centFactor":100,"currency":"CNY"},"deliveryTime":1562572800000,"directMining":false,"distributionClerkId":0,"expiryDateEnd":1562515200000,"expiryDateStart":1562229052000,"getProduct":false,"itemAdjustedPrice":{"amount":0.02,"cent":2,"centFactor":100,"currency":"CNY"},"itemDescription":"佔~P佂~E66 佔~P佂~E","itemListPrice":{"amount":11.00,"cent":1100,"centFactor":100,"currency":"CNY"},"lineId":1192,"lineName":"toomy派K设U线路",, "lineSort":0,"logisticsAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"orderId":"190706001101061000068356","packingNumber":11.0,"platformAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"presaleActivityId":93646,"presaleQty":1111.0,"productId":111250,"productName":"佔~P佂~E66","productPriceId":0,"productType":"CHOICE","promotionAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"qty":1.0,"shipmentQty":0.0,"sku":"0111250","skuContent"" :"佔~P佂~E","stockOut":false,"storageAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"storeId":0,"subOrderId":"19070600210106100000142584","supplyPrice":{"amount":0.01,"cent":1,"centFactor":100,"currency":"CNY"},"thumbnailsUU rl":"http://frxs-devevn2018.oss-cn-shenzhen.aliyuncs.com/productMainImg/20180911/100percent_5ef4f723-4f20-4f29-9377-81699eb7c9241536662746402.jpg","tmCreate":1562381087451,"tmSmp":1562381068000,"unionPayMid":"89843515411621B","userId":568814700004301610,"vendorAddress":"渾V位~W潜~A庠ª洲巾B罍·堾X佌º潛¼潛¼路888住·666.","vendorCode":"1314520","vendorId":76880000030220,"vendorName":"UAT 罐¥轔~@轇~M彞~D-3b修","vendorShortName":"UAT罐¥轔~@轇~M彞~D","vendorTelephonn e":"18684123456","volume":0.0,"warehouseFee":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"warehouseId":10138,"warehouseName":"鹾S谷派K设U亾S䷾@","warehouseType":"CHOICE","weight":0.0}],"logisticsAmt":{"amount":0.00,"cent"" :0,"centFactor":100,"currency":"CNY"},"memberIsShow":true,"openId":"o_-IN5JV1SkhdoHDq8LyxXe8NBxo","orderDate":1562381085000,"orderId":"190706001101061000068356","orderStatus":"PAID","orderTotal":{"amount":0.02,"cent":2,"centFactor":100,"currency":"CNY"},"orderType":"CHOICE","payChannel":"WECHAT","payDate":1562381016000,"payOrder":{"account":false,"areaId":101,"bankOrderId":"3522190706001101061000068356","mchId":"cylly","openId":"o_-IN5JV1SkhdoHDq8LyxXe8NBxo","orderId":"190706001101061000068356","outTradeNo":"3522190706001101061000068356","payRequest":"{\"timeStamp\":\"1562381015872\",\"clientType\":\"MINI_PROGRAM\",\"paySign\":\"5e810b5cb8d04e0f88959ad89417e1cd\",\"bankOrderId\":\"3522190706001101061000068356\",\"appId\":\"wxad73d45ea0efb1c0\",\"signType\":\"RSA\",\"nonceStr\":\"30057026b94b49dea09a605b11dae9c3\"}","payStatus":"HAS_PAY","payTime":1562381016000,"payType":"ONLINE","send":true,"storeId":66880000190163,"tmCreate":1562381069000,"tmSmp":1562381069000,"totalFee":{"amount":0.02,"cent":2,"centFactor":100,"currency":"CNY"},"transactionId":"93a454ecee394011945f70a2bee49878","userId":568814700004301610,"warehouseId":10138,"warehouseName":"鹾S谷派K设U亾S䷾@"},"payType":"ONLINE","paa ymentId":"3522190706001101061000068356","paymentOutId":"93a454ecee394011945f70a2bee49878","phone":"15875542347","platformAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"presale":true,"promotionAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"receiver":"cylly","remark":"","storageAmt":{"amount":0.00,"cent":0,"centFactor":100,"currency":"CNY"},"storeAddress":"䷾J海巾B轗µ蠾L佌º3123213213222","storeId":66880000190163,"storeIsShow":true,"storeNamm e":"家佒¯轘¿巾C潚~D幾W","storeNo":"21196241","storeTel":"18600001132","systemDay":0,"tmCreate":1562381068000,"tmSmp":1562381069000,"totalCommission":{"amount":0.01,"cent":1,"centFactor":100,"currency":"CNY"},"totalQty":1.0,"userId":56888 14700004301610,"userName":"15875542347","valetOrder":false,"warehouseId":10138,"warehouseName":"鹾S谷派K设U亾S䷾@","wechatImage":"https://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTI8uK9MkZL9TwntmXskXwfgXibFTYrplx2mURO8ibYUbxVhakAqHnIuW1RNIE8TLL xmptWwXS6nWa0Fw/132","wechatName":"cylly"}] 2019-07-06 10:44:55,112 WARN [tradeDataSynThreadPool20-678] Class=[com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess] 佌º佟~_录°彍®佐~L步 areaId:101 #ErrorCode:FE02351003999 com.frxs.trade.common.exception.TradeException: FE02351003999=彜ª潟¥廾B常 at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.handleMsg(TradeAreaSubProcess.java:190) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.call(TradeAreaSubProcess.java:101) [trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.call(TradeAreaSubProcess.java:48) [trade-area-core-service-1.0.0.jar!/:1.0.0] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_151] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [?:1.8.0_151] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_151] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151] Caused by: org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is java.sql.SQLException at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:332) ~[spring-jdbc-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.frxs.trade.core.service.msghandler.impl.TradeAreaDataSynServiceImpl.handlerPaid(TradeAreaDataSynServiceImpl.java:146) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.execute(TradeAreaSubProcess.java:210) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.handleMsg(TradeAreaSubProcess.java:178) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] ... 8 more Caused by: java.sql.SQLException at io.shardingjdbc.core.jdbc.adapter.WrapperAdapter.throwSQLExceptionIfNecessary(WrapperAdapter.java:82) ~[sharding-jdbc-core-2.0.3.jar!/:?] at io.shardingjdbc.core.jdbc.adapter.AbstractConnectionAdapter.commit(AbstractConnectionAdapter.java:74) ~[sharding-jdbc-core-2.0.3.jar!/:?] at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCommit(DataSourceTransactionManager.java:329) ~[spring-jdbc-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:152) ~[spring-tx-5.0.7.RELEASE.jar!/:5.0.7.RELEASE] at com.frxs.trade.core.service.msghandler.impl.TradeAreaDataSynServiceImpl.handlerPaid(TradeAreaDataSynServiceImpl.java:146) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.execute(TradeAreaSubProcess.java:210) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] at com.frxs.trade.core.service.processmsg.sub.TradeAreaSubProcess.handleMsg(TradeAreaSubProcess.java:178) ~[trade-area-core-service-1.0.0.jar!/:1.0.0] ... 8 more 2019-07-06 10:44:55,153 INFO [inner-job-trade-area-elastic-job.TradeAreaDataSyncJobName-30-648] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.TradeAreaDataSynJob] 佌º佟~_录°彍®佐~L步 佈~F潉~G:0L纾S彞~\:[{"result":"nothh ing","areaId":110},{"result":"nothing","areaId":115},{"result":"success","areaId":105,"context":["other-success","closed-success","insert-success","paid-success"]}] 罀~W彗¶108.0 ms 2019-07-06 10:44:55,155 INFO [inner-job-trade-area-elastic-job.TradeAreaDataSyncJobName-42-789] Class=[com.frxs.trade.area.biz.event.schedule.elasticjob.TradeAreaDataSynJob] 佌º佟~_录°彍®佐~L步 佈~F潉~G:1L纾S彞~\:[{"result":"nothh ing","areaId":111},{"result":"nothing","areaId":106},{"result":"warning","areaId":101,"context":["closed-success","other-success","insert-success","paid-failed"]}] 罀~W彗¶108.5 ms ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
![http://frxs-devevn2018.oss-cn-shenzhen.aliyuncs.com/productMainImg/20180911/100percent_5ef4f723-4f20-4f29-9377-81699eb7c9241536662746402.jpg","tmCreate":1562381087451,"tmSmp":1562381068000,"unionPayMid":"89843515411621B","userId":568814700004301610,"vendorAddress":"渾V位~W潜~A庠ª洲巾B罍·堾X佌º潛¼潛¼路888住·666.","vendorCode":"1314520","vendorId":76880000030220,"vendorName":"UAT](http://frxs-devevn2018.oss-cn-shenzhen.aliyuncs.com/productMainImg/20180911/100percent_5ef4f723-4f20-4f29-9377-81699eb7c9241536662746402.jpg","tmCreate":1562381087451,"tmSmp":1562381068000,"unionPayMid":"89843515411621B","userId":568814700004301610,"vendorAddress":"渾V位~W潜~A庠ª洲巾B罍·堾X佌º潛¼潛¼路888住·666.","vendorCode":"1314520","vendorId":76880000030220,"vendorName":"UAT){kind=link}