Destroying nodes in puppet dashboard seems to kill dashboard after about 5 minutes requiring a restart. I took at look at the DB schema and was just going to remove nodes via SQL directly instead of using the dashboard and wanted to see if anyone sees anything wrong with this. I know the queries could be improved not doing my subselects, but I just wanted to make sure I'm not either forgetting some data or doing something terrible.
select id from nodes where name like 'myname%'; delete from resource_events where resource_status_id in ( select id from resource_statuses where report_id in ( select id from reports where node_id = 71 )); delete from resource_statuses where report_id in (select id from reports where node_id=71); delete from metrics where report_id in (select id from reports where node_id=71); delete from report_logs where report_id in (select id from reports where node_id=71); delete from resource_events where resource_status_id in ( select id from resource_statuses where report_id in ( select id from old_reports where node_id = 71 )); delete from resource_statuses where report_id in (select id from old_reports where node_id=71); delete from metrics where report_id in (select id from old_reports where node_id=71); delete from report_logs where report_id in (select id from old_reports where node_id=71); delete from reports where node_id=71; delete from node_group_memberships where node_id=71; delete from node_class_memberships where node_id=71; jl -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
