[
https://issues.apache.org/jira/browse/HIVE-22469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16970860#comment-16970860
]
David Mollitor commented on HIVE-22469:
---------------------------------------
[~mgergely] Can you also take a look at this one please? :)
> Lower Metastore DB Connection Pool Size in QTests
> -------------------------------------------------
>
> Key: HIVE-22469
> URL: https://issues.apache.org/jira/browse/HIVE-22469
> Project: Hive
> Issue Type: Improvement
> Components: Test, Tests
> Affects Versions: 3.2.0
> Reporter: David Mollitor
> Assignee: David Mollitor
> Priority: Minor
> Attachments: HIVE-22469.1.patch, HIVE-22469.2.patch,
> HIVE-22469.3.patch
>
>
> Hive Metastore uses the 'HikariCP' database connection pool. The default
> number of connections to the database is 10. For the Qtests, connecting to a
> local DerbyDB, there need not be more than 4 connections. Anymore simply adds
> undo overhead and by looking at the QTest logs, I see a bunch of 'connection
> refused' from HikariCP. It may be the case that the standalone DB does not
> support that many concurrent connections anyway.
> [https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-MetaStore]
> I also unified all of the JDBC connection strings to ensure that each test is
> using an in-memory database.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
