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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Normal
    • Resolution: Fixed
    • PDB 4.0.0
    • PDB 4.0.1
    • PuppetDB
    • PuppetDB
    • 1
    • 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 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

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Zendesk Support