Uploaded image for project: 'PuppetDB'
  1. PuppetDB
  2. PDB-2581

PDB connection pool size defaults to 10 instead of 25 and cannot be configured

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: PDB 4.0.0
    • Fix Version/s: PDB 4.0.1
    • Component/s: None
    • Labels:
    • Template:
    • Story Points:
      1
    • Sprint:
      PuppetDB 2016-04-06

      Description

      The Problem

      I'm seeing 20 connections to postgresl from puppetdb

      pe-postgres=# select datname, count(*) From pg_Stat_activity where datname = 'pe-puppetdb' group by datname;
         datname   | count
      -------------+-------
       pe-puppetdb |    20
      (1 row)
      

      despite seeing errors in the logs

      2016-04-01 00:06:25,701 WARN  [o.e.j.s.HttpChannel] /pdb/query/v4/nodes/user96-mega-scale-agent-33.us-west-2.compute.internal/facts
      javax.servlet.ServletException: java.sql.SQLTransientConnectionException: PDBReadPool - Connection is not available, request timed out after 3000ms.
      

      From Wyatt Alt the connection pools each have 10

       
      [root@mega-scale-mom ~]# curl -X GET http://localhost:8080/metrics/v1/mbeans/puppetlabs.puppetdb.database%3Aname%3DPDBReadPool.pool.TotalConnections
      {
        "Value" : 10
      }[
      

      Even setting maximum-pool-size has no effect

      [root@mega-scale-mom ~]# cat /etc/puppetlabs/puppetdb/conf.d/database.ini | grep max
      maximum-pool-size = 9
      

        Attachments

          Issue Links

            Activity

              jsd-sla-details-panel

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nick.walker Nick Walker
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: