[Puppet Users] troubleshooting constraint violations in puppetdb?

Do any of you have troubleshooting tips for the puppetdb error log message about violating database constraints? How would I tell which constraint and which resource, short of logging all sql queries? 2014-11-11 08:29:34,814 ERROR [c.p.p.command] [6133d0c4-3350-4567-abb0-476980a9616e] [replace

Re: [Puppet Users] troubleshooting constraint violations in puppetdb?

Could you send me one of that catalog commands that is triggering this error? You should be able to find this in your mq directory that you purged earlier. The contents should look like this . If you'd rather not post

Re: [Puppet Users] troubleshooting constraint violations in puppetdb?

Embarrassingly, due to disk space issues I purged rather than moved and don't see any files full of json under /var/lib/puppetdb per the catalog wire format v5. If you have a hint as to how I might get one I will do that, otherwise I will send you one as soon as it turns up. On Tue, Nov 11, 201

Re: [Puppet Users] troubleshooting constraint violations in puppetdb?

Waiting is ok. You might be able to find the node associated to one of the failing catalogs in the log. You could then either force a puppet run and grab the failed message or look in your puppet cache (in client_data/catalog on the master). -Ryan On Tue, Nov 11, 2014 at 4:32 PM, Christopher Wood

Re: [Puppet Users] troubleshooting constraint violations in puppetdb?

Aha, finally found one and sent it separately. On Wed, Nov 12, 2014 at 08:16:35AM -0500, Ryan Senior wrote: >Waiting is ok. You might be able to find the node associated to one of the >failing catalogs in the log. You could then either force a puppet run and >grab the failed message or

Re: [Puppet Users] troubleshooting constraint violations in puppetdb?

(Following up to my own OP to complete the saga after much help from Ryan Senior. I'm replying here instead of to the end of the other thread branch so this will be more obvious in later searches. Warning, long and often ignorant.) The problem might have been caused by factors external to puppet