You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Rajesh Balamohan (Jira)" <ji...@apache.org> on 2021/08/31 23:56:00 UTC
[jira] [Resolved] (HIVE-25482) Add option to enable connectionLeak
detection for Hikari datasource
[ 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)