Hi, 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. > > 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
Can you try with a newer rails/active record? This one is a little bit old, and I'm not sure there aren't some bugs. I vaguely remember that puppet required rails 2.2, but I might be wrong. -- Brice Figureau Follow the latest Puppet Community evolutions on www.planetpuppet.org! -- 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.