Puppet users - Nov 2012 - Please document reports:prune Task Leaves Orphaned Data in Dashboard Documentation

Dear Puppet Labs

I recently upgraded dashboard from 1.2.2 to 1.2.14. It was somewhat painful
given the number of orphaned records that needed purging during database
conversion

Some weeks later, my 20 Gb mysql partition fills up with what should be a
1.5 Gb database. I assumed that with the orphaned record script being
created, the purging old records would no longer create orphaned records in
1.2.14

I was wrong, and see it is documented for PE (
http://docs.puppetlabs.com/pe/2.0/welcome_known_issues.html#consoles-reportsprune-task-leaves-orphaned-data)
but not in the open source dashboard (
http://docs.puppetlabs.com/dashboard/manual/1.2/maintaining.html)

Can you please save others my experience and update the open source page?
I''ve created https://projects.puppetlabs.com/issues/17712 for this
request

Thanks

John

-- 
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+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On Mon, 19 Nov 2012 09:32:27 +1100, John Warburton <jwarburton@gmail.com>
wrote:
> Dear Puppet Labs
> 
> I recently upgraded dashboard from 1.2.2 to 1.2.14. It was somewhat
painful
> given the number of orphaned records that needed purging during database
> conversion
> 
> Some weeks later, my 20 Gb mysql partition fills up with what should be
a
> 1.5 Gb database. I assumed that with the orphaned record script being
> created, the purging old records would no longer create orphaned records
in
> 1.2.14
> 
> I was wrong, and see it is documented for PE (
>
http://docs.puppetlabs.com/pe/2.0/welcome_known_issues.html#consoles-reportsprune-task-leaves-orphaned-data)
> but not in the open source dashboard (
> http://docs.puppetlabs.com/dashboard/manual/1.2/maintaining.html)
> 
> Can you please save others my experience and update the open source
page?
> I''ve created https://projects.puppetlabs.com/issues/17712 for this
request
> 
> Thanks
> 
> John
Also keep in mind that mysql is unable to release table space once it has
allocated it.


Best Regards, David

-- 
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+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.

On 19 November 2012 22:25, David Schmitt <david@dasz.at> wrote:
>
> Also keep in mind that mysql is unable to release table space once it has
> allocated it.
>
Indeed - I call mysqlcheck to optimize the tables and recover the space.
This is my purge reports script:

rake --silent RAILS_ENV=production reports:prune upto=11 unit=day > $LOG
2>&1
rake --silent RAILS_ENV=production reports:prune:orphaned >> $LOG
2>&1
mysqlcheck -u $USER --password=$PASSWORD --optimize --databases
$DATABASE
>> $LOG 2>&1
Regards

John

-- 
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+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.