Issue #18272 has been updated by Patrick Carlisle.

Description updated


----------------------------------------
Bug #18272: the puppet databases still hold information about decommissioned 
hosts
https://projects.puppetlabs.com/issues/18272#change-84717

Author: Sunny Jaisinghani
Status: Unreviewed
Priority: Normal
Assignee: 
Category: node
Target version: 
Affected Puppet version: 
Keywords: 
Branch: 


Hello folks

We have deployed puppet enterprise in our Amazon environment and have been 
using puppet for more than 1 year now. 

We have been repeatedly trying to find ways to clean node information from 
puppet's databases, puppet dashboard completely.
We came across "puppet node clean", but it seems this doesn't clean up 
everything. 


example:

This particular host was created and terminated July and Aug respectively. But 
i see information related to this host in console database and on the dashboard 
too. It shows as unreported on the dashboard.
"ip-10-12-45-250.ec2.internal"

    mysql> select * from nodes where name='ip-10-12-45-250.ec2.internal';
    
+-----+------------------------------+-------------+---------------------+---------------------+-------------+----------------------+--------+--------+------------------------+
    | id  | name                         | description | created_at          | 
updated_at          | reported_at | last_apply_report_id | status | hidden | 
last_inspect_report_id |
    
+-----+------------------------------+-------------+---------------------+---------------------+-------------+----------------------+--------+--------+------------------------+
    | 140 | ip-10-12-45-250.ec2.internal | NULL        | 2012-07-05 13:43:57 | 
2012-08-05 09:00:28 | NULL        |                 NULL | NULL   |      0 |    
               NULL | 
    
+-----+------------------------------+-------------+---------------------+---------------------+-------------+----------------------+--------+--------+------------------------+
    1 row in set (0.00 sec)


We keep testing a lot of stuff in our staging environments which includes 
creating and terminating ec2 instances. This has caused a big list of 
unreported hosts on the dashboard.

Also, please note, that we have puppet databases on Amazon RDS instance and 
puppet masters on Amazon EC2 instance. 




-- 
You have received this notification because you have either subscribed to it, 
or are involved in it.
To change your notification preferences, please click here: 
http://projects.puppetlabs.com/my/account

-- 
You received this message because you are subscribed to the Google Groups 
"Puppet Bugs" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-bugs?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to