Я использую Spring Boot 2.16 с Java 8 и Oracle 12C для моего веб -приложения на основе отдыха. Мое веб -приложение работало нормально в течение последних трех лет, но теперь приложение останавливается случайным образом один или два раза в день. Мои настройки Hikari упоминаются ниже: < /p>
spring.datasource.hikari.maximumPoolSize=180
spring.datasource.hikari.idleTimeout=240000
spring.datasource.hikari.poolName=SpringBootHikariCP
spring.datasource.hikari.maxLifetime=290000
spring.datasource.hikari.connectionTimeout=30000
spring.datasource.hikari.keepaliveTime=180000
< /code>
Далее приведен трассировка журнала ошибок, которую я получаю: < /p>
[WARN] 2025-03-12 08:58:31 SpringBootHikariCP - Failed to validate connection oracle.jdbc.driver.T4CConnection@60bd45c5 (IO Error: Invalid Operation, NOT Connected). Possibly consider using a shorter maxLifetime value.
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Pool stats (total=59, active=31, idle=28, waiting=0)
[WARN] 2025-03-12 08:58:42 SpringBootHikariCP - Failed to validate connection oracle.jdbc.driver.T4CConnection@7a362095 (IO Error: Invalid Operation, NOT Connected). Possibly consider using a shorter maxLifetime value.
[WARN] 2025-03-12 08:58:42 SpringBootHikariCP - Failed to validate connection oracle.jdbc.driver.T4CConnection@15cc6c8e (IO Error: Invalid Operation, NOT Connected). Possibly consider using a shorter maxLifetime value.
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Timeout failure stats (total=57, active=28, idle=29, waiting=0)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Timeout failure stats (total=57, active=28, idle=29, waiting=0)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Closing connection oracle.jdbc.driver.T4CConnection@7a362095: (connection is dead)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Timeout failure stats (total=56, active=30, idle=26, waiting=0)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Closing connection oracle.jdbc.driver.T4CConnection@15cc6c8e: (connection is dead)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Closing connection oracle.jdbc.driver.T4CConnection@116e0996: (connection was evicted)
[DEBUG] 2025-03-12 08:58:42 SpringBootHikariCP - Closing connection oracle.jdbc.driver.T4CConnection@60bd45c5: (connection is dead)
java.sql.SQLTransientConnectionException: SpringBootHikariCP - Connection is not available, request timed out after 32630ms.
at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:676)
Подробнее здесь: https://stackoverflow.com/questions/795 ... -connected
