Hello...
On Tue, 2010-04-27 at 15:05 +0200, Arnaud Gomes-do-Vale wrote: > Hi folks, > > When I enabled stored configs on my puppet master, it began keeping lots > of open connections to the MySQL server (as far as I understand it > opened one connection for each client run and never closed them). > > I set up the server to close idle connections after 5 minutes. Now the > database server does close the connections but the puppet master keeps > them in CLOSE_WAIT state and eventually runs out of file descriptors. > I ran into this same thing. Update (rebuild) to the following rpms versions from fedora 11: rubygem-activerecord.noarch 1:2.3.2-4.fc11 rubygem-activesupport.noarch 1:2.3.2-2.fc11 rubygem-rack.noarch 1.0.0-1.fc11 For various reasons, these versions cannot be pushed into EPEL. > Here is a sample of the output of lsof on the puppet master: > > .../... > puppetmas 16418 puppet 617u IPv4 2683389 TCP > puppetmaster.ircam.fr:57097->mysql2.ircam.fr:mysql (CLOSE_WAIT) > puppetmas 16418 puppet 618u IPv4 2683494 TCP > puppetmaster.ircam.fr:57099->mysql2.ircam.fr:mysql (CLOSE_WAIT) > puppetmas 16418 puppet 619u IPv4 2683506 TCP > puppetmaster.ircam.fr:57100->mysql2.ircam.fr:mysql (CLOSE_WAIT) > puppetmas 16418 puppet 620u IPv4 2684180 TCP > puppetmaster.ircam.fr:57108->mysql2.ircam.fr:mysql (CLOSE_WAIT) > puppetmas 16418 puppet 621u IPv4 2683726 TCP > puppetmaster.ircam.fr:57102->mysql2.ircam.fr:mysql (CLOSE_WAIT) > .../... > > The matching sockets don't appear on the MySQL server. > > The puppet master runs CentOS 5 with (pieces of) EPEL; here are the > installed versions of the relevant packages: > > puppet-0.25.4-1.el5 > puppet-server-0.25.4-1.el5 > rubygem-activeresource-2.1.1-1.el5 > rubygem-activesupport-2.1.1-2.el5 > rubygem-activerecord-2.1.1-2.el5 > rubygems-1.3.1-1.el5 > rubygem-rails-2.1.1-2.el5 > ruby-1.8.5-5.el5_4.8 > ruby-mysql-2.7.3-1.el5 > > And the puppetmaster config : > > [puppetmasterd] > node_terminus = ldap > ldapserver = nsldap.ircam.fr > ldapbase = ou=Hosts,dc=ircam,dc=fr > modulepath = /etc/puppet/modules:/usr/share/puppet:/var/lib/puppet/modules > > storeconfigs = true > dbserver = mysql2.ircam.fr > dbadapter = mysql > dbname = XXXXXXXXXXXXXXXX > dbuser = XXXXXXXXXXXXXXXX > dbpassword = XXXXXXXXXXXXXXXXXXXXXXXXXXX > > reports = store,log,rrdgraph > rrdgraph = true > > -- > Arnaud > -- Christopher McCrory "The guy that keeps the servers running" chris...@pricegrabber.com http://www.pricegrabber.com Let's face it, there's no Hollow Earth, no robots, and no 'mute rays.' And even if there were, waxed paper is no defense. I tried it. Only tinfoil works. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-us...@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.