Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22469

Lower Metastore DB Connection Pool Size in QTests

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.2.0
    • Fix Version/s: 4.0.0
    • Component/s: Test, Tests
    • Labels:
      None
    • Target Version/s:
    • Flags:
      Patch

      Description

      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.

        Attachments

        1. HIVE-22469.3.patch
          6 kB
          David Mollitor
        2. HIVE-22469.2.patch
          4 kB
          David Mollitor
        3. HIVE-22469.1.patch
          4 kB
          David Mollitor

          Activity

            People

            • Assignee:
              belugabehr David Mollitor
              Reporter:
              belugabehr David Mollitor
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: