Hello, We have upgraded Puppetdb from 1.0.2 to 1.1.1 last week, and recently we noticed that queue is not processed. We don't know if this problem is directly linked to the upgrade. There are now 25 000 messages waiting in the queue. We also see errors in the Postgres log:
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 * > Can this be somehow related to the the KahaDB leak thread? (https://groups.google.com/d/topic/puppet-users/gWACi4a0BZs/discussion ) Any thoughts? Would flushing the queue solve the problem? -- 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.
