I'm using puppet-dashboard 1.1.0-1 on Ubuntu. I remove old reports using this
command:
nice -n +1 rake RAILS_ENV=production reports:prune upto=1 unit=mon
This seems to work fine, and the amount of reports returnd by this mysql query
seems to drop by the proper amount:
select count(*) from reports;
Right now it returns a value of 12591. So far so good.
The problem is the resource_statuses statuses table. Right now I have 63695
distinct values for report_id as returned by:
select count(*) from (select distinct report_id from
resource_statuses)as count;
Am I missing something?
It seems to me this can be fixed by just making the table "cascade on delete",
though I'll freely admit I have only enough ruby experience to get a little
ways past Hello World.
--
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.
