Hi, thanks for trying to help! :) If you clear the queue and rollback to the original version does the > problem disappear? If you're having processing problems at the latest > version thats what I would do, as I presume we're talking production > here right? > > Yes, this is production. We would like to avoid reverting, but maybe we will have to.
> > > ERROR: insert or update on table "certname_catalogs" violates foreign > key constraint "certname_catalogs_catalog_fkey" > > DETAIL: Key (catalog)=(d1c89bbef78a55edcf560c432d965cfe1263059c) is not > present in table "catalogs". > > STATEMENT: INSERT INTO certname_catalogs (certname,catalog,timestamp) > VALUES ($1,$2,$3) RETURNING * > > 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. 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. -- 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.
