> Hi, thanks for trying to help! :) I'm @ken_barber on irc btw if that is easier.
>> That is a bit of a concern, are you receiving a lot of these? Is this >> constant? > > Before we flushed the queue, quite a lot. Since we flushed it, only 4 times. > > >> >> > Use of unversioned APIs is deprecated; please use /v1/resources >> >> These are appearing in your slow query log - are you sure you're >> running puppetdb-terminus 1.1.1 as well? Did you restart your master >> after upgrading the terminus? >> > > The terminus version is correct, however we were not entirely sure that the > masters were properly restarted, so we did it now again, let's see if this > changes anything. Okay. Did you clear the ActiveMQ queues after doing this? I usually just move the old KahaDB directory out of the way when I do this. > But the hanging is happening again. I checked what queries run on the > database server. Some queries are running for ~ 90 mins, and there are some > idle threads. There are two update commands that are waiting. I assume while > those 2 don't get executed, the queue processing is halted. Okay, so were those old queries that are taking 90 minutes, what are they? Have you tried shutting down the PuppetDB, clearing the queue - running full vacuum on the database then starting it all up again? What version of PostgreSQL are we talking here? What distro and version specifically? How big is the database itself? How many nodes and how frequently are they checking in? A screenshot of your puppetdb dashboard might give us a good snapshot of the size of your environment as well. Has any tuning been performed on your postgresql server? A copy of your postgresql.conf would be interesting. We can do this all privately if you are concerned about sharing information publicly as well - up to you. Like I said, I'm also on Freenode IRC as @ken_barber if this is better for you. 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+unsubscr...@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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
