Many connections from ohdsi_admin_user left open on startup
Open
@ssuvorov-fls is already working on this.
Since Sep 27, 2022.
- Dominant language
- Java
- Stars
- 151
- Forks
- 183
- Avg merge
- 14m
- Merged PRs (30d)
- 2
Description
Expected behavior
The ohdsi_admin_user should only open up 1 connection for flyway migrations. This connection should close after migrations are complete.
Actual behavior
10 connections are open (I think as part of a connection pool) and they remain open for the duration of the WebAPI lifetime, but those connections are never used after startup.
Steps to reproduce behavior
- Launch webAPI
- Open pgAdmin4 to view active sessions. Observe the following:
We shouldn't be using connection pools for flyway connections.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.