Re: [Puppet Users] PuppetDB 1.6.3 Garbage collection fails abruptly

2015-01-07 Thread Andreas Paul
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 *

Re: [Puppet Users] PuppetDB 1.6.3 Garbage collection fails abruptly

2015-01-02 Thread Andreas Paul
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

Re: [Puppet Users] PuppetDB 1.6.3 Garbage collection fails abruptly

2015-01-02 Thread Wyatt Alt
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

[Puppet Users] PuppetDB 1.6.3 Garbage collection fails abruptly

2015-01-02 Thread Andreas Paul
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