You might also try the latest ruby-mysql gem. Brice Figureau <brice-pup...@daysofwonder.com> wrote:
>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. > -- 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.
