Connection reset和could not extract ResultSet

Dear 丶 2022-12-27 08:34 160阅读 0赞

使用一段时间的项目突然报以下错误

[ERROR] [2020-12-09 03:45:20,296] [--JobRunnerPool-thread-41--] [com.alibaba.druid.pool.DruidDataSource]:1437 discard connection 
    java.sql.SQLRecoverableException: IO Error: Connection reset
    	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1067)
    	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1207)
    	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery$original$aZhP6ViW(OraclePreparedStatement.java:3657)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery$original$aZhP6ViW$accessor$u7MbVmJ2(OraclePreparedStatement.java)
    	at oracle.jdbc.driver.OraclePreparedStatement$auxiliary$D1aBoO5d.call(Unknown Source)
    	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
    	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
    	at oracle.jdbc.driver.T4CPreparedStatement.executeQuery$accessor$gjmsQwZf(T4CPreparedStatement.java)
    	at oracle.jdbc.driver.T4CPreparedStatement$auxiliary$0pPTGxfH.call(Unknown Source)
    	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
    	at oracle.jdbc.driver.T4CPreparedStatement.executeQuery(T4CPreparedStatement.java)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery$original$IyDc9F8b(OraclePreparedStatementWrapper.java:1495)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery$original$IyDc9F8b$accessor$8syzjGsT(OraclePreparedStatementWrapper.java)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper$auxiliary$T9qTA2Um.call(Unknown Source)
    	at org.apache.skywalking.apm.agent.core.plugin.interceptor.enhance.InstMethodsInter.intercept(InstMethodsInter.java:86)
    	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java)
    	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:228)
    	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:70)
    	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:434)
    	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:186)
    	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:121)
    	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:86)
    	at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:167)
    	at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4004)
    	at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:508)
    	at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:478)
    	at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:219)
    	at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:278)
    	at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:121)
    	at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:89)
    	at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1218)
    	at org.hibernate.internal.SessionImpl.internalLoad(SessionImpl.java:1101)
    	at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:639)
    	at org.hibernate.type.EntityType.resolve(EntityType.java:431)
    	at org.hibernate.engine.internal.TwoPhaseLoad.doInitializeEntity(TwoPhaseLoad.java:151)
    	at org.hibernate.engine.internal.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:125)
    	at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:1146)
    	at org.hibernate.loader.Loader.processResultSet(Loader.java:1005)
    	at org.hibernate.loader.Loader.doQuery(Loader.java:943)
    	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349)
    	at org.hibernate.loader.Loader.doList(Loader.java:2615)
    	at org.hibernate.loader.Loader.doList(Loader.java:2598)
    	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2430)
    	at org.hibernate.loader.Loader.list(Loader.java:2425)
    	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:502)
    	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:371)
    	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216)
    	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1458)
    	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1426)
    	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1398)
    	at org.hibernate.Query.getResultList(Query.java:417)
    	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:72)
    	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:467)
    	at org.springframework.data.jpa.repository.support.SimpleJpaRepository.findAll(SimpleJpaRepository.java:74)
    	at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:504)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:489)
    	at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    	at com.sun.proxy.$Proxy193.findAll(Unknown Source)
    	at com.eastcom.cams.service.BaseServiceImpl.findList(BaseServiceImpl.java:60)
    	at com.eastcom.cams.service.BaseServiceImpl.findList(BaseServiceImpl.java:29)
    	at sun.reflect.GeneratedMethodAccessor253.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:333)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
    	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    	at com.sun.proxy.$Proxy194.findList(Unknown Source)
    	at com.eastcom.cams.executor.router.ScriptCatalogManager.getCatalogList(ScriptCatalogManager.java:49)
    	at com.eastcom.cams.executor.router.ScriptCatalogManager.getList(ScriptCatalogManager.java:147)
    	at com.eastcom.cams.executor.router.CatalogDispatcher.getList(CatalogDispatcher.java:79)
    	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCatalogTree(CatalogUtils.java:38)
    	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:93)
    	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:102)
    	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCaselogTree(CatalogUtils.java:102)
    	at com.eastcom.cams.executor.processor.utils.CatalogUtils.getCatalogTree(CatalogUtils.java:48)
    	at com.eastcom.cams.executor.processor.AbstractProcessor.getCatalogTree(AbstractProcessor.java:62)
    	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.initDeviceCaseCmd(AbstractParamProcessor.java:204)
    	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.init(AbstractParamProcessor.java:130)
    	at com.eastcom.cams.executor.processor.param.AbstractParamProcessor.processTask(AbstractParamProcessor.java:168)
    	at com.eastcom.cams.executor.JobRunnerImpl.run(JobRunnerImpl.java:34)
    	at com.eastcom.dxframe.executor.runner.JobRunnerDelegate.run(JobRunnerDelegate.java:77)
    	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    	at java.lang.Thread.run(Thread.java:745)
    Caused by: java.net.SocketException: Connection reset
    	at java.net.SocketInputStream.read(SocketInputStream.java:209)
    	at java.net.SocketInputStream.read(SocketInputStream.java:141)
    	at oracle.net.ns.Packet.receive(Packet.java:308)
    	at oracle.net.ns.DataPacket.receive(DataPacket.java:106)
    	at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:324)
    	at oracle.net.ns.NetInputStream.read(NetInputStream.java:268)
    	at oracle.net.ns.NetInputStream.read(NetInputStream.java:190)
    	at oracle.net.ns.NetInputStream.read(NetInputStream.java:107)
    	at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
    	at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
    	at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
    	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
    	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
    	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
    	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
    	... 109 common frames omitted
    [WARN ] [2020-12-09 03:45:20,297] [--JobRunnerPool-thread-41--] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:129 SQL Error: 17002, SQLState: 08006 
    [ERROR] [2020-12-09 03:45:20,298] [--JobRunnerPool-thread-41--] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper]:131 IO Error: Connection reset

异常抛出** discard connection java.sql.SQLRecoverableException: IO Error: Connection reset   大概意思是数据库IO错误，连接重置**

查询资料得知：

当数据库连接池中的连接被创建而长时间不使用的情况下，该连接会自动回收并失效，但客户端并不知道，在进行数据库操作时仍然使用的是无效的数据库连接，这样，就导致客户端程序报“**java.sql.SQLRecoverableException: IO Error: Connection reset**” 或“**java.sql.SQLRecoverableException** 关闭的连接”异常。

有网友给出的避免出现这种情况的方法是

在配置数据源后面加上

配置后，客户端在使用一个无效的连接时会先对该连接进行测试，如果发现该连接已经无效，则重新从连接池获取有效数据库连接来使用。

具体操作参考网友博客 [解决Caused by: java.sql.SQLRecoverableException: IO Error: Connection reset相关问题][Caused by_ java.sql.SQLRecoverableException_ IO Error_ Connection reset]

还有网友建议使用启动时加入以下参数

\-Djava.security.egd=file:/dev/../dev/urandom

具体操作参考网友博客 [JDBC访问Oracle数据库时遇到Connection Reset问题的分析][JDBC_Oracle_Connection Reset]

最简单的应该是扩大数据库连接池的最大、最小、空闲连接数等

还有一个异常

[ERROR] [2020-12-09 03:45:34,083] [--JobRunnerPool-thread-61--] [xxx.param.ParamTaskProcessor]:178 could not extract ResultSet; nested exception is org.hibernate.exception.JDBCConnectionException: could not extract ResultSet 
    org.springframework.dao.DataAccessResourceFailureException: could not extract ResultSet; nested exception is org.hibernate.exception.JDBCConnectionException: could not extract ResultSet
    	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:257)
    	at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244)
    	at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:491)
    	at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
    	at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
    	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57)
    	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    	at com.sun.proxy.$Proxy193.findAll(Unknown Source)
    	..............

**could not extract ResultSet** 这个异常应该是实体类与数据库的字段写法不一致导致的或者是sql中的字段与数据库的不一致，主要检查实体类和数据库字段以及SQL

[Caused by_ java.sql.SQLRecoverableException_ IO Error_ Connection reset]: https://blog.csdn.net/majian_1987/article/details/18598589?utm_medium=distribute.pc_relevant.none-task-blog-searchFromBaidu-1.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-searchFromBaidu-1.control
[JDBC_Oracle_Connection Reset]: https://blog.csdn.net/guodaoying/article/details/52421758?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromBaidu-1.control&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromBaidu-1.control