Hey,
our database admin solved this problem by executing the following SQL query
in a 3 second sleep loop over multiple days:
DELETE FROM resource_params_cache
WHERE resource_params_cache.resource IN (SELECT resource_params_cache.resource
FROM resource_params_cache
WHERE NOT EXISTS (SELECT *
Hi Wyatt,
- Have you recently upgraded PuppetDB, or changed any other part of your
Puppet/PuppetDB installation?
No, we haven't changed our Puppet client/server or PuppetDB version
recently.
- Was PuppetDB running fine before this started occurring, or are you still
getting it set up?
PuppetDB
Hey Andreas,
Can you give some more information about how this cropped up?
- Have you recently upgraded PuppetDB, or changed any other part of your
Puppet/PuppetDB installation?
- Was PuppetDB running fine before this started occurring, or are you
still getting it set up?
- What version of P
Hi there,
the PuppetDB garbage collection fails sometimes after 5 minutes and
sometimes after 2-3 hours with the following error message:
2014-12-29 12:12:57,312 INFO [pool-3-thread-1] [cli.services] Starting
database garbage collection
2014-12-29 16:31:39,106 ERROR [pool-3-thread-1] [cli.serv