search

brettwooldridge / HikariCP

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

Bug: Hikari - Connection pool problems #2141

Closed scalex000 closed 10 months ago

scalex000 commented 10 months ago

Hi!

I'm using spring boot 2.5.6 with hikari version 4.0.3. Sometimes I need to kill the process. When I go to the log file I only can see a repeat message and the job not end.

12:11:59.442 [main] DEBUG com.zaxxer.hikari.HikariConfig - Job- configuration: 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension................................false 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit................................true 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - catalog................................none 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql................................none 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery................................none 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout................................30000 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource................................none 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName................................"oracle.jdbc.pool.OracleDataSource" 12:11:59.445 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI................................none 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties................................{URL=jdbc:oracle:thin:@9.9.9.9:1521:DB, user=, password=} 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName................................none 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - exceptionOverrideClassName................................none 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties................................{} 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry................................none 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout................................600000 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailTimeout................................1 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries................................false 12:11:59.446 [main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - keepaliveTime................................0 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold................................0 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime................................1800000 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize................................10 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle................................10 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - password................................ 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - poolName................................"Job" 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly................................false 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans................................false 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutor................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - schema................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory................................internal 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation................................default 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - username................................none 12:11:59.447 [main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout................................5000

19:45:42.487 [JobClass housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - JobClass- Pool stats (total=10, active=0, idle=10, waiting=0) . . . .

20:14:33.049 [JobClas connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - JobClass- Closing connection oracle.jdbc.driver.T4CConnection@316de1b5: (connection has passed maxLifetime) 20:14:33.097 [JobClass connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - JobClass - Added connection oracle.jdbc.driver.T4CConnection@5ffe55cb

scalex000 commented 10 months ago

No need actions. False alarm.