[ 
https://issues.apache.org/jira/browse/HIVE-25482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17406341#comment-17406341
 ] 

Rajesh Balamohan commented on HIVE-25482:
-----------------------------------------

Sure. Assigned it in your name [~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
>
> 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)

Reply via email to