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
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
--
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.
