Jira (PDB-2581) PDB connection pool size defaults to 10 instead of 25 and cannot be configured

Title: Message Title

Nick Walker created an issue

PDB-2581

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

Add Comment

This message was sent by Atlassian JIRA

--
You received this message because you are subscribed to the Google Groups "Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/puppet-bugs.
For more options, visit https://groups.google.com/d/optout.