View all the failed executions on Puppetdb

[Aditya S]

Hi,

Is there a way to see failed executions in PuppetDB? I can see all the successful  classes in "public.catalog_resources" but is there a way to see all failed executions. For example something like:

"Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: Evaluation Error: Error while evaluating a Function Call, Could not find class"

If I were not using psql but trying the REST API like "/pdb/query/v4/reports"? 

Thanks!

[Aditya S]

Sorry I forgot to add:

puppetserver version: 5.3.7

puppetdb version: 5.2.7

puppet agent version: 5.5.8

[Austin Blatt]

If you want all information about all failed reports you can query for reports that have a status of failed. An example using curl would look like,

curl -X POST http://localhost:8080/pdb/query/v4 \

  -H 'Content-Type:application/json' \

  -d '{"query": "reports { status = \"failed\" }"}'

There are a few other options that might be of interest to you as well, for example you can query for just the certname of all agents whose most recent Puppet run failed with something like,

curl -X POST http://localhost:8080/pdb/query/v4 \

  -H 'Content-Type:application/json' \

  -d '{"query": "reports[certname] { status = \"failed\" and latest_report? = true}"}'

You can find more docs on querying the reports endpoint for PuppetDB 5.2.7 here. I hope this helps! 

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-users/14aa3fc7-1e85-4f2c-bfb3-aa2e1ed1b074%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Austin Blatt
Associate Software Engineer

austin...@puppet.com

[Aditya S]

Thanks Austin,

The output didn't give me any information so I tried to look in the database. Is it coming from public.report_statuses or public.resource_events because they are both blank for me. Is that the right tabel?

Please let me know.

Thanks!

[Aditya S]

I figured this out. I missed a step while setting up the PuppetDB. I did not add "reports = store,puppetdb" in the puppet.conf so it never really added the reports in the database. 

Adding the following and restarting it fixed the issues for me:

# vi /etc/puppetlabs/puppet/puppet.conf

[master]
storeconfigs = true
storeconfigs_backend = puppetdb
reports = store,puppetdb