Issue: Active connections in the connection pool not getting released in Deploy

Issue

The connections are never returned to the pool unless the application restarted.

Affected Products & Versions

Deploy 22.2.3, 23.1.9, 23.3.2

Note that although specifically tested on these versions, there could be potential impacts on lower versions within the 22.2.x, 23.1.x, 23.3.x series.

Steps to Recreate

1. Enable additional logging on the HikariCP library by following the instructions in How to: Enable extra logging in HikariCP for Deploy
2. Set the artifact storage as 'db'
3. Create a CI file
4. Perform a rescan of the artifact several times
5. Examine the Hikari logs, where you'll observe that the connections are not being released

Workaround/Resolution Action

This issue is fixed in the following versions of Deploy:

• 23.1.10
• 23.3.3
• 24.1.0

Considerations

Internal Reference Ticket: D-31833