search

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.
Apache License 2.0
20.04k stars 2.94k forks source link

T4CConnection@55088667 marked as broken because of SQLSTATE(08006), ErrorCode(17002) java.sql.SQLRecoverableException: IO Error: Connection timed out #1860

Open BilgehanYildiz opened 3 years ago

BilgehanYildiz commented 3 years ago

I use hikaridatasource and ojdbc10 to connect and query my spring jpa queries.Sometimes we face this issue.And after restart our application it fixed.Do you have any comments

15:14:20.952 [https-jsse-nio-8080-exec-5] WARN c.z.hikari.pool.ProxyConnection - MyHikariPool - Connection oracle.jdbc.driver.T4CConnection@55088667 marked as broken because of SQLSTATE(08006), ErrorCode(17002) java.sql.SQLRecoverableException: IO Error: Connection timed out at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:821) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) at org.hibernate.loader.Loader.getResultSet(Loader.java:2304) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2057) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2019) at org.hibernate.loader.Loader.doQuery(Loader.java:948) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) at org.hibernate.loader.Loader.doList(Loader.java:2850) at org.hibernate.loader.Loader.doList(Loader.java:2832) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2664) at org.hibernate.loader.Loader.list(Loader.java:2659) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:338) at org.hibernate.internal.SessionImpl.listCustomQuery(SessionImpl.java:2141) at org.hibernate.internal.AbstractSharedSessionContract.list(AbstractSharedSessionContract.java:1163) at org.hibernate.query.internal.NativeQueryImpl.doList(NativeQueryImpl.java:176) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1593)

lazycloud commented 2 years ago

Did you solove the problem? I meet the same question as you.i doubt that whether is the firewalld problem.But I'm not sure.

ghost commented 1 year ago

Have you solved the problem？

BilgehanYildiz commented 1 year ago

Use persistancecontext with entitymanager solve my case in spring jpa regards