You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Aleksandr Pashkovskii (Jira)" <ji...@apache.org> on 2021/08/30 06:42:00 UTC
[jira] [Updated] (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 ]
Aleksandr Pashkovskii updated HIVE-25482:
-----------------------------------------
Attachment: image-2021-08-30-09-41-34-669.png
> 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
> Attachments: image-2021-08-30-09-41-25-098.png, image-2021-08-30-09-41-34-669.png
>
>
> 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)