Hello,
I am not sure if I trigger a bug and if so it could also be in ruby
sqlite3 backend. However, maybe I do something totally wrong.
I have the following part in puppet.conf:
[master]
storeconfigs = true
dblocation = /var/lib/puppet/state/clientconfigs.sqlite3
dbadapter = sqlite3
Now every time a client (agent in puppet speak) is run I get one more
connection to the database:
> lsof -np $(pgrep puppet)
...
puppet 23542 puppet 7u IPv4 1180771 0t0 TCP *:8140
(LISTEN)
puppet 23542 puppet 9w REG 252,1 71 2621
/var/log/puppet/rails.log
puppet 23542 puppet 10u REG 252,1 156672 2684
/var/lib/puppet/state/clientconfigs.sqlite3
puppet 23542 puppet 11u REG 252,1 156672 2684
/var/lib/puppet/state/clientconfigs.sqlite3
Next run:
> lsof -np $(pgrep puppet)
...
puppet 23542 puppet 7u IPv4 1180771 0t0 TCP *:8140
(LISTEN)
puppet 23542 puppet 9w REG 252,1 71 2621
/var/log/puppet/rails.log
puppet 23542 puppet 10u REG 252,1 156672 2684
/var/lib/puppet/state/clientconfigs.sqlite3
puppet 23542 puppet 11u REG 252,1 156672 2684
/var/lib/puppet/state/clientconfigs.sqlite3
puppet 23542 puppet 12u REG 252,1 156672 2684
/var/lib/puppet/state/clientconfigs.sqlite3
And so on until the maximum is reached and the puppetmaster do not work
anymore.
I encountered this bug with many versions on different linux
distributions. For example:
Ubuntu 10.04
Puppet 2.7.6
libsqlite3-ruby1.8 1.2.4-2.1
Do anybody has an idea what I can do to handle that?
-- Klaus
--
Klaus Ethgen http://www.ethgen.ch/
pub 4096R/4E20AF1C 2011-05-16 Klaus Ethgen <Klaus@Ethgen.de>
Fingerprint: 85D4 CA42 952C 949B 1753 62B3 79D0 B06F 4E20 AF1C
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To post to this group, send email to puppet-users@googlegroups.com.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
On Tue, Nov 15, 2011 at 7:16 PM, Klaus Ethgen <klaus+usenet@ethgen.de> wrote:> Hello, > > I am not sure if I trigger a bug and if so it could also be in ruby > sqlite3 backend. However, maybe I do something totally wrong. > > I have the following part in puppet.conf: > [master] > storeconfigs = true > dblocation = /var/lib/puppet/state/clientconfigs.sqlite3 > dbadapter = sqlite3 > > Now every time a client (agent in puppet speak) is run I get one more > connection to the database: > > lsof -np $(pgrep puppet) > ... > puppet 23542 puppet 7u IPv4 1180771 0t0 TCP *:8140 (LISTEN) > puppet 23542 puppet 9w REG 252,1 71 2621 /var/log/puppet/rails.log > puppet 23542 puppet 10u REG 252,1 156672 2684 /var/lib/puppet/state/clientconfigs.sqlite3 > puppet 23542 puppet 11u REG 252,1 156672 2684 /var/lib/puppet/state/clientconfigs.sqlite3 > > Next run: > > lsof -np $(pgrep puppet) > ... > puppet 23542 puppet 7u IPv4 1180771 0t0 TCP *:8140 (LISTEN) > puppet 23542 puppet 9w REG 252,1 71 2621 /var/log/puppet/rails.log > puppet 23542 puppet 10u REG 252,1 156672 2684 /var/lib/puppet/state/clientconfigs.sqlite3 > puppet 23542 puppet 11u REG 252,1 156672 2684 /var/lib/puppet/state/clientconfigs.sqlite3 > puppet 23542 puppet 12u REG 252,1 156672 2684 /var/lib/puppet/state/clientconfigs.sqlite3 > > And so on until the maximum is reached and the puppetmaster do not work > anymore. > > I encountered this bug with many versions on different linux > distributions. For example: > Ubuntu 10.04 > Puppet 2.7.6 > libsqlite3-ruby1.8 1.2.4-2.1 > > Do anybody has an idea what I can do to handle that?which version of activerecord? might wan tot try upgrading it> > -- Klaus > -- > Klaus Ethgen http://www.ethgen.ch/ > pub 4096R/4E20AF1C 2011-05-16 Klaus Ethgen <Klaus@Ethgen.de> > Fingerprint: 85D4 CA42 952C 949B 1753 62B3 79D0 B06F 4E20 AF1C > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Ohad Levy <ohadlevy@gmail.com> schrieb:>> I encountered this bug with many versions on different linux >> distributions. For example: >> Ubuntu 10.04 >> Puppet 2.7.6 >> libsqlite3-ruby1.8 1.2.4-2.1 >> >> Do anybody has an idea what I can do to handle that? > which version of activerecord? might wan tot try upgrading itHow do I find the version? On ubuntu there is no separate activerecord package. On SuSI where I have the same problem, activerecored is version 2.1.2 -- Klaus -- Klaus Ethgen http://www.ethgen.ch/ pub 4096R/4E20AF1C 2011-05-16 Klaus Ethgen <Klaus@Ethgen.de> Fingerprint: 85D4 CA42 952C 949B 1753 62B3 79D0 B06F 4E20 AF1C -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
On Wed, Nov 16, 2011 at 12:41 PM, Klaus Ethgen <klaus+usenet@ethgen.de> wrote:> Ohad Levy <ohadlevy@gmail.com> schrieb: >>> I encountered this bug with many versions on different linux >>> distributions. For example: >>> Ubuntu 10.04 >>> Puppet 2.7.6 >>> libsqlite3-ruby1.8 1.2.4-2.1 >>> >>> Do anybody has an idea what I can do to handle that? >> which version of activerecord? might wan tot try upgrading it > > How do I find the version? On ubuntu there is no separate activerecord > package. On SuSI where I have the same problem, activerecored is version > 2.1.2try with the gem command. 2.1.x is fairly old and is probably the cause for your problems Ohad> > -- Klaus > -- > Klaus Ethgen http://www.ethgen.ch/ > pub 4096R/4E20AF1C 2011-05-16 Klaus Ethgen <Klaus@Ethgen.de> > Fingerprint: 85D4 CA42 952C 949B 1753 62B3 79D0 B06F 4E20 AF1C > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@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-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Ohad Levy <ohadlevy@gmail.com> schrieb:>> How do I find the version? On ubuntu there is no separate activerecord >> package. On SuSI where I have the same problem, activerecored is version >> 2.1.2 > > try with the gem command.~> gem list *** LOCAL GEMS *** It is ubuntu, they do not use gem to install packages.> 2.1.x is fairly old and is probably the cause for your problemsI toughed that. But with the newer platform on ubuntu I seems to have the same problem. -- Klaus -- Klaus Ethgen http://www.ethgen.ch/ pub 4096R/4E20AF1C 2011-05-16 Klaus Ethgen <Klaus@Ethgen.de> Fingerprint: 85D4 CA42 952C 949B 1753 62B3 79D0 B06F 4E20 AF1C -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.