Issue #3238 has been updated by Jeffrey Lensen.

micah - wrote:
> here is my hacky work-around that I am doing every 20 minutes:
> 
> [...]

Micah, what are your timeout settings for MySQL? By lowering the wait_timeout 
you'll probably "fix" this too. 
I'm seeing similar behavior with Puppet 2.6.1 and MySQL 5.1.39 and have my 
wait_timeout set to 60 seconds and MySQL kills these "open" connections for me. 
----------------------------------------
Bug #3238: puppetmaster uses to many mysql connections
https://projects.puppetlabs.com/issues/3238

Author: Nicolas Szalay
Status: Code Insufficient
Priority: Normal
Assignee: 
Category: stored configuration
Target version: Statler
Affected Puppet version: 0.25.4
Keywords: mysql postgresql max_connections connections storeconfigs
Branch: 


Hello,

after upgrading to 0.25.4 this morning (debian package from squeeze on lenny ), 
I saw that the number of mysql connections increased greatly and then reached 
max_connections. Accordingly to the number of managed hosts and the time taken 
to reach the maximum connections I suppose that it uses one connection per 
client checkin.


-- 
You have received this notification because you have either subscribed to it, 
or are involved in it.
To change your notification preferences, please click here: 
http://projects.puppetlabs.com/my/account

-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Bugs" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/puppet-bugs?hl=en.

Reply via email to