HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999)

Question

HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999)
java.sql.SQLNonTransientConnectionException: Communication link failure. (Read timed out)

I kept getting this problem, when creating a table with data, which was about 6million records. On ACS, an sql developer, it took around 1½ minute.

score 31 · Accepted Answer · answered Feb 21 '19 at 10:02

31

I found out that default connection validation (spring.datasource.hikari.validationTimeout) was set to 5000 (5 seconds).
This lead to hikari, not being able to validate the connection, because it was busy for long time. Solution was setting this property to a high enough number (i set it to 5minutes - 300000)

answered Feb 21 '19 at 10:02

Anders Metnik

6,096
7
40
79

3

Thanks alot, it took 30 mins to resolve. At last got your solution, it helped me. – Vasantha Kumar Boddu Feb 05 '21 at 12:14
3

Complementing the answer, in order to do what @Anders suggested you just need to add this key `spring.datasource.hikari.validationTimeout=300000` to your application properties file – fabriciorissetto Jul 09 '21 at 17:48
1

Simple and precise answer. Thanks man – Andrew Mititi Feb 27 '22 at 06:28

HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999)

1 Answers1