URGENT ISSUE - Failed to create/setup connection: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset ClientConnectionId:ebd0ff64-b053-4919-b90d-6a43ec79f25f"

[satscreate]

Driver version

<mssql-jdbc.version>6.2.2.jre8</mssql-jdbc.version>
mssql-jdbc-6.2.2.jre8

SQL Server version

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64) Oct 19 2012 13:38:57 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: )

Client Operating System

Windows 10

JAVA/JVM version

jdk1.8.0_202

Problem description

1. Expected behaviour:
   The new connection should be enabled in the Hikari spring setup.

2. Actual behaviour:
   Hikari pool connection dropped from max to 0 one by one at some point (it happens every two or three days once). And finally when it reaches HikariPool-1 - Pool stats (total=0, active=0, idle=0, waiting=0) then i see below exception.

3. Error message/stack trace:
   At this time 2019-08-06 05:22:03.653 application instance killed. not sure what reason but i can see the restart script started after that time.

2019-08-06 04:38:33.548  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
---
--ommited - log shows Pool stats (total=49, active=0, idle=50, waiting=0)  & Pool stats (total=48, active=0, idle=50, waiting=0) like that
---
2019-08-06 05:00:17.820  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31360 ClientConnectionId: c1d8fa33-48a4-4510-b9da-bc128ea7e81a: (connection has passed maxLifetime)
2019-08-06 05:00:33.602  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=0, active=0, idle=0, waiting=0)
2019-08-06 05:01:03.604  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=0, active=0, idle=0, waiting=0)
2019-08-06 05:01:04.975  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Failed to create/setup connection: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset ClientConnectionId:ebd0ff64-b053-4919-b90d-6a43ec79f25f".
2019-08-06 05:01:04.975  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Cannot acquire connection from data source
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset ClientConnectionId:ebd0ff64-b053-4919-b90d-6a43ec79f25f".
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2435)
	at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1816)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2022)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1687)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1528)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:866)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:569)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:136)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:369)
	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:198)
	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:467)
	at com.zaxxer.hikari.pool.HikariPool.access$100(HikariPool.java:71)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:706)
	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:692)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.IOException: Connection reset ClientConnectionId:ebd0ff64-b053-4919-b90d-6a43ec79f25f
	at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:763)
	at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:830)
	at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:821)
	at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:1003)
	at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:991)
	at sun.security.ssl.InputRecord.readFully(InputRecord.java:465)
	at sun.security.ssl.InputRecord.read(InputRecord.java:503)
	at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:975)
	at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1367)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1395)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1379)
	at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1753)
	... 16 common frames omitted
2019-08-06 05:01:05.320  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31362 ClientConnectionId: c83b216a-418d-43ae-885f-6d6ccb52b0e0
2019-08-06 05:01:05.423  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31363 ClientConnectionId: f29a6b5f-0137-4720-9559-850addd4ab2e
2019-08-06 05:01:05.423  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=2, active=0, idle=2, waiting=0)
2019-08-06 05:01:05.521  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31364 ClientConnectionId: 1e0fa1c5-f2ff-4a5e-8f9a-c6adc67ca100
2019-08-06 05:01:05.521  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=3, active=1, idle=2, waiting=0)
2019-08-06 05:01:05.619  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31365 ClientConnectionId: 9f16187a-1589-469e-8bb5-7088cd7f27dc
2019-08-06 05:01:05.619  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=4, active=1, idle=3, waiting=0)
2019-08-06 05:01:05.746  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31366 ClientConnectionId: d0c3ec0b-b70f-440d-9b54-30faf6f8a9b5
2019-08-06 05:01:05.746  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=5, active=1, idle=4, waiting=0)
2019-08-06 05:01:05.841  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31367 ClientConnectionId: a7c64604-f205-4496-981c-031e3a158eeb
2019-08-06 05:01:05.841  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=6, active=1, idle=5, waiting=0)
2019-08-06 05:01:06.003  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31368 ClientConnectionId: 0833ab11-99ed-4262-91c7-9bddcd2557f7
2019-08-06 05:01:06.003  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=7, active=1, idle=6, waiting=0)
2019-08-06 05:01:06.213  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31369 ClientConnectionId: 1d9f6fe2-8c45-4159-beeb-40dfe01ec7c9
2019-08-06 05:01:06.213  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=8, active=1, idle=7, waiting=0)
2019-08-06 05:01:06.319  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31370 ClientConnectionId: 8082699b-6a84-47a7-88b6-e64534c12e4a
2019-08-06 05:01:06.319  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=9, active=1, idle=8, waiting=0)
2019-08-06 05:01:06.499  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31371 ClientConnectionId: c1a17ecc-130e-48f7-bcf4-be01a17d4456
2019-08-06 05:01:06.499  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=10, active=1, idle=9, waiting=0)
2019-08-06 05:01:06.599  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31372 ClientConnectionId: 706c38f3-859e-4bfd-87db-4dd5557a0b95
2019-08-06 05:01:06.599  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=11, active=1, idle=10, waiting=0)
2019-08-06 05:01:06.693  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31373 ClientConnectionId: 5f6e0bf6-1e25-45e4-b7a7-caf8bb6fbc73
2019-08-06 05:01:06.693  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=12, active=1, idle=11, waiting=0)
2019-08-06 05:01:06.798  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31374 ClientConnectionId: 243b1783-2eb5-4cfd-a65a-64354a75e01b
2019-08-06 05:01:06.798  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=13, active=0, idle=13, waiting=0)
2019-08-06 05:01:06.922  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31375 ClientConnectionId: fb008353-f4f6-456a-a0dc-2882a0f454c5
2019-08-06 05:01:06.922  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=14, active=0, idle=14, waiting=0)
2019-08-06 05:01:07.066  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31376 ClientConnectionId: 90f29825-e69d-4303-b50e-09d4cb2a37f6
2019-08-06 05:01:07.066  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=15, active=0, idle=15, waiting=0)
2019-08-06 05:01:07.253  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31377 ClientConnectionId: dd8f122a-c0ce-4144-be48-c6f8191c14fa
2019-08-06 05:01:07.253  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=16, active=0, idle=16, waiting=0)
2019-08-06 05:01:07.431  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31378 ClientConnectionId: 2299cf6d-ec38-4007-8b84-dd8ccee9c3f3
2019-08-06 05:01:07.431  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=17, active=0, idle=17, waiting=0)
2019-08-06 05:01:07.617  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31379 ClientConnectionId: 686edf43-2d38-40c2-83f8-f2b3ad02f629
2019-08-06 05:01:07.617  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=18, active=0, idle=18, waiting=0)
2019-08-06 05:01:07.798  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31380 ClientConnectionId: c0393dae-c36e-4550-844b-cad1ddd3d182
2019-08-06 05:01:07.798  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=19, active=0, idle=19, waiting=0)
2019-08-06 05:01:08.009  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31381 ClientConnectionId: 69225940-a416-4b9f-a9a6-c0003ae602b4
2019-08-06 05:01:08.009  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=20, active=0, idle=20, waiting=0)
2019-08-06 05:01:08.201  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31382 ClientConnectionId: 643b68d4-1d5e-44b6-8971-fbdf82ea91dd
2019-08-06 05:01:08.201  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=21, active=0, idle=21, waiting=0)
2019-08-06 05:01:08.285  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31383 ClientConnectionId: 23b37a7d-f487-4433-9e8b-bbab68479afa
2019-08-06 05:01:08.285  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=22, active=0, idle=22, waiting=0)
2019-08-06 05:01:08.424  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31384 ClientConnectionId: bafc049a-9644-495c-9a13-9baf185e70d3
2019-08-06 05:01:08.424  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=23, active=0, idle=23, waiting=0)
2019-08-06 05:01:08.533  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31385 ClientConnectionId: d62129bb-6450-4734-9388-943bd9268471
2019-08-06 05:01:08.533  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=24, active=0, idle=24, waiting=0)
2019-08-06 05:01:08.642  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31386 ClientConnectionId: 667781f7-f5e9-4106-9c1d-10c1c189ae69
2019-08-06 05:01:08.642  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=25, active=0, idle=25, waiting=0)
2019-08-06 05:01:08.738  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31387 ClientConnectionId: cfd4dafb-4a47-4d66-8cef-509946600bb6
2019-08-06 05:01:08.738  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=26, active=0, idle=26, waiting=0)
2019-08-06 05:01:08.822  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31388 ClientConnectionId: 25ec0614-4386-46f5-92bf-9959d881b924
2019-08-06 05:01:08.822  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=27, active=0, idle=27, waiting=0)
2019-08-06 05:01:08.910  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31389 ClientConnectionId: d2181a28-4a70-4ca7-ac05-b0cd7a780a74
2019-08-06 05:01:08.910  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=28, active=0, idle=28, waiting=0)
2019-08-06 05:01:08.998  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31390 ClientConnectionId: 8e03807f-0588-40a5-a45e-270c3e4f6974
2019-08-06 05:01:08.998  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=29, active=0, idle=29, waiting=0)
2019-08-06 05:01:09.096  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31391 ClientConnectionId: 1d9cc0c0-13a1-44bd-b19e-007f5f03966d
2019-08-06 05:01:09.096  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=30, active=0, idle=30, waiting=0)
2019-08-06 05:01:09.189  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31392 ClientConnectionId: dae2d64c-7834-4905-92b8-14975b4db7e3
2019-08-06 05:01:09.189  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=31, active=0, idle=31, waiting=0)
2019-08-06 05:01:09.288  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31393 ClientConnectionId: 5c892bba-37a5-42b2-8784-7c9ecf553a04
2019-08-06 05:01:09.288  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=32, active=0, idle=32, waiting=0)
2019-08-06 05:01:09.396  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31394 ClientConnectionId: cc268eae-3330-4f93-9937-b2cfb8d33299
2019-08-06 05:01:09.396  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=33, active=0, idle=33, waiting=0)
2019-08-06 05:01:09.496  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31395 ClientConnectionId: 0d3d1a15-6fa3-4d82-9e3a-7214fa9dbbb9
2019-08-06 05:01:09.496  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=34, active=0, idle=34, waiting=0)
2019-08-06 05:01:09.596  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31396 ClientConnectionId: 1fe9e8a4-3f14-4bba-9df2-9ce76a85aceb
2019-08-06 05:01:09.596  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=35, active=0, idle=35, waiting=0)
2019-08-06 05:01:09.710  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31397 ClientConnectionId: 14cf3b30-cd6d-40c5-af08-bbb7ad06e5a0
2019-08-06 05:01:09.710  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=36, active=0, idle=36, waiting=0)
2019-08-06 05:01:09.800  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31398 ClientConnectionId: 7d635853-c3af-4894-aafb-f7ac7e8f9f88
2019-08-06 05:01:09.800  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=37, active=0, idle=37, waiting=0)
2019-08-06 05:01:09.886  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31399 ClientConnectionId: 639ad0a2-a17b-4df5-b828-dcf398582a62
2019-08-06 05:01:09.886  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=38, active=0, idle=38, waiting=0)
2019-08-06 05:01:10.028  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31400 ClientConnectionId: 4e00d504-dec4-4e4e-8000-d1d5f1303af0
2019-08-06 05:01:10.028  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=39, active=0, idle=39, waiting=0)
2019-08-06 05:01:10.155  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31401 ClientConnectionId: a703a3fe-9f8a-48be-b358-2c74fd06388f
2019-08-06 05:01:10.155  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=40, active=0, idle=40, waiting=0)
2019-08-06 05:01:10.236  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31402 ClientConnectionId: a1fa3a8e-e86f-4598-8359-75a5c3c503f3
2019-08-06 05:01:10.236  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=41, active=0, idle=41, waiting=0)
2019-08-06 05:01:10.331  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31403 ClientConnectionId: 840ce857-b1fa-4310-8481-8dffd1782306
2019-08-06 05:01:10.331  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=42, active=0, idle=42, waiting=0)
2019-08-06 05:01:10.486  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31404 ClientConnectionId: 2a7b596e-c24e-4822-8c1a-1e4893cdbb9d
2019-08-06 05:01:10.486  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=43, active=0, idle=43, waiting=0)
2019-08-06 05:01:10.622  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31405 ClientConnectionId: a43653df-2500-4cb9-a9a4-65c6de394248
2019-08-06 05:01:10.622  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=44, active=0, idle=44, waiting=0)
2019-08-06 05:01:10.741  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31406 ClientConnectionId: eec68841-6ca6-4fdb-b587-5e8e6ca03e3f
2019-08-06 05:01:10.741  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=45, active=0, idle=45, waiting=0)
2019-08-06 05:01:10.885  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31407 ClientConnectionId: 99174bbc-f976-4b79-845e-37c22844ced1
2019-08-06 05:01:10.885  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=46, active=0, idle=46, waiting=0)
2019-08-06 05:01:11.024  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31408 ClientConnectionId: b7ab2258-6fc3-42c3-84f7-5eac0ed1f1a6
2019-08-06 05:01:11.024  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=47, active=0, idle=47, waiting=0)
2019-08-06 05:01:11.165  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31409 ClientConnectionId: 90790334-c7af-4ee4-ae09-0f2ad7bd27e5
2019-08-06 05:01:11.165  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=48, active=0, idle=48, waiting=0)
2019-08-06 05:01:11.287  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31410 ClientConnectionId: e66d3253-5a25-4d86-b8e8-9abbf27b0885
2019-08-06 05:01:11.287  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=49, active=0, idle=49, waiting=0)
2019-08-06 05:01:11.390  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31411 ClientConnectionId: fe00aad2-5616-4c33-b9da-5eabbb9e6caa
2019-08-06 05:01:11.390  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:01:33.605  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:02:03.606  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:02:33.607  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:03:03.608  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
--OMMITED SAME LINE
2019-08-06 05:20:33.649  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:37.785  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31378 ClientConnectionId: 2299cf6d-ec38-4007-8b84-dd8ccee9c3f3: (connection has passed maxLifetime)
2019-08-06 05:20:37.929  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31412 ClientConnectionId: b2ab1b9a-69ba-4807-b657-a8f79241ac72
2019-08-06 05:20:41.553  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31380 ClientConnectionId: c0393dae-c36e-4550-844b-cad1ddd3d182: (connection has passed maxLifetime)
2019-08-06 05:20:41.638  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31413 ClientConnectionId: 1c5f2dac-2f0c-4081-acc9-270c061bfcb4
2019-08-06 05:20:42.263  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31363 ClientConnectionId: f29a6b5f-0137-4720-9559-850addd4ab2e: (connection has passed maxLifetime)
2019-08-06 05:20:42.363  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31414 ClientConnectionId: 1798f202-5219-49ee-8827-d0c83a6beb7d
2019-08-06 05:20:42.461  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31401 ClientConnectionId: a703a3fe-9f8a-48be-b358-2c74fd06388f: (connection has passed maxLifetime)
2019-08-06 05:20:42.544  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31415 ClientConnectionId: 77b31897-6844-492d-8f6a-decd428eb370
2019-08-06 05:20:42.565  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31391 ClientConnectionId: 1d9cc0c0-13a1-44bd-b19e-007f5f03966d: (connection has passed maxLifetime)
2019-08-06 05:20:42.648  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31416 ClientConnectionId: 58761f01-995c-404f-874c-22464e8bc2bb
2019-08-06 05:20:42.670  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31411 ClientConnectionId: fe00aad2-5616-4c33-b9da-5eabbb9e6caa: (connection has passed maxLifetime)
2019-08-06 05:20:42.757  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31417 ClientConnectionId: a07a5209-5543-4285-bfb0-aeb57ea6b8fc
2019-08-06 05:20:43.006  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31389 ClientConnectionId: d2181a28-4a70-4ca7-ac05-b0cd7a780a74: (connection has passed maxLifetime)
2019-08-06 05:20:43.027  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31396 ClientConnectionId: 1fe9e8a4-3f14-4bba-9df2-9ce76a85aceb: (connection has passed maxLifetime)
2019-08-06 05:20:43.083  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31408 ClientConnectionId: b7ab2258-6fc3-42c3-84f7-5eac0ed1f1a6: (connection has passed maxLifetime)
2019-08-06 05:20:43.086  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31364 ClientConnectionId: 1e0fa1c5-f2ff-4a5e-8f9a-c6adc67ca100: (connection has passed maxLifetime)
2019-08-06 05:20:43.089  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31418 ClientConnectionId: 159ceeec-882b-4b67-9f0c-7d6855711f61
2019-08-06 05:20:43.224  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31419 ClientConnectionId: cf139142-423c-4be6-87b7-d469e4774419
2019-08-06 05:20:43.224  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=48, active=0, idle=48, waiting=0)
2019-08-06 05:20:43.308  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31420 ClientConnectionId: 60abd6f2-3f69-4d73-a03a-40cbad8a9eb3
2019-08-06 05:20:43.308  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=49, active=0, idle=49, waiting=0)
2019-08-06 05:20:43.425  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31421 ClientConnectionId: 3f7adacc-a331-498d-81f2-e5acef375ebd
2019-08-06 05:20:43.425  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:44.443  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31385 ClientConnectionId: d62129bb-6450-4734-9388-943bd9268471: (connection has passed maxLifetime)
2019-08-06 05:20:44.528  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31422 ClientConnectionId: b601bc5e-4035-41de-b301-fd636b4222bb
2019-08-06 05:20:44.621  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31371 ClientConnectionId: c1a17ecc-130e-48f7-bcf4-be01a17d4456: (connection has passed maxLifetime)
2019-08-06 05:20:44.672  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31362 ClientConnectionId: c83b216a-418d-43ae-885f-6d6ccb52b0e0: (connection has passed maxLifetime)
2019-08-06 05:20:44.705  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31423 ClientConnectionId: 32e33289-5134-4c89-879a-25ff09f2e44b
2019-08-06 05:20:44.801  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31424 ClientConnectionId: 0d2053fb-a0f7-4aba-90e5-219057b5a440
2019-08-06 05:20:44.801  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:44.921  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31405 ClientConnectionId: a43653df-2500-4cb9-a9a4-65c6de394248: (connection has passed maxLifetime)
2019-08-06 05:20:45.015  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31425 ClientConnectionId: f9772c30-213e-49c9-b6eb-e674449fb9d6
2019-08-06 05:20:45.091  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31366 ClientConnectionId: d0c3ec0b-b70f-440d-9b54-30faf6f8a9b5: (connection has passed maxLifetime)
2019-08-06 05:20:45.191  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31426 ClientConnectionId: 5d8e0099-f316-4d8d-bb8b-c9aa06735915
2019-08-06 05:20:46.355  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31403 ClientConnectionId: 840ce857-b1fa-4310-8481-8dffd1782306: (connection has passed maxLifetime)
2019-08-06 05:20:46.485  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31427 ClientConnectionId: bf7a40b1-2b56-4bcf-9860-e08265c40858
2019-08-06 05:20:46.656  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31406 ClientConnectionId: eec68841-6ca6-4fdb-b587-5e8e6ca03e3f: (connection has passed maxLifetime)
2019-08-06 05:20:46.751  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31428 ClientConnectionId: c54a0148-6033-405d-8b46-3f430d1d683b
2019-08-06 05:20:48.437  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31375 ClientConnectionId: fb008353-f4f6-456a-a0dc-2882a0f454c5: (connection has passed maxLifetime)
2019-08-06 05:20:48.565  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31429 ClientConnectionId: 85f9820c-de6e-4f7f-9234-396604659272
2019-08-06 05:20:48.889  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31410 ClientConnectionId: e66d3253-5a25-4d86-b8e8-9abbf27b0885: (connection has passed maxLifetime)
2019-08-06 05:20:49.019  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31430 ClientConnectionId: 9be9d17d-e71e-47be-b003-b13c66810ced
2019-08-06 05:20:49.061  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31373 ClientConnectionId: 5f6e0bf6-1e25-45e4-b7a7-caf8bb6fbc73: (connection has passed maxLifetime)
2019-08-06 05:20:49.119  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31404 ClientConnectionId: 2a7b596e-c24e-4822-8c1a-1e4893cdbb9d: (connection has passed maxLifetime)
2019-08-06 05:20:49.154  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31431 ClientConnectionId: 18b30505-e76c-422e-94d0-205d72fa7c4d
2019-08-06 05:20:49.270  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31432 ClientConnectionId: ad108ed4-4f5c-47a9-b8ab-8d7c4da83831
2019-08-06 05:20:49.270  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:49.586  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31368 ClientConnectionId: 0833ab11-99ed-4262-91c7-9bddcd2557f7: (connection has passed maxLifetime)
2019-08-06 05:20:49.679  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31433 ClientConnectionId: 1b72a56b-f404-4bd5-ab78-9da72a0cfd35
2019-08-06 05:20:49.772  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31381 ClientConnectionId: 69225940-a416-4b9f-a9a6-c0003ae602b4: (connection has passed maxLifetime)
2019-08-06 05:20:49.864  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31434 ClientConnectionId: e3390da5-cb67-443a-bc28-dd832ac54f6a
2019-08-06 05:20:50.452  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31395 ClientConnectionId: 0d3d1a15-6fa3-4d82-9e3a-7214fa9dbbb9: (connection has passed maxLifetime)
2019-08-06 05:20:50.543  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31435 ClientConnectionId: 3f04155a-4bba-41c8-9ea7-6fc03f2c67cf
2019-08-06 05:20:50.612  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31407 ClientConnectionId: 99174bbc-f976-4b79-845e-37c22844ced1: (connection has passed maxLifetime)
2019-08-06 05:20:50.687  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31370 ClientConnectionId: 8082699b-6a84-47a7-88b6-e64534c12e4a: (connection has passed maxLifetime)
2019-08-06 05:20:50.717  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31436 ClientConnectionId: 40d833e8-b83b-4591-948c-366e4f308adc
2019-08-06 05:20:50.784  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31379 ClientConnectionId: 686edf43-2d38-40c2-83f8-f2b3ad02f629: (connection has passed maxLifetime)
2019-08-06 05:20:50.806  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31437 ClientConnectionId: c1f92688-1524-406c-8e50-b7f268df8a8e
2019-08-06 05:20:50.806  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=49, active=0, idle=49, waiting=0)
2019-08-06 05:20:50.896  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31438 ClientConnectionId: 64182631-f791-4cae-90d1-8a5ef6dd705d
2019-08-06 05:20:50.896  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:51.464  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31367 ClientConnectionId: a7c64604-f205-4496-981c-031e3a158eeb: (connection has passed maxLifetime)
2019-08-06 05:20:51.571  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31439 ClientConnectionId: 55f37bee-5039-4fc4-9a79-5f1b7e65bc39
2019-08-06 05:20:52.568  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31377 ClientConnectionId: dd8f122a-c0ce-4144-be48-c6f8191c14fa: (connection has passed maxLifetime)
2019-08-06 05:20:52.712  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31440 ClientConnectionId: 565484bc-ea7a-4217-9c40-82ee407bc640
2019-08-06 05:20:52.950  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31386 ClientConnectionId: 667781f7-f5e9-4106-9c1d-10c1c189ae69: (connection has passed maxLifetime)
2019-08-06 05:20:53.042  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31441 ClientConnectionId: 6bf9876b-c08a-4bb3-8357-5e430c04568b
2019-08-06 05:20:54.246  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31394 ClientConnectionId: cc268eae-3330-4f93-9937-b2cfb8d33299: (connection has passed maxLifetime)
2019-08-06 05:20:54.338  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31442 ClientConnectionId: 5d41600f-5865-4fda-a556-c5c02bfcfe0e
2019-08-06 05:20:54.614  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31400 ClientConnectionId: 4e00d504-dec4-4e4e-8000-d1d5f1303af0: (connection has passed maxLifetime)
2019-08-06 05:20:54.706  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31443 ClientConnectionId: 64b589a0-4e7a-4e53-baac-1faac313b05d
2019-08-06 05:20:55.045  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31393 ClientConnectionId: 5c892bba-37a5-42b2-8784-7c9ecf553a04: (connection has passed maxLifetime)
2019-08-06 05:20:55.215  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31444 ClientConnectionId: 2489dcfa-4735-4189-9947-81c1b4d82a9b
2019-08-06 05:20:55.649  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31398 ClientConnectionId: 7d635853-c3af-4894-aafb-f7ac7e8f9f88: (connection has passed maxLifetime)
2019-08-06 05:20:55.678  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31399 ClientConnectionId: 639ad0a2-a17b-4df5-b828-dcf398582a62: (connection has passed maxLifetime)
2019-08-06 05:20:55.745  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31445 ClientConnectionId: c4c65b5d-1235-44fa-93a9-138908415e8b
2019-08-06 05:20:55.844  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31446 ClientConnectionId: 98c43d08-35b6-49a6-9163-88e52707e396
2019-08-06 05:20:55.844  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - After adding stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:20:55.867  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31409 ClientConnectionId: 90790334-c7af-4ee4-ae09-0f2ad7bd27e5: (connection has passed maxLifetime)
2019-08-06 05:20:56.009  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31447 ClientConnectionId: c7dd5fb2-263a-4f67-a400-e40d14ea78f3
2019-08-06 05:20:56.469  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31387 ClientConnectionId: cfd4dafb-4a47-4d66-8cef-509946600bb6: (connection has passed maxLifetime)
2019-08-06 05:20:56.612  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31448 ClientConnectionId: 4b794796-ebc6-43ae-8aac-74c29c6f1d1a
2019-08-06 05:20:58.858  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31384 ClientConnectionId: bafc049a-9644-495c-9a13-9baf185e70d3: (connection has passed maxLifetime)
2019-08-06 05:20:58.948  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31449 ClientConnectionId: 4c990836-956b-40ca-888b-952b58b0d392
2019-08-06 05:20:59.508  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31383 ClientConnectionId: 23b37a7d-f487-4433-9e8b-bbab68479afa: (connection has passed maxLifetime)
2019-08-06 05:20:59.609  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31450 ClientConnectionId: 093d412a-ec27-44fa-9555-51b71b4f0f50
2019-08-06 05:21:00.128  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31372 ClientConnectionId: 706c38f3-859e-4bfd-87db-4dd5557a0b95: (connection has passed maxLifetime)
2019-08-06 05:21:00.249  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31451 ClientConnectionId: 0fa25a84-ea15-445b-a457-4fdb5e555753
2019-08-06 05:21:00.621  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31382 ClientConnectionId: 643b68d4-1d5e-44b6-8971-fbdf82ea91dd: (connection has passed maxLifetime)
2019-08-06 05:21:00.712  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31452 ClientConnectionId: 7699534a-0d12-4c28-b62c-9705e8635686
2019-08-06 05:21:01.492  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31365 ClientConnectionId: 9f16187a-1589-469e-8bb5-7088cd7f27dc: (connection has passed maxLifetime)
2019-08-06 05:21:01.600  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31453 ClientConnectionId: 6db377a0-3566-4c1a-b70c-d5ce674ef386
2019-08-06 05:21:02.999  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31397 ClientConnectionId: 14cf3b30-cd6d-40c5-af08-bbb7ad06e5a0: (connection has passed maxLifetime)
2019-08-06 05:21:03.101  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31454 ClientConnectionId: 4223b613-b18f-4b90-862b-c4cf43dd6de0
2019-08-06 05:21:03.201  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31388 ClientConnectionId: 25ec0614-4386-46f5-92bf-9959d881b924: (connection has passed maxLifetime)
2019-08-06 05:21:03.313  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31455 ClientConnectionId: 719d675d-5a3d-45c4-b366-f59400447baa
2019-08-06 05:21:03.651  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:21:03.651  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31374 ClientConnectionId: 243b1783-2eb5-4cfd-a65a-64354a75e01b: (connection has passed maxLifetime)
2019-08-06 05:21:03.744  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31456 ClientConnectionId: 80d6f28c-d8ce-470f-9847-697dcb58a013
2019-08-06 05:21:04.000  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31376 ClientConnectionId: 90f29825-e69d-4303-b50e-09d4cb2a37f6: (connection has passed maxLifetime)
2019-08-06 05:21:04.100  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31457 ClientConnectionId: f3d63e73-bcd9-4a90-8ed7-ecaae5a979e3
2019-08-06 05:21:04.534  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31369 ClientConnectionId: 1d9f6fe2-8c45-4159-beeb-40dfe01ec7c9: (connection has passed maxLifetime)
2019-08-06 05:21:04.624  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31458 ClientConnectionId: 32cd3c1e-9943-4cfe-8dc4-62fe0d093342
2019-08-06 05:21:07.795  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31392 ClientConnectionId: dae2d64c-7834-4905-92b8-14975b4db7e3: (connection has passed maxLifetime)
2019-08-06 05:21:07.887  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31459 ClientConnectionId: 6657e371-0b1a-4d11-9f07-22cab537de15
2019-08-06 05:21:07.938  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31402 ClientConnectionId: a1fa3a8e-e86f-4598-8359-75a5c3c503f3: (connection has passed maxLifetime)
2019-08-06 05:21:08.056  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31460 ClientConnectionId: f0fcd947-0a42-4e18-be05-38e04eef1307
2019-08-06 05:21:08.498  [HikariPool-1 connection closer] DEBUG com.zaxxer.hikari.pool.PoolBase - HikariPool-1 - Closing connection ConnectionID:31390 ClientConnectionId: 8e03807f-0588-40a5-a45e-270c3e4f6974: (connection has passed maxLifetime)
2019-08-06 05:21:08.588  [HikariPool-1 connection adder] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Added connection ConnectionID:31461 ClientConnectionId: 599d5cdc-288c-434b-a346-1cb7a56f015c
2019-08-06 05:21:33.652  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)
2019-08-06 05:22:03.653  [HikariPool-1 housekeeper] DEBUG com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Pool stats (total=50, active=0, idle=50, waiting=0)

4. Any other details that can be helpful:

JDBC trace logs

let me know , i can add spring TRACE log

Reproduction code

Hikari config: This issue is happening in production, as i see only this trace from the database log,

[main] DEBUG com.zaxxer.hikari.HikariConfig - HikariPool-1 - configuration:
[main] DEBUG com.zaxxer.hikari.HikariConfig - allowPoolSuspension.............false
[main] DEBUG com.zaxxer.hikari.HikariConfig - autoCommit......................true
[main] DEBUG com.zaxxer.hikari.HikariConfig - catalog.........................none
[main] DEBUG com.zaxxer.hikari.HikariConfig - connectionInitSql...............none
[main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTestQuery.............none
[main] DEBUG com.zaxxer.hikari.HikariConfig - connectionTimeout...............40000
[main] DEBUG com.zaxxer.hikari.HikariConfig - dataSource......................none
[main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceClassName.............none
[main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceJNDI..................none
[main] DEBUG com.zaxxer.hikari.HikariConfig - dataSourceProperties............{password=<masked>}
[main] DEBUG com.zaxxer.hikari.HikariConfig - driverClassName................."com.microsoft.sqlserver.jdbc.SQLServerDriver"
[main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckProperties...........{}
[main] DEBUG com.zaxxer.hikari.HikariConfig - healthCheckRegistry.............none
[main] DEBUG com.zaxxer.hikari.HikariConfig - idleTimeout.....................600000
[main] DEBUG com.zaxxer.hikari.HikariConfig - initializationFailTimeout.......1
[main] DEBUG com.zaxxer.hikari.HikariConfig - isolateInternalQueries..........false
[main] DEBUG com.zaxxer.hikari.HikariConfig - jdbcUrl.........................jdbc:sqlserver://sampleip:sampleport;databaseName=sampledb
[main] DEBUG com.zaxxer.hikari.HikariConfig - leakDetectionThreshold..........0
[main] DEBUG com.zaxxer.hikari.HikariConfig - maxLifetime.....................1200000
[main] DEBUG com.zaxxer.hikari.HikariConfig - maximumPoolSize.................50
[main] DEBUG com.zaxxer.hikari.HikariConfig - metricRegistry..................none
[main] DEBUG com.zaxxer.hikari.HikariConfig - metricsTrackerFactory...........none
[main] DEBUG com.zaxxer.hikari.HikariConfig - minimumIdle.....................50
[main] DEBUG com.zaxxer.hikari.HikariConfig - password........................<masked>
[main] DEBUG com.zaxxer.hikari.HikariConfig - poolName........................"HikariPool-1"
[main] DEBUG com.zaxxer.hikari.HikariConfig - readOnly........................false
[main] DEBUG com.zaxxer.hikari.HikariConfig - registerMbeans..................false
[main] DEBUG com.zaxxer.hikari.HikariConfig - scheduledExecutor...............none
[main] DEBUG com.zaxxer.hikari.HikariConfig - schema..........................none
[main] DEBUG com.zaxxer.hikari.HikariConfig - threadFactory...................internal
[main] DEBUG com.zaxxer.hikari.HikariConfig - transactionIsolation............default
[main] DEBUG com.zaxxer.hikari.HikariConfig - username........................"sample"
[main] DEBUG com.zaxxer.hikari.HikariConfig - validationTimeout...............5000
[main] INFO  com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...

[satscreate]

The same has been analyzed by Microsoft and seems the problem still there in latest version... Refer this link
microsoft/mssql-jdbc#1127