The userlist is most likely your your issue. This seems analogous to
FACT-1345 and PDB-2631 for context -- we usually see this with the os,
mountpoints, and partitions facts. What's generating the userlist and
what are the numbers it's valued with? Do you have code that generates
the fact? There may be ways you can restructure it to make it easier on
the database.
Wyatt
On 06/30/2017 06:11 AM, Peter Krawetzky wrote:
So if I'm reading this correctly, the userlist#~(number) represents
the value of the userlist fact? If that is the case, the size of the
userlist fact is 228k each and every time puppet agent runs with
approximately 3300 nodes.
On Wednesday, June 28, 2017 at 12:25:57 PM UTC-4, Peter Krawetzky wrote:
Last Sunday we hit a wall on our 3.0.2 puppetdb server. The cpu
spiked and the KahaDB logs started to grow eventually almost
filling a filesystem. I stopped the service, removed the mq
directory per a troubleshooting guide, and restarted. After
several minutes the same symptoms began again and I have not been
able to come up with a puppetdb or postgresql config to fix this.
We tried turning off storeconfig in the puppet.conf file on our
puppet master servers but that doesn't appear to have resolved the
problem. I also can't find a good explanation as to what this
parameter really does or does not do even in the puppet server
documentation. Anyone have a better insight into this?
Also is there a way to just turn off puppetdb?
I've attached a file that is a snapshot of the puppetdb dashboard.
Anyone experience anything like this?
--
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+unsubscr...@googlegroups.com
<mailto:puppet-users+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/814883b8-9077-48b8-a94a-42865881f94d%40googlegroups.com
<https://groups.google.com/d/msgid/puppet-users/814883b8-9077-48b8-a94a-42865881f94d%40googlegroups.com?utm_medium=email&utm_source=footer>.
For more options, visit https://groups.google.com/d/optout.
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/d26d012c-5a5b-50c3-4646-7b2de752f8e0%40puppet.com.
For more options, visit https://groups.google.com/d/optout.
