aws / aws/aws-secretsmanager-jdbc

TomcatConnection pool connection go stale after some time

Open
#61 4 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Java
Stars
196
Forks
87
PR merge metrics
No merged PRs in 30d

Description

Resource
name="jdbc/eampleDB"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
maxActive="100"
maxIdle="30"
maxWait="1000"
username="awssecret"

driverClassName="com.amazonaws.secretsmanager.sql.AWSSecretsManagerMySQLDriver"
url="jdbc-secretsmanager:mysql://hostname:3306/example?useSSL=false"

connection works for a time and after a some time connection go stale , connection already closed exception

Contributor guide

Open the contributing guide

Research direction

Start with the Tomcat JDBC pool Resource configuration in the issue, especially the AWSSecretsManagerMySQLDriver URL and pool limits. Reproduce the connection-lifetime failure and inspect the resulting closed-connection exception and pool or database logs. Done means identifying the relevant timeout or lifecycle cause and documenting or validating a reliable configuration change.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, java, mysql
Domain
backend, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Needs clarification
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.