Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Db connections are left open in pool #6095

Closed
alisihab opened this issue Jan 11, 2024 · 0 comments · Fixed by #6119, #6187, #6199, #6212 or #6233
Closed

Db connections are left open in pool #6095

alisihab opened this issue Jan 11, 2024 · 0 comments · Fixed by #6119, #6187, #6199, #6212 or #6233
Assignees
Milestone

Comments

@alisihab
Copy link
Contributor

alisihab commented Jan 11, 2024

❗ please do not add sensitive information in issues, you can provide extra information via email using issue number as reference ❗

Describe the issue
I use an oracle datasource to call a storedProcedure in oracle database. After some traffic we wait long enough for the connections to be evicted from the pool. However, the connections stay open resulting in oom in db eventually.

This is related to #6078 . However, in this issue the oracle datasource is not transacted. Although i tried making it transacted with narayana result did not change.

// On the other hand, oracle ds did not work with btm.(I wanted to test with btm since it is more stable than narayana atm.)
Apparently, btm+oracle works when oracle is non-xa

I tried setting connectionsArePooled="false" in sender but that did not help. Maybe that setting is no longer works.
Or we leak some resource(stmt, rs) in the framework that keeps the connection open in definitely...

Reporter
Ali

FF: 7.9-RC1-hotfix10

@jacodg jacodg added this to the 7.9.1 milestone Jan 15, 2024
@jkosternl jkosternl moved this to Todo in Frank!Framework Jan 16, 2024
@jkosternl jkosternl assigned tnleeuw and unassigned jkosternl Jan 23, 2024
@tnleeuw tnleeuw moved this from Todo to In Progress in Frank!Framework Jan 23, 2024
@tnleeuw tnleeuw linked a pull request Jan 23, 2024 that will close this issue
@tnleeuw tnleeuw moved this from In Progress to Review in Frank!Framework Jan 26, 2024
@github-project-automation github-project-automation bot moved this from Review to Done in Frank!Framework Feb 5, 2024
@tnleeuw tnleeuw linked a pull request Feb 5, 2024 that will close this issue
@tnleeuw tnleeuw moved this from Done to Review in Frank!Framework Feb 5, 2024
@tnleeuw tnleeuw moved this from Review to Done in Frank!Framework Feb 6, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment