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

Lower Metastore DB Connection Pool Size in QTests

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 3.2.0
    • 4.0.0, 4.0.0-alpha-1
    • Test, Tests
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: