Running puppet only at around 4am once a day here. And I noticed that puppetdb query not working as expected, if using it to query nodes based on some custom fact value. During the days, things are working fine. But if I ran the same query at around say 3am (searching nodes based on some custom fact''s value), then it would not be able to return node information. But if I ran puppet on that node at that time, then I could see the node showing up in the query output right away. And if I ran puppetdb query based on custom fact after 5am, then it is working as expected. Is there some configuration settings control this behavior? This does not occur for facter''s built-in facts though. Thanks, Hai -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Ken Barber
2013-Sep-11 10:29 UTC
Re: [Puppet Users] puppetdb query not working as expected
> Running puppet only at around 4am once a day here. And I noticed that > puppetdb query not working as expected, if using it to query nodes based on > some custom fact value. > > During the days, things are working fine. But if I ran the same query at > around say 3am (searching nodes based on some custom fact''s value), then it > would not be able to return node information. But if I ran puppet on that > node at that time, then I could see the node showing up in the query output > right away. And if I ran puppetdb query based on custom fact after 5am, then > it is working as expected.Is there any errors associated with this failure, if so can you supply it? In particular - do you get anything of interest in your puppetdb.log? This could be a performance tuning issue, if so we usually log queries over 10 seconds to puppetdb.log for example. Are you using PostgreSQL? ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Hi Ken, Yes, using postgresql here. It turns out I have another script pushing facts (without custom facts) into puppetdb, which messed up with puppetdb query outputs. After fixing that script, things are ok now here. Thanks, On Wed, Sep 11, 2013 at 5:29 AM, Ken Barber <ken@puppetlabs.com> wrote:> > Running puppet only at around 4am once a day here. And I noticed that > > puppetdb query not working as expected, if using it to query nodes based > on > > some custom fact value. > > > > During the days, things are working fine. But if I ran the same query at > > around say 3am (searching nodes based on some custom fact''s value), then > it > > would not be able to return node information. But if I ran puppet on that > > node at that time, then I could see the node showing up in the query > output > > right away. And if I ran puppetdb query based on custom fact after 5am, > then > > it is working as expected. > > Is there any errors associated with this failure, if so can you supply > it? In particular - do you get anything of interest in your > puppetdb.log? This could be a performance tuning issue, if so we > usually log queries over 10 seconds to puppetdb.log for example. > > Are you using PostgreSQL? > > ken. > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscribe@googlegroups.com. > To post to this group, send email to puppet-users@googlegroups.com. > Visit this group at http://groups.google.com/group/puppet-users. > For more options, visit https://groups.google.com/groups/opt_out. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
Ken Barber
2013-Sep-12 08:34 UTC
Re: [Puppet Users] puppetdb query not working as expected
> Yes, using postgresql here. It turns out I have another script pushing facts > (without custom facts) into puppetdb, which messed up with puppetdb query > outputs. After fixing that script, things are ok now here.Aaah, so it wasn''t performance at all. Was that a custom script someone at your company had written, or some other 3rd party tool we should be on the lookout for? I only ask as others might hit the problem :-). ken. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.
It''s a custom script I wrote quite a while ago and I forgot about it ;) On Thu, Sep 12, 2013 at 3:34 AM, Ken Barber <ken@puppetlabs.com> wrote:> > Yes, using postgresql here. It turns out I have another script pushing > facts > > (without custom facts) into puppetdb, which messed up with puppetdb query > > outputs. After fixing that script, things are ok now here. > > Aaah, so it wasn''t performance at all. Was that a custom script > someone at your company had written, or some other 3rd party tool we > should be on the lookout for? I only ask as others might hit the > problem :-). > > ken. > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to puppet-users+unsubscribe@googlegroups.com. > To post to this group, send email to puppet-users@googlegroups.com. > Visit this group at http://groups.google.com/group/puppet-users. > For more options, visit https://groups.google.com/groups/opt_out. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-users+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users. For more options, visit https://groups.google.com/groups/opt_out.