[ https://issues.apache.org/jira/browse/HIVE-25482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rajesh Balamohan resolved HIVE-25482. ------------------------------------- Fix Version/s: 4.0.0 Resolution: Fixed Merged the PR. Thanks for the contribution [~aleksandr_pashkovskii]. > Add option to enable connectionLeak detection for Hikari datasource > ------------------------------------------------------------------- > > Key: HIVE-25482 > URL: https://issues.apache.org/jira/browse/HIVE-25482 > Project: Hive > Issue Type: Improvement > Reporter: Rajesh Balamohan > Assignee: Aleksandr Pashkovskii > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 2.5h > Remaining Estimate: 0h > > There are corner cases where we observed connection leaks to DB. > > It will be good to add an option to provide connection leak timeout parameter > in HikariCPDataSourceProvider. > [https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/datasource/HikariCPDataSourceProvider.java#L69] > e.g following should help Hikari to warn about connection leak, when a > connection is not returned to the pool for 1 hour. > {noformat} > config.setLeakDetectionThreshold(3600*1000); {noformat} > -- This message was sent by Atlassian Jira (v8.3.4#803005)