[jira] [Created] (HIVE-25482) Add option to enable connectionLeak detection for Hikari datasource

["Rajesh Balamohan (Jira)" <ji...@apache.org>]

Rajesh Balamohan created HIVE-25482:
---------------------------------------

             Summary: 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


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)