[Pkg-puppet-devel] Bug#780664: Bug#780664: puppetmaster fills up the database connection pool.

[bertagaz]

Hi,

On Tue, Mar 17, 2015 at 04:55:46PM +0200, Apollon Oikonomopoulos wrote:
> On 15:31 Tue 17 Mar     , bertagaz wrote:
> > Hi,
> > 
> > When enabling storeconfig in puppetmaster, the database connection pool gets
> > filled up by inactive connections opened by previous puppet agents 
> > runs.
> 
> It's normal to see inactive connections from previous runs, but these 
> should be marked as free in the pool and reusable. I can't reproduce 
> this in our Jessie setup with Passenger, MariaDB 10.0.16 and 
> ActiveRecord 4.1.8; I see 2 constantly open connections but I can 
> clearly see they are being reused and recycled. What version of 
> ActiveRecord do you have installed? Did it work in wheezy?

We're using a plain Jessie install too, with software pulled from its
archive only.

I can't remember how it was running in Wheezy. Any hints intrigeri?


ii  puppet                                3.7.2-3
ii  puppet-common                         3.7.2-3
ii  puppetmaster                          3.7.2-3
ii  puppetmaster-common                   3.7.2-3
ii  puppetmaster                          3.7.2-3
ii  ruby-activerecord                     2:4.1.8-1
ii  ruby-activerecord-deprecated-finders  1.0.3-1
ii  ruby-sqlite3                          1.3.9-2+b2
ii  libsqlite3-0                          3.8.7.1-1
ii  libmysqlclient18:amd64                5.5.42-1
ii  mysql-client-5.5                      5.5.42-1
ii  mysql-common                          5.5.42-1
ii  mysql-server                          5.5.42-1
ii  mysql-server-5.5                      5.5.42-1
ii  mysql-server-core-5.5                 5.5.42-1
ii  ruby-mysql                            2.9.1-1


bert.