Issue #3238 has been updated by Jason Koppe.

I'm having a similar issue (hits the 5 concurrent connection limit) on 
CentOS5.2 with the following packages:

**source**
mysql  Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline 5.1

**yum**
puppet-0.25.5-1.el5
puppet-server-0.25.5-1.el5
rubygems-1.3.1-1.el5
ruby-shadow-1.4.1-7.el5
ruby-devel-1.8.6.111-1
ruby-1.8.6.111-1
ruby-ri-1.8.6.111-1
ruby-docs-1.8.5-5.el5_3.7
ruby-augeas-0.3.0-1.el5
ruby-irb-1.8.6.111-1
ruby-rdoc-1.8.6.111-1
ruby-mode-1.8.5-5.el5_3.7
libselinux-ruby-1.33.4-5.5.el5
ruby-libs-1.8.6.111-1

**gem**
activerecord (2.3.8, 2.3.4)
activeresource (2.3.8)
activesupport (2.3.8, 2.3.4)
mysql (2.8.1)
rack (1.1.0)
rails (2.3.8)

Here's my puppetmaster's config file:
<pre>
# puppet configuration
[main]
autoflush = true

# storeconfig location
dbadapter = mysql
dbuser = puppet
dbpassword = password
dbserver = localhost


# used as a queue for the storeconfigs to lighten the load on the backing store
queue_type = stomp
queue_source = stomp://localhost:61613

[puppetmasterd]
storeconfigs = true
async_storeconfigs = true
</pre>

----------------------------------------
Bug #3238: puppetmaster uses to many mysql connections
http://projects.puppetlabs.com/issues/3238

Author: Nicolas Szalay
Status: Re-opened
Priority: Normal
Assigned to: 
Category: 
Target version: 
Affected 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