1

I've faced with the problem when Java Service (HikariCP+JDBC+Oracle, pool=10) has big transaction which includes DB operations and external Services calls, during running this transaction Hikari reserves connection (at least shows it via JMX) until transaction is finished. As trasaction is long due to Service calls (it's not possible to exclude it from transaction, I've already minimized timeout) active connection is reserved for too long, it blocks all Service.

Threads are blocked on getConnection().

The main thing here is that Active connection is only on Hikari but not on Oracle side, Oracle shows it as inactive. E.g. Hikari is wasting connection as in reality it's not doing anything with DB.

Is there any configuration in Hikari to resolve this issue? Or maybe some pattern how to avoid it?

Yaro
  • 614
  • 6
  • 13
  • See if my previous answer helps https://stackoverflow.com/questions/58917381/spring-boot-reconnect-to-a-database-after-its-restart/58927579#58927579 – Ori Marko Jan 09 '20 at 12:36
  • Thank you for link, but it's another story. Reconnection to DB is expensive, hence prefer to have a static connection pool. The next thing is solving different issues, you suggest just to cut it, but my question is to reuse it when it's not in real use. – Yaro Jan 14 '20 at 13:00
  • by `setMaxLifetime` you mark it for reuse after X seconds when not in real use – Ori Marko Jan 14 '20 at 13:02

1 Answers1

1

After updating Hikari to the latest version it was resolved (there were a few releases where it was mentioned fixes for threads issue), additionally to be on the safe side maxLifetime has been set on our side, works ok for now.

Yaro
  • 614
  • 6
  • 13