[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:
> Hi,
> 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?

I got confirmation it used to work in Wheezy.

Are you using the stomserver queue handling feature? We're not, and I'm
tempted to give it a try.

I'll try to test in another environment, to be sure this bug is not
related to any specifics bits of the current system.

bert.