Skip to content

Instantly share code, notes, and snippets.

@c4m4
Created February 7, 2018 07:24
Show Gist options
  • Save c4m4/ed6a6dbb3e27c67b51f70f365da4238f to your computer and use it in GitHub Desktop.
Save c4m4/ed6a6dbb3e27c67b51f70f365da4238f to your computer and use it in GitHub Desktop.
$ cat dati/nagios_dupps 2.4.2
Error: Could not retrieve catalog from remote server: Error 500 on SERVER: Server Error: A duplicate resource was found while collecting exported resources, with the type and title Nagios_host[10.0.5.26] on node i-0c6fa91c70aac2924.10.0.13.15
Warning: Not using cache on failed catalog
Error: Could not retrieve catalog; skipping run
puppetdb=# select * from catalog_resources where title like '%10.0.5.26%';
resource | tags | type | tit
le | exported | file | line | certname_id
--------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------+----------------+---------
---------+----------+--------------------------------------------------------------------------------------+------+-------------
\x5df7c21ae5f0dac66848fd8f71554741a305aceb | {role,class,base,role::base,10.0.5.26_load,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_load | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 340
\x300df0e8ae485cdfc879c0ee640a46215912143e | {10.0.5.26_memory,role,class,base,role::base,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_memory | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 340
\x62ae802e6617b585cd2f57d3db5c334a2c59be58 | {role,10.0.5.26,class,nagios_host,base,role::base,profiles,profiles::nagiosclient,nagiosclient,default,node} | Nagios_host | 10.0.5.2
6 | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 16 | 340
\x87971d7beb097f1371fedced05e061d5a48c3e36 | {role,class,base,role::base,10.0.5.26_disk,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_disk | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 340
\x231ec12437889de742c720ba3534ad7c9010ee47 | {role,nagiosserver,role::monitoring,class,10.0.5.26_load,monitoring,profiles,nagios_service,profiles::nagiosserver,default,node} | Nagios_service | 10.0.5.2
6_load | f | | | 282
\x573bf93b969ed7a702465d339e85d17dd77c6599 | {10.0.5.26_memory,role,nagiosserver,role::monitoring,class,monitoring,profiles,nagios_service,profiles::nagiosserver,default,node} | Nagios_service | 10.0.5.2
6_memory | f | | | 282
\x732b5267135d4007f179c43a9ab8671371490891 | {role,10.0.5.26,nagiosserver,role::monitoring,class,nagios_host,monitoring,profiles,profiles::nagiosserver,default,node} | Nagios_host | 10.0.5.2
6 | f | | | 282
\x1a4d178065888b65049e5f3e31e474f22dc69744 | {role,nagiosserver,role::monitoring,class,10.0.5.26_disk,monitoring,profiles,nagios_service,profiles::nagiosserver,default,node} | Nagios_service | 10.0.5.2
6_disk | f | | | 282
\x5df7c21ae5f0dac66848fd8f71554741a305aceb | {role,class,base,role::base,10.0.5.26_load,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_load | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 348
\x300df0e8ae485cdfc879c0ee640a46215912143e | {10.0.5.26_memory,role,class,base,role::base,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_memory | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 348
\x62ae802e6617b585cd2f57d3db5c334a2c59be58 | {role,10.0.5.26,class,nagios_host,base,role::base,profiles,profiles::nagiosclient,nagiosclient,default,node} | Nagios_host | 10.0.5.2
6 | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 16 | 348
\x87971d7beb097f1371fedced05e061d5a48c3e36 | {role,class,base,role::base,10.0.5.26_disk,profiles,nagios_service,profiles::nagiosclient,nagiosclient,default,node} | Nagios_service | 10.0.5.2
6_disk | t | /etc/puppetlabs/code/environments/production/site/profiles/manifests/nagiosclient.pp | 22 | 348
(12 rows)
puppetdb=# select * from certnames where id=340;
id | certname | latest_report_id | deactivated | expired | package_hash
-----+-------------------------------+------------------+-------------+---------+--------------
340 | i-00b759a3a5a6e1a80.10.0.5.14 | | | |
(1 row)
puppetdb=# select * from certnames where id=282;
id | certname | latest_report_id | deactivated | expired | package_hash
-----+--------------------------------+------------------+-------------+---------+--------------
282 | i-0c6fa91c70aac2924.10.0.13.15 | | | |
(1 row)
puppetdb=# select * from certnames where id=348;
id | certname | latest_report_id | deactivated | expired | package_hash
-----+-------------------------------+------------------+-------------+---------+--------------
348 | i-01415c2cb533c250b.10.0.5.26 | | | |
(1 row)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment